Three tools and no write path is the whole design: the model discovers tables, reads columns and runs SELECTs, so a badly framed question produces a wrong answer rather than a changed record. Two things decide whether it fits. The CData JDBC driver is a separate licensed product, with a trial key to start on. And the `Tables` field in the connection profile is where you choose how much of SAP ByDesign is reachable — left blank, everything the connection can see is in scope.
A read-only MCP server built on CData's JDBC Driver for SAP ByDesign. The driver exposes SAP ByDesign as relational tables; the server puts three tools over it, so a client can discover what tables exist, read a table's columns, and run a SELECT — without anyone writing SQL by hand.
- The tables the driver exposes for SAP ByDesign, returned as CSV with a header row — `sapbydesign_get_tables`
- The columns of one of those tables, also as CSV, so a query can be composed against real field names — `sapbydesign_get_columns`
- A SQL SELECT executed against live SAP ByDesign data — `sapbydesign_run_query`
- Tool names that carry the prefix you set in the connection profile — the sample uses `Prefix=sapbydesign` — so several CData servers can run side by side without colliding
- A `Tables` field in the profile that decides how much of SAP ByDesign is visible at all: leave it blank for everything the connection can reach, or list the tables you want exposed
Java and Maven to build — `mvn clean install` produces `CDataMCP-jar-with-dependencies.jar`. The CData JDBC Driver for SAP ByDesign is a separate download and needs licensing: run `java -jar cdata.jdbc.sapbydesign.jar --license` and enter a name, an email and either `TRIAL` or a licence key. Connection settings go in a `.prp` file carrying `Prefix`, `ServerName` (the sample uses `CDataSAPByDesign`), `ServerVersion`, `DriverPath`, `DriverClass` (`cdata.jdbc.sapbydesign.SAPByDesignDriver`), the `JdbcUrl` produced by the driver's connection-string utility, and the optional `Tables` list. The client then launches `java -jar CDataMCP-jar-with-dependencies.jar <your>.prp`. Transport is stdio, so the server has to run on the same machine as the client. If the data source authenticates over OAuth, you approve it in a browser while building the connection string.