Frequently Asked Questions (FAQ) about CData MCP Server for Intacct

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

Q: What is the CData MCP Server for Intacct? A: It’s a read-only MCP Server that allows you to connect to Intacct data from Claude Desktop (or other compatible LLMs) through CData JDBC Drivers, making it easy for AI to query your Intacct data using natural language.

Q: Is the CData MCP Server for Intacct free? A: The version described is a free, read-only beta. CData also offers free (beta) read/write servers with simplified setup.

Q: What is the purpose of this MCP Server? A: To allow LLMs (like Claude Desktop) to query live Intacct data supported by the CData JDBC Driver for Intacct, enabling natural language questions to retrieve information without needing SQL.

Q: What is the CData JDBC Driver for Intacct? A: It’s a driver that connects to Intacct by exposing its data as relational SQL models, making it accessible to applications like the MCP Server.

Q: How do I set up the CData MCP Server for Intacct? A: 1. Clone the repository. 2. Build the server using Maven. 3. Download and install the CData JDBC Driver for Intacct. 4. License the JDBC Driver. 5. Configure your connection to Intacct. 6. Create a .prp file for your JDBC connection. 7. Configure Claude Desktop with the new MCP server.

Q: What is a .prp file? A: It’s a configuration file that contains properties for your JDBC connection, such as the prefix, server name, driver path, driver class, JDBC URL, and tables to access.

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, specifying the command and arguments needed to launch the server.

Q: What tools are available in the MCP Server? A: The MCP Server provides tools like {servername}_get_tables (to retrieve a list of tables), {servername}_get_columns (to retrieve a list of columns for a table), and {servername}_run_query (to execute a SQL SELECT query).

Q: How do I run the MCP Server? A: Use the command java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp (adjust the paths accordingly).

Q: What if I can’t see my CData MCP Server in Claude Desktop? A: Ensure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Q: What if Claude Desktop is unable to retrieve data? A: Double-check your connection configuration. Use the Connection String builder to create the connection string and copy it into the .prp file.

Q: Where can I get support if I have trouble connecting to my data source? A: Contact the CData Support Team.

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

Q: Under what license is the MCP server released? A: The MIT License.

Q: Can I use this with other LLMs besides Claude Desktop? A: Yes, the MCP server can be used with any LLM that supports the Model Context Protocol.

Q: Where does UBOS fit into this? A: UBOS is a full-stack AI Agent development platform that can orchestrate AI Agents, connect them with enterprise data (like Intacct through this MCP server), build custom AI Agents, and create Multi-Agent Systems.