saphybris_get_tablesLABSCO SUMMARY
The licensed driver does the hard part.
Three tools is the whole surface, and that is the point — the JDBC driver turns SAP Hybris C4C into ordinary tables, so the model writes SELECT statements instead of learning an API shape. What you trade for that is a driver install and a licensing step before the first query, and a server that only reads: there is no write, update, or delete path here.
What it is
A local Java server that puts SAP Hybris C4C behind three SQL tools. CData's JDBC Driver for SAP Hybris C4C exposes the service as relational tables, and this server wraps the driver so a model can find a table, read its columns, and run a SELECT against live data without anyone writing the API calls.
What you get
saphybris_get_tablesreturns the tables the driver exposes, as CSV with a header rowsaphybris_get_columnsreturns the columns on one table, in the same CSV shapesaphybris_run_queryexecutes a SQL SELECT statement- The
saphybrispart is thePrefixyou set in the property file (Prefix=saphybrisin the sample), so several CData servers can sit in one client without their tool names colliding - 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
Build it yourself: clone the repository and run mvn clean install, which produces CDataMCP-jar-with-dependencies.jar. Install the CData JDBC Driver for SAP Hybris C4C separately and license it — java -jar cdata.jdbc.saphybris.jar --license, then name, email, and TRIAL or your key. Write a sap-hybris-c4c.prp file carrying DriverClass=cdata.jdbc.saphybris.SAPHybrisDriver and the JDBC URL from the driver's connection-string utility, and launch the server as java -jar CDataMCP-jar-with-dependencies.jar sap-hybris-c4c.prp. Transport is stdio, so the server runs on the same machine as the client.
Setup effort
Build from source — git clone https://github.com/cdatasoftware/sap-hybris-c4c-mcp-server-by-cdata.git
USE CASES
01
Answering a question about live SAP Hybris C4C data
Ask in plain language; the model locates the table, checks its columns, then writes the SELECT itself.
02
Finding out what is actually available
List the tables and their columns first, so you know what can be asked before you ask it.
03
Running several CData sources in one client
Give each property file its own Prefix so the tool names stay distinct across servers.
3 tools
Listed in project docs. Your client may show a different list.
saphybris_get_columnssaphybris_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Tool names start with the Prefix in the .prp file, such as saphybris_get_tables. Read-only: run_query executes SELECT only, even though the README's usage notes say the client can write, update and delete.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone and build this one yourself.
Server setup
TERMINAL
git clone https://github.com/cdatasoftware/sap-hybris-c4c-mcp-server-by-cdata.git
cd sap-hybris-c4c-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for SAP Hybris C4C from https://www.cdata.com/drivers/saphybris/download/jdbc
License the driver: from the driver install's lib folder run java -jar cdata.jdbc.saphybris.jar --license, then enter your name, email, and "TRIAL" (or your license key)
Build the connection string: run java -jar cdata.jdbc.saphybris.jar to open the Connection String utility, click "Test Connection" (browser OAuth if the source needs it), and copy the connection string
Create sap-hybris-c4c.prp with:
FILE · sap-hybris-c4c.prp
Prefix=saphybris
ServerName=CDataSAPHybris
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.saphybris.SAPHybrisDriver
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 — macOS / Linux
CLAUDE DESKTOP — MACOS / LINUX · JSON
{
"mcpServers": {
"sap-hybris-c4c": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_SAP_HYBRIS_C4C>"
]
}
}
}