SAP Business One MCP Server by CData

What is SAP Business One MCP Server by CData?

The SAP Business One MCP Server by CData is a read-only Model Context Protocol server that lets LLMs like Claude Desktop query live SAP Business One data using natural language. It wraps the CData JDBC Driver for SAP Business One, exposing the data as relational SQL models through a simple MCP interface.

How to use SAP Business One MCP Server by CData?

Clone the repository, build with Maven, download and license the CData JDBC Driver for SAP Business One, configure the connection string, and create a .prp property file. Then add the server to your Claude Desktop configuration (claude_desktop_config.json) and restart the client. The server runs on stdio and must be on the same machine as the client.

Key features of SAP Business One MCP Server by CData

• Read-only access to live SAP Business One data
• Natural language querying – no SQL required
• Built on the CData JDBC Driver for SAP Business One
• Exposes get_tables, get_columns, and run_query tools
• Uses standard MCP stdio transport
• Open-source under the MIT License

Use cases of SAP Business One MCP Server by CData

• Ask Claude Desktop about correlations between closed-won opportunities and account industry
• Retrieve counts of open tickets in a specific project
• Get today’s calendar events from SAP Business One
• Explore available tables and columns in the data source
• Run custom SQL SELECT queries on the data

FAQ from SAP Business One MCP Server by CData

Is this server read-only or read-write?

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, use the free CData MCP Server for SAP Business One (beta) linked in the README.

What are the runtime requirements?

Java, Maven, and the CData JDBC Driver for SAP Business One must be installed. The driver must be licensed (trial or permanent key) before use.

Where does the data live?

The data is queried live from SAP Business One via the JDBC driver – no local data copy is made.

How do I connect to my SAP Business One instance?

Use the provided connection string utility (java -jar cdata.jdbc.sapbusinessone.jar) to build a JDBC URL (e.g., jdbc:sapbusinessone:InitiateOAuth=GETANDREFRESH), then store it in a .prp file with the required properties.

Are there any known limitations?

The server uses stdio transport, so it can only run with clients on the same machine. It is read-only and does not support write, update, or delete operations.