sap-erp -by-cdata

sap-erp-mcp-server-by-cdata exposes SAP ERP data through a read-only MCP server built on top of the CData JDBC driver. Once the server is running, you can query live SAP ERP data using the MCP tools without writing SQL directly. The server defines a set of tools named after the server, such as sap-erp_get_tables, sap-erp_get_columns, and sap-erp_run_query, which let you discover available tables, inspect columns, and execute SELECT queries against your SAP ERP data source. Claude Desktop or other MCP clients connect to the server by loading a configuration entry that points to the running Java process and the .prp connection file that configures the JDBC connection. Tools return results in CSV for tabular data and can be invoked through JSON-RPC calls if you script interactions.

Prerequisites:

• Java Runtime Environment (JRE) or JDK 8+ installed on the host where the MCP server will run
• Maven (for building from source)
• Access to the CData JDBC Driver for SAP ERP and a valid license

Setup and installation steps:

1. Clone the repository and navigate to it: git clone https://github.com/cdatasoftware/sap-erp-mcp-server-by-cdata.git cd sap-erp-mcp-server-by-cdata

2. Build the MCP server jar (produces CDataMCP-jar-with-dependencies.jar): mvn clean install

3. Install and license the CData JDBC Driver for SAP ERP following the driver installation guide provided by CData. This typically involves:

   • Downloading the SAP ERP JDBC driver JARs
   • Running the license command against the driver jar as described in the CData docs

4. Create a .prp (property) file for your JDBC connection (example sap-erp.prp): Prefix=saperp ServerName=CDataSAPERP ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.saperp.jar DriverClass=cdata.jdbc.saperp.SAPERPDriver JdbcUrl=jdbc:saperp:InitiateOAuth=GETANDREFRESH; Tables=

5. Run the MCP server using the generated jar and your .prp file: java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-erp.prp

Note: The MCP server uses stdio, so it works with clients that run on the same machine as the server. Ensure that the Java process has access to the JDBC driver and the .prp file path you provide.

Tips and common issues:

• Ensure the Java process can reach the JDBC driver JARs and the sap-erp.prp file; use absolute paths in the .prp file when possible.
• If Claude Desktop cannot detect the MCP server, fully quit and restart the client to refresh the server list.
• If you modify the .prp file or JDBC connection, restart the MCP server for changes to take effect.
• The built-in tools are named using the server identifier, e.g., sap-erp_get_tables, sap-erp_get_columns, sap-erp_run_query; use these when scripting with JSON-RPC.
• For data source OAuth flows, you may need to authenticate in the browser during initial connection setup.
• If you encounter issues, consult the CData Support Team or Community forums for driver-specific troubleshooting.