SAP NetWeaver Gateway MCP server

The CData MCP Server for SAP Netweaver Gateway allows LLMs (like Claude Desktop) to query live SAP data through a simple natural language interface. This server works by wrapping the CData JDBC Driver for SAP Netweaver Gateway, transforming SAP data into an MCP interface that LLMs can interact with directly.

Installation Guide

Prerequisites

Before you begin, ensure you have:

• Java runtime environment installed
• Maven for building the project
• Access to SAP Netweaver Gateway

Step-by-Step Setup

1. Clone and Build the Repository

git clone https://github.com/cdatasoftware/sap-netweaver-gateway-mcp-server-by-cdata.git
cd sap-netweaver-gateway-mcp-server-by-cdata
mvn clean install

2. Install the CData JDBC Driver

Download and install the CData JDBC Driver for SAP Netweaver Gateway from CData's website.

3. License the JDBC Driver

Navigate to the installation directory's lib folder:

• Windows: C:\Program Files\CData\CData JDBC Driver for SAP Netweaver Gateway\
• Mac/Linux: /Applications/CData JDBC Driver for SAP Netweaver Gateway/

Run the licensing command:

java -jar cdata.jdbc.sapgateway.jar --license

Enter your name, email, and "TRIAL" (or your license key).

4. Configure Your SAP Connection

Open the connection string utility:

java -jar cdata.jdbc.sapgateway.jar

Configure your connection settings in the utility and test the connection. Once successful, copy the connection string for the next step.

5. Create Configuration File

Create a .prp file (e.g., sap-netweaver-gateway.prp) with the following properties:

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=

Replace the DriverPath with the full path to your JDBC driver JAR file, and update the JdbcUrl with your connection string from the previous step.

Setting Up with Claude Desktop

Create Configuration File

Create a claude_desktop_config.json file or modify your existing one:

Windows

{
  "mcpServers": {
    "sapgateway": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sap-netweaver-gateway.prp"
      ]
    }
  }
}

Mac/Linux

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

Place the Configuration File

Copy the config file to the appropriate directory:

Windows

cp C:\PATH\TO\claude_desktop_config.json %APPDATA%\Claude\claude_desktop_config.json

Mac

cp /PATH/TO/claude_desktop_config.json /Users/{user}/Library/Application\ Support/Claude/claude_desktop_config.json

Refresh Claude Desktop

Fully exit Claude Desktop and relaunch it for the MCP server to appear.

Using the MCP Server

Running the Server Independently

To run the MCP server without Claude Desktop:

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

Available Tools

The MCP server provides the following tools (replace {servername} with your configured server name, e.g., sapgateway):

• {servername}_get_tables: Lists available tables in SAP Netweaver Gateway
• {servername}_get_columns: Shows columns for a specific table
• {servername}_run_query: Executes SQL SELECT queries

Querying Data with Claude

Simply ask Claude questions about your SAP data using natural language. For example:

• "What SAP tables are available?"
• "Show me the structure of the Customer table"
• "How many open orders do we have this month?"

Claude will automatically use the appropriate tools to retrieve the data.

Troubleshooting

• Server not showing in Claude: Fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restart it
• Connection issues: Verify your connection string using the CData Connection String utility
• Support: For connection problems, contact the CData Support Team
• Community help: Join the CData Community for assistance with the MCP server

How to install this MCP server

For Claude Code

To add this MCP server to Claude Code, run this command in your terminal:

claude mcp add-json "sap-netweaver-gateway" '{"command":"java","args":["-jar","PATH/TO/CDataMCP-jar-with-dependencies.jar","PATH/TO/sap-netweaver-gateway.prp"]}'

See the official Claude Code MCP documentation for more details.

For Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > Tools & Integrations and click "New MCP Server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

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

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.

For Claude Desktop

To add this MCP server to Claude Desktop:

1. Find your configuration file:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json
• Linux: ~/.config/Claude/claude_desktop_config.json

2. Add this to your configuration file:

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

3. Restart Claude Desktop for the changes to take effect