sap-businessobjects-bi -by-cdata

This MCP server provides a read-only interface to SAP BusinessObjects BI via the CData JDBC driver. It exposes a minimal set of tools that let an AI client query metadata and data without writing SQL directly. You can retrieve available tables and their columns, and run SELECT queries against the underlying SAP BusinessObjects BI data source through the built-in MCP tools. The server runs on the local machine and communicates over standard MCP tooling interfaces; clients should connect to the server using the configured JSON-RPC tool endpoints described in the README. Use natural language prompts to ask questions about your data, and the client will translate them into tool invocations under the hood.

Available tools follow a consistent naming scheme based on the server identifier. For the example SAP BusinessObjects BI server, you will typically see tools like: sapbusinessobjectsbi_get_tables to list tables, sapbusinessobjectsbi_get_columns to list columns for a table, and sapbusinessobjectsbi_run_query to execute a SQL SELECT against the data source. The outputs are returned in CSV for tabular data (columns first) and are suitable for consumption by downstream AI reasoning steps. You can also construct your own JSON-RPC requests following the examples in the README to script or test behavior.

Prerequisites:

• Java Development Kit (JDK 8+)
• Maven
• Access to download and license the CData JDBC Driver for SAP BusinessObjects BI and place the resulting JAR in your local environment

Installation steps:

1. Clone the repository and build the MCP server:

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

   This will produce the JAR file: CDataMCP-jar-with-dependencies.jar

2. Download and license the CData JDBC Driver for SAP BusinessObjects BI:

   • Visit: https://www.cdata.com/drivers/sapbusinessobjectsbi/download/jdbc
   • Install the driver on your system
   • License the driver by running:

     java -jar cdata.jdbc.sapbusinessobjectsbi.jar --license
     

     and entering your information or license key as prompted

3. Configure a JDBC connection (example steps):

   • Run the Connection String utility to create a connection string, then save it to a .prp file (e.g., sap-businessobjects-bi.prp) with required properties such as Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl as described in the README

4. Run the MCP server:

   java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-businessobjects-bi.prp
   

   The server uses stdio for I/O, so it should run on the same machine as the client

5. Validate with a client: use Claude Desktop or any MCP client configured to connect to the running server using the provided mcpServers configuration path

Notes and tips:

• This MCP server is read-only by design for local usage; write/update/delete operations are not exposed through the provided tools.
• Ensure the CData JDBC Driver is properly licensed before starting the MCP server; without a valid license the driver may fail to initialize.
• The server process reads a .prp configuration file that contains connection details to your SAP BusinessObjects BI data source; ensure the JdbcUrl is correctly configured (including OAuth if your data source requires it).
• Since the server uses stdio, you must run a compatible MCP client on the same machine or configure a tool wrapper that can communicate with STDIO-based servers.
• When updating the prp or driver, you may need to restart the MCP server to pick up changes.