Frequently Asked Questions about CData MCP Server for SAP ERP

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. An MCP Server acts as a bridge, enabling AI models to access and interact with external data sources and tools, such as SAP ERP systems.

Q: What is the CData MCP Server for SAP ERP? A: It’s a server that allows LLMs like Claude Desktop to query live SAP ERP data via the CData JDBC Driver for SAP ERP, using natural language questions. This eliminates the need for complex SQL queries.

Q: Is this a read-only server? A: Yes, this particular server is read-only. For full read, write, update, delete, and action capabilities, CData offers a free (beta) read/write server.

Q: Where can I find the read/write version of the MCP Server? A: You can download the free (beta) read/write version at https://www.cdata.com/download/download.aspx?sku=RYZK-V&type=beta.

Q: What is the CData JDBC Driver for SAP ERP? A: This driver connects to SAP ERP systems and exposes their data as relational SQL models. It acts as a translator, converting SAP ERP’s data format into a format understandable by SQL-based tools and LLMs.

Q: How do I install the CData JDBC Driver for SAP ERP? A: You can download the driver from https://www.cdata.com/drivers/sap/download/jdbc and follow the installation instructions provided by CData.

Q: Do I need a license for the CData JDBC Driver? A: Yes, you need to license the CData JDBC Driver. You can use a trial license or a paid license. Instructions for licensing are provided in the setup guide.

Q: How do I configure the connection to my SAP ERP system? A: You use the Connection String utility provided with the CData JDBC Driver to configure the connection. This utility helps you create the connection string needed to connect to your SAP ERP system.

Q: What is a .prp file and why do I need it? A: A .prp file is a properties file that contains the connection details for your SAP ERP system. It includes information such as the driver path, driver class, JDBC URL, and other connection parameters. This file is used by the MCP Server to connect to your SAP ERP system.

Q: How do I configure Claude Desktop to use the MCP Server? A: You need to modify the claude_desktop_config.json file to add the new MCP server. This involves specifying the path to the Java executable, the path to the CDataMCP-jar-with-dependencies.jar file, and the path to the .prp file.

Q: I can’t see my CData MCP Server in Claude Desktop. What should I do? A: Ensure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and then reopen it. This forces Claude Desktop to refresh its MCP server list.

Q: Claude Desktop is unable to retrieve data. What could be the issue? A: Double-check that you have configured your connection properly. Use the Connection String builder to create the connection string and ensure it’s correctly copied into the .prp file.

Q: What are the tools available in the MCP Server? A: The MCP Server provides the following tools: * {servername}_get_tables: Retrieves a list of tables available in the data source. * {servername}_get_columns: Retrieves a list of columns for a table. * {servername}_run_query: Executes a SQL SELECT query.

Q: Do I need to call the tools explicitly? A: Generally, no. The AI client will use the built-in tools as needed to answer your natural language questions. You usually don’t need to call them directly.

Q: Where can I get help if I’m having trouble connecting to my data source? A: Contact the CData Support Team.

Q: Where can I get help with the MCP server or provide feedback? A: Join the CData Community.

Q: What license is the MCP server under? A: The MCP server is licensed under the MIT License. You are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License.