SAP BusinessObjects BI

You can query live SAP BusinessObjects BI data through a lightweight MCP server that wraps the CData JDBC Driver. This read-only MCP interface lets you ask natural-language questions and receive up-to-date results without writing SQL, making it ideal for AI-assisted data exploration.

How to use

Start the MCP server you configured and connect your AI client to it. Use the built-in tools to read data from SAP BusinessObjects BI. You can ask questions like which accounts have the highest revenue, how many opportunities are open, or what the current status of a given KPI is. The server exposes a small set of tools that let you discover which tables and columns exist and to run read-only queries against the data.

How to install

Prerequisites you need on your machine before you start:

• Java Runtime Environment (JRE) or JDK installed and available in your system PATH
• A working Java command to run Java applications
• A suitable directory with write access for configuration files and the MCP JAR

Step-by-step commands to get the MCP server up and running:

# 1. Prepare a working directory and clone the project (only if you are starting from source)
# git clone https://github.com/cdatasoftware/sap-businessobjects-bi-mcp-server-by-cdata.git
# cd sap-businessobjects-bi-mcp-server-by-cdata

# 2. Build the MCP server package (if you are starting from source)
# mvn clean install

# 3. Ensure the CData JDBC Driver for SAP BusinessObjects BI is installed and licensed following the driver instructions

# 4. Create the MCP connection properties file (sap-businessobjects-bi.prp) with your JDBC connection details
# Prefix=sapbusinessobjectsbi
# ServerName=CDataSAPBusinessObjectsBI
# ServerVersion=1.0
# DriverPath=PATH\\TO\\cdata.jdbc.sapbusinessobjectsbi.jar
# DriverClass=cdata.jdbc.sapbusinessobjectsbi.SAPBusinessObjectsBIDriver
# JdbcUrl=jdbc:sapbusinessobjectsbi:InitiateOAuth=GETANDREFRESH;
# Tables=

# 5. Run the MCP server using the standard Java command
# java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-businessobjects-bi.prp

Additional sections

Configuration notes: You will provide a .prp file that defines the JDBC connection, including the driver path, class, and the JDBC URL. The server reads this file to expose the SAP BusinessObjects BI data as MCP tools. If your data source uses OAuth, you will complete authentication in the browser when you test the connection string.

Troubleshooting

If the MCP server does not appear in your client, ensure you have fully quit and restarted the client so it re-scans for MCP servers. Verify your sap-businessobjects-bi.prp file contains the correct JdbcUrl, DriverPath, and DriverClass. If the client cannot read data, re-check the connection string by regenerating it with the JDBC driver’s Connection String utility and updating the .prp file accordingly.

License

This MCP server composition is provided under the MIT License. You are free to use, modify, and distribute it in accordance with the terms of the MIT license.

Notes

This server is designed for read-only access to SAP BusinessObjects BI data. If you need read-write capabilities, consider other CData MCP Server offerings that support full CRUD operations.

Available tools

sapbo_bi_get_tables

Retrieves a list of tables available in the SAP BusinessObjects BI data source. Output is in CSV format with the first line as column headers.

sapbo_bi_get_columns

Retrieves a list of columns for a specific table. Output is in CSV format with column headers.

sapbo_bi_run_query

Executes a SQL SELECT query against the exposed SAP BusinessObjects BI data and returns the results.