sapfieldglass_get_tablesLABSCO SUMMARY
A SQL view over the contractor programme.
Fieldglass answers are usually locked behind a report you have to request: who is on assignment, at what rate, under which supplier. Exposed as relational tables with a SELECT in front, those become questions you can just ask. The server never writes, so nothing you ask can disturb the programme — and the setup cost is a Maven build, a licensed driver install and a property file.
What it is
A local, read-only bridge between an assistant and SAP Fieldglass. CData's JDBC driver exposes SAP Fieldglass as relational SQL models; this server wraps the driver so a model can discover the tables and query them, and you can ask in plain language instead of writing SQL. It runs over stdio, so the client has to be on the same machine.
What you get
get_tableslists the tables the driver exposes, returned as CSV with a header rowget_columnslists the columns on one of those tables, in the same CSV shaperun_queryexecutes a SQL SELECT against live SAP Fieldglass data- Tool names carry the prefix you set in the property file — the sample config uses
Prefix=sapfieldglass - A
Tablessetting that only picks which tables also get a ready-made description (blank means none); it does not limit what the tools can list or query, so limit the connection or the account it signs in with
Requirements
Java and Maven: mvn clean install builds CDataMCP-jar-with-dependencies.jar. Separately install the CData JDBC Driver for SAP Fieldglass and license it by running java -jar cdata.jdbc.sapfieldglass.jar --license, entering TRIAL or a license key. Build the connection string with the same jar, authenticating in the browser if the source uses OAuth, then write a .prp file naming the driver path, the driver class cdata.jdbc.sapfieldglass.SAPFieldglassDriver and that JDBC URL. Point your client at java -jar with the built jar and the .prp file.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
Finding out how the workforce data is modelled
List the tables the driver publishes, then the columns on the one you need.
Answering a staffing question without a report request
Ask in plain language; the assistant writes the SELECT and reads the CSV back.
Checking supplier and rate detail against the source
Query the underlying records directly instead of working from an export.
3 tools
Listed in project docs. Your client may show a different list.
sapfieldglass_get_columnssapfieldglass_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. All three are read-only: sapfieldglass_run_query runs SQL SELECT only, and write access is a separate paid CData product. Names carry the prefix you configure (sapfieldglass_get_tables with Prefix=sapfieldglass). The Tables setting does not limit what the tools reach; your connection's access does.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Clone the repository, then point your client at the binary. This one is built from source rather than installed with a single command.
Server setup
git clone https://github.com/cdatasoftware/sap-fieldglass-mcp-server-by-cdata.git
cd sap-fieldglass-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for SAP Fieldglass from https://www.cdata.com/drivers/sapfieldglass/download/jdbc
License the driver: from the driver install's lib folder run java -jar cdata.jdbc.sapfieldglass.jar --license, then enter your name, email, and "TRIAL" (or your license key)
Build the connection string: run java -jar cdata.jdbc.sapfieldglass.jar to open the Connection String utility, click "Test Connection" (browser OAuth if the source needs it), and copy the connection string
Create sap-fieldglass.prp with:
Prefix=sapfieldglass
ServerName=CDataSAPFieldglass
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.sapfieldglass.SAPFieldglassDriver
JdbcUrl=<YOUR_JDBC_URL>
Tables=Tables only picks which tables also get a ready-made description for your assistant, and empty means none; the server can still list and query every table your connection string reaches, so to keep data out of reach, limit that connection or the account it signs in with.
Add the mcpServers entry below to claude_desktop_config.json and fully restart the client
MCP Clients
Claude Desktop — Linux, macOS
{
"mcpServers": {
"sap-fieldglass": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_SAP_FIELDGLASS>"
]
}
}
}