This MCP server exposes live SAP NetWeaver Gateway data via a read-only MCP interface by wrapping the CData JDBC driver. It presents a set of tools that allow clients to discover the data source, inspect available tables and columns, and run read-only queries against the underlying SAP NetWeaver Gateway data. The key tools exposed follow the pattern {servername}_{action}, where {servername} is the server name you configured in Claude Desktop. Typical actions include _get_tables to retrieve a list of available tables, _get_columns to list columns for a given table, and _run_query to execute a SELECT against the data. For Claude Desktop, you would add an entry in claude_desktop_config.json that points to the local Java process started with the sap-netweaver-gateway.prp file, enabling natural language questions such as “What are the customers with open invoices?” to be translated into SQL behind the scenes.

Prerequisites:

• Java Runtime Environment (JRE) or JDK installed and available on PATH
• Maven installed (for building the MCP server)
• Access to the internet to clone the repository and download dependencies

Installation steps:

1. Clone the repository git clone https://github.com/cdatasoftware/sap-netweaver-gateway-mcp-server-by-cdata.git cd sap-netweaver-gateway-mcp-server-by-cdata

2. Build the MCP server jar mvn clean install

   This produces CDataMCP-jar-with-dependencies.jar

3. Obtain and license the CData JDBC Driver for SAP NetWeaver Gateway

   • Download the driver from https://www.cdata.com/drivers/sapgateway/download/jdbc
   • Install it following the vendor instructions
   • License (example placement) the driver: java -jar cdata.jdbc.sapgateway.jar --license

4. Create a .prp configuration file for your data source (example sap-netweaver-gateway.prp)

   • Include Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables as demonstrated in the README

5. Run the MCP server

   • Place the SAP NetWeaver Gateway prp file somewhere accessible, then run: java -jar /path/to/CDataMCP-jar-with-dependencies.jar /path/to/sap-netweaver-gateway.prp

6. Integrate with Claude Desktop (optional)

   • Edit claude_desktop_config.json to add an entry under mcpServers pointing to the Java command and the prp path as shown in the README
   • Restart Claude Desktop to load the new MCP server

Prereqs recap: JDK, Maven, access to the CData SAP NetWeaver Gateway JDBC driver, and a properly configured sap-netweaver-gateway.prp file.

Tips and common issues:

• The MCP server uses stdio, so it should run on the same machine as clients like Claude Desktop.
• Ensure the JDBC driver is licensed and the DriverPath in the .prp file correctly points to the driver jar.
• If Claude Desktop cannot see the MCP server, fully quit and relaunch the client to refresh the server list.
• If data cannot be retrieved, double-check the connection string in the .prp (JdbcUrl) and validate the connection using the driver’s connection utilities.
• When generating claude_desktop_config.json, ensure the paths used in command and args are absolute and accessible by the user running Claude Desktop.