saparibasource_get_tablesLABSCO SUMMARY
Sourcing events as rows you can filter, rather than screens you page through.
The CData JDBC Driver exposes SAP Ariba Source as relational models, which is what makes cross-event questions tractable: suppliers invited across events, awards by category, events still open. The server reads only, so exploring the data cannot change a sourcing event.
What it is
A Java MCP server that puts CData's JDBC Driver for SAP Ariba Source behind three read-only tools: list the tables, list a table's columns, and run a SQL SELECT. The driver is what does the work — it exposes SAP Ariba Source as relational SQL models — and the server hands those models to your client so you can ask questions in plain language instead of writing SQL yourself.
What you get
get_tablesreturns the tables available in the data source, as CSV with a header rowget_columnsreturns the columns of one table, in the same CSV shaperun_queryexecutes a SQL SELECT and returns the rows- Every tool name starts with the
Prefixvalue from your.prpfile, so several CData servers can run side by side without colliding - You ask about your sourcing data in plain language and the client picks the tools and writes the SQL — no need to know the table names first
Requirements
Build the server with mvn clean install, which produces CDataMCP-jar-with-dependencies.jar. Separately download the CData JDBC Driver for SAP Ariba Source and license it: run java -jar cdata.jdbc.saparibasource.jar --license and enter your name, email and either TRIAL or a licence key. Then write a .prp file naming DriverClass=cdata.jdbc.saparibasource.SAPAribaSourceDriver plus the JdbcUrl you build in the driver's connection-string utility, and point your client at java -jar with the jar and that file. Transport is stdio, so the server has to run on the same machine as the client.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
Reviewing open sourcing events
One query rather than paging through the Ariba interface.
Checking supplier participation
Join the supplier and event tables and filter to the category you care about.
Learning the schema
List tables and columns before committing to a reporting approach.
3 tools
Listed in project docs. Your client may show a different list.
saparibasource_get_columnssaparibasource_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Tool names carry the Prefix from your .prp file: with the sample Prefix=saparibasource they are saparibasource_get_tables, saparibasource_get_columns and saparibasource_run_query. All three only read. The Tables setting does not limit what the tools reach; your connection's access does.
Where it runs
Both documented setups run 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-ariba-source-mcp-server-by-cdata.git
cd sap-ariba-source-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for SAP Ariba Source from https://www.cdata.com/drivers/saparibasource/download/jdbc
License the driver: from the driver install's lib folder run java -jar cdata.jdbc.saparibasource.jar --license, then enter your name, email, and "TRIAL" (or your license key)
Build the connection string: run java -jar cdata.jdbc.saparibasource.jar to open the Connection String utility, click "Test Connection" (browser OAuth if the source needs it), and copy the connection string
Create sap-ariba-source.prp with:
Prefix=saparibasource
ServerName=CDataSAPAribaSource
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.saparibasource.SAPAribaSourceDriver
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 — Windows, macOS, Linux
{
"mcpServers": {
"sap-ariba-source": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_SAP_ARIBA_SOURCE>"
]
}
}
}