home / mcp / sap fieldglass mcp server

SAP Fieldglass MCP Server

This read-only MCP Server allows you to connect to SAP Fieldglass data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for SAP Fieldglass (https://www.cdata.com/drivers/sapfieldglass/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-sap-fieldglass-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/sap-fieldglass.prp"
      ]
    }
  }
}

You can query live SAP Fieldglass data through a read-only MCP server that wraps the CData JDBC Driver. It exposes Fieldglass data via a simple MCP interface so you can ask natural language questions and receive up-to-date results without writing SQL.

How to use

Once you have the MCP server running, connect your AI client to the MCP endpoint. You can ask questions like which opportunities are open, what is the status of a particular project, or how many active tickets exist for a specific workspace. The server translates your natural language requests into read-only data queries against SAP Fieldglass via the JDBC driver, returning results in a structured, easy-to-parse form. Use the built-in tools by simply addressing the server with natural language prompts; you do not need to craft SQL queries.

How to install

Prerequisites: Java installed on your machine and Maven for builds.

1. Clone the project and enter the directory.

git clone https://github.com/cdatasoftware/sap-fieldglass-mcp-server-by-cdata.git
cd sap-fieldglass-mcp-server-by-cdata

2. Build the MCP server to create the runnable JAR.

mvn clean install

3. Obtain and install the CData JDBC Driver for SAP Fieldglass. Follow the driver download and installation instructions from the CData site.

4. License the CData JDBC Driver.

java -jar cdata.jdbc.sapfieldglass.jar --license
```
Enter your name, email, and TRIAL (or your license key) when prompted.

5. Configure your connection to the data source. Use the Connection String utility to build and test the connection. If OAuth is used, authenticate in your browser. Copy the resulting connection string for later use.

java -jar cdata.jdbc.sapfieldglass.jar
```
Configure the connection string and click Test Connection. Copy the connection string when ready.

6. Create a properties file for the JDBC connection. Save it as sap-fieldglass.prp with these properties.

Prefix=sapfieldglass
ServerName=CDataSAPFieldglass
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.sapfieldglass.jar
DriverClass=cdata.jdbc.sapfieldglass.SAPFieldglassDriver
JdbcUrl=jdbc:sapfieldglass:InitiateOAuth=GETANDREFRESH;
Tables=

7. Save the file and place it in a known location. This file instructs the MCP server which data source and tables to expose.

Using Claude Desktop with the SAP Fieldglass MCP server

To enable Claude Desktop (or another MCP client) to use the server, add a config entry that points to the Java runtime and includes the MCP JAR and your sap-fieldglass.prp file.

{
  "mcpServers": {
    "sapfieldglass_mcp": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sap-fieldglass.prp"
      ]
    }
  }
}

Running the server

Start the MCP server on its own using the final run command. The server runs over stdio and is intended for use with clients on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Usage details and tools

After configuration, you can query the data using the MCP client’s built-in tools. You don’t need to invoke raw tools directly; simply ask questions and the client will leverage the available tools to read data.

The available tools are named using the server prefix, and include the following capabilities.

- sapfieldglass_mcp_get_tables retrieves a list of accessible tables - sapfieldglass_mcp_get_columns retrieves columns for a chosen table - sapfieldglass_mcp_run_query executes a SQL SELECT against the exposed data

Troubleshooting

If you cannot see your MCP server in the client, ensure you have fully exited the client and restarted it. If the client cannot retrieve data, verify your connection string is correct and test the connection again. If you encounter issues connecting, contact CData Support. For other feedback or trouble, join the CData Community.

Notes and security

This MCP server is read-only by design to provide safe, live access to SAP Fieldglass data for query-based prompts. If you require full read, write, update, delete, and action capabilities, explore the dedicated MCP server option that supports those features.

Available tools

sapfieldglass_mcp_get_tables

Retrieves a list of available tables from the SAP Fieldglass data source. Output is in CSV with column headers on the first line.

sapfieldglass_mcp_get_columns

Retrieves the list of columns for a specified table. Output is CSV with column headers on the first line.

sapfieldglass_mcp_run_query

Executes a SQL SELECT query against the exposed SAP Fieldglass tables and returns the result set.