SAP Concur

You can query live SAP Concur data through a local MCP server that wraps the CData JDBC driver, exposing SAP Concur data as easy-to-use MCP tools. This lets you ask natural language questions and retrieve up-to-date information without writing SQL. The server is read-only by default, designed to be simple to run on your machine for testing or lightweight querying.

How to use

After you start the MCP server, you connect an MCP client to it. Use the built-in tools to read data from SAP Concur through the MCP interface. You can ask questions like which opportunities are open, which calendar events you have today, or how many tickets are in a given status. The server translates your natural language requests into queries against the SAP Concur data source via the CData JDBC driver, returning results in a structured format for the client to present.

How to install

# Prerequisites
- Java runtime (JRE) 8+ or compatible
- Maven for building the project

# 1) Clone the project
git clone https://github.com/cdatasoftware/sap-concur-mcp-server-by-cdata.git
cd sap-concur-mcp-server-by-cdata

# 2) Build the server
mvn clean install
# This creates the JAR: CDataMCP-jar-with-dependencies.jar

# 3) Install the CData JDBC Driver for SAP Concur
# Download from: https://www.cdata.com/drivers/concur/download/jdbc

# 4) License the driver (example paths; adjust for your OS)
# Windows
# java -jar cdata.jdbc.concur.jar --license
# Mac/Linux
# java -jar cdata.jdbc.concur.jar --license

# 5) Configure your connection to the data source (example uses Salesforce in guidance)
# java -jar cdata.jdbc.concur.jar
# Then Test Connection and copy the generated JDBC URL when ready

# 6) Create a .prp file for your JDBC connection
# Example content (sap-concur.prp):
Prefix=concur
ServerName=CDataConcur
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.concur.jar
DriverClass=cdata.jdbc.concur.ConcurDriver
JdbcUrl=jdbc:concur:InitiateOAuth=GETANDREFRESH;
Tables=

# Start the MCP server using the stored .prp file
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-concur.prp

Note: The server runs with stdio, so it must be on the same machine as your MCP client.

## Additional configuration and notes

The server is designed to be run locally for read-only access to SAP Concur data. It uses the JDBC driver to expose data sources and allows you to ask questions through your MCP client without writing SQL. If you plan to use OAuth-based connections, you will need to complete the browser authentication step during the driver setup.

If you need to use Claude Desktop or another MCP client, configure the client to load the MCP server and point it to the CDataMCP-jar-with-dependencies.jar with the sap-concur.prp file, as shown in the client configuration example.

## Troubleshooting

If you cannot see the MCP server in your client, fully quit the client and relaunch. Ensure the .prp file is correctly referenced and that the JDBC connection string is valid. If you encounter data retrieval issues, recheck the connection configuration and test the connection from the JDBC driver utility. If problems persist, contact support or seek help from the CData Community.

## Available tools

### sapconcur\_mcp\_get\_tables

Retrieves a list of tables available in the SAP Concur data source. The output is in CSV format with a header row describing the columns.

### sapconcur\_mcp\_get\_columns

Retrieves a list of columns for a specified table. The output is in CSV format with a header row describing the columns.

### sapconcur\_mcp\_run\_query

Executes a SQL SELECT query against the SAP Concur data source and returns the results.