home / mcp / sap ariba procurement mcp server
This read-only MCP Server allows you to connect to SAP Ariba Procurement data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).
Configuration
View docs{
"mcpServers": {
"cdatasoftware-sap-ariba-procurement-mcp-server-by-cdata": {
"command": "java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/sap-ariba-procurement.prp"
]
}
}
}You run a local, read-only MCP server that exposes SAP Ariba Procurement data via a simple MCP interface. It lets you ask natural-language questions and get live data without writing SQL, while keeping the data access on your machine for secure, private queries.
You will connect an MCP client to a local MCP server that runs on your machine. Start the server with a single command and keep the session running on the same host as your client. Once running, you can ask your AI client to read from SAP Ariba Procurement data, retrieve tables and columns, or run read-only queries. The server exposes predefined tools that let the AI client explore tables, view columns, and retrieve data without you writing SQL. Use natural language prompts such as asking for counts, summaries, or correlations across procurement data, and the AI client will map those requests to the available MCP tools.
Typical capabilities include listing available tables, listing columns within a table, and executing read-only queries to retrieve results. You don’t need to know SQL to use these features; you simply ask questions and let the AI client leverage the built-in tools to fetch the data you need.
Prerequisites: Java Runtime Environment (JRE) and Maven must be installed on your system to build and run the MCP server.
1. Clone the project repository and navigate into the folder.
git clone https://github.com/cdatasoftware/sap-ariba-procurement-mcp-server-by-cdata.git
cd sap-ariba-procurement-mcp-server-by-cdata2. Build the server to produce the executable JAR.
mvn clean install3. Obtain and install the CData JDBC Driver for SAP Ariba Procurement.
https://www.cdata.com/drivers/saparibaprocurement/download/jdbc4. License the CData JDBC Driver. Run the license command from the driver’s lib directory and follow the prompts.
java -jar cdata.jdbc.saparibaprocurement.jar --license
```
(Enter your name, email, and the word TRIAL or your license key as prompted.)5. Configure the connection to your data source using the JDBC Driver’s Connection String utility. After testing, copy the connection string for use in the MCP properties file.
java -jar cdata.jdbc.saparibaprocurement.jar
```
Test the connection and copy the JDBC URL when the test succeeds.6. Create a .prp MCP properties file with the JDBC connection details. Use the following template and fill in your values.
Prefix=saparibaprocurement
ServerName=CDataSAPAribaProcurement
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.saparibaprocurement.jar
DriverClass=cdata.jdbc.saparibaprocurement.SAPAribaProcurementDriver
JdbcUrl=jdbc:saparibaprocurement:InitiateOAuth=GETANDREFRESH;
Tables=Prepare Claude Desktop or another MCP client to load your local MCP server definition. Add a new MCP server entry that points to the local Java process and the .prp file you created.
If you prefer to run the server from the command line, you will execute a single Java command with the server properties file.
The MCP server runs locally and uses stdio for communication, so the client and server must be on the same machine. Start the server once the .prp file is prepared, and then launch your MCP client to connect to that local instance. Use descriptive prefixes for your server to clearly identify it among multiple MCP servers.
If you cannot see or connect to your local MCP server, ensure you have fully quit and restarted your MCP client after adding or updating the server configuration. Verify the path to the JAR and the .prp file are correct and that the JDBC driver license is valid. If the client cannot retrieve data, double-check your JDBC connection string and test it with the driver utility again. If issues persist, contact CData Support or the Community for help.
This MCP server is distributed under the MIT License. You may use, modify, and distribute the software in compliance with the license terms.
Retrieves a list of tables available in the SAP Ariba Procurement data source. The output is CSV with a header row of column names.
Retrieves the list of columns for a specified table. The output is CSV with a header row of column names.
Executes a read-only SQL SELECT query against the SAP Ariba Procurement data source and returns the results.