home / mcp / sap netweaver gateway mcp server

SAP Netweaver Gateway MCP Server

This read-only MCP Server allows you to connect to SAP Netweaver Gateway data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for SAP Netweaver Gateway (https://www.cdata.com/drivers/sapgateway/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-sap-netweaver-gateway-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/sap-netweaver-gateway.prp"
      ]
    }
  }
}

This MCP Server provides a read-only interface to SAP Netweaver Gateway data via the CData JDBC Driver. It exposes live SAP Netweaver Gateway information through a simple MCP API so you can ask natural-language questions and receive up-to-date results without writing SQL.

How to use

You connect an MCP client to the SAP Netweaver Gateway MCP Server to read live data. Once the server is running, you can ask questions or invoke the built-in tools to explore data, such as listing available tables, inspecting column details, or querying data with SELECT-like operations. The server translates your requests into JDBC queries under the hood and returns results in a structured format.

How to install

Prerequisites: ensure you have Java installed and a Java build tool available (Maven is used to build the project). You will also need access to the CData JDBC Driver for SAP Netweaver Gateway.

1. Clone the MCP server project and enter its directory.

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 server to produce the executable JAR.

mvn clean install

3. Obtain and license the CData JDBC Driver for SAP Netweaver Gateway. Follow the driver’s licensing steps compatible with your OS, then verify the driver is usable from the command line.

4. Configure the JDBC connection using the driver’s connection utility to generate a connection string. Save the resulting string for later use when creating the MCP PRP file.

5. Create a PRP file that describes the JDBC connection. Example properties include Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables. You will reference this PRP in the next steps.

Prefix=sapgateway
ServerName=CDataSAPGateway
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.sapgateway.jar
DriverClass=cdata.jdbc.sapgateway.SAPGatewayDriver
JdbcUrl=jdbc:sapgateway:InitiateOAuth=GETANDREFRESH;
Tables=

Running the server

Start the MCP server on its own using the built JAR and your PRP file. The server runs on standard I/O so you can connect from clients on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-netweaver-gateway.prp

Additional notes

The MCP server is designed for read operations by default. If you need to integrate with Claude Desktop or another MCP client, follow the client setup instructions to add the SAP Netweaver Gateway MCP server as an MCP source. You can use tools to list tables, fetch columns, and run queries against the SAP Netweaver Gateway data source.

Available tools

sapgateway_get_tables

Retrieves a list of tables available in the SAP Netweaver Gateway data source. The output is returned in CSV format with column headers on the first line.

sapgateway_get_columns

Retrieves a list of columns for a specified table. The output is returned in CSV format with column headers on the first line.

sapgateway_run_query

Executes a SQL SELECT-like query against the data source to fetch the requested data.