Frequently Asked Questions (FAQ) - CData MCP Server for Dynamics 365

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, allowing AI models to access and interact with external data sources and tools.

Q: What is the purpose of the CData MCP Server for Dynamics 365? A: This MCP Server allows LLMs (like Claude Desktop) to query live Dynamics 365 data supported by the CData JDBC Driver for Dynamics 365, enabling natural language queries and AI-powered insights.

Q: Is this MCP Server read-only? A: Yes, this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, check out the free CData MCP Server for Dynamics 365 (beta) available on the CData website.

Q: What is the CData JDBC Driver for Dynamics 365? A: The CData JDBC Driver connects to Dynamics 365 by exposing it as a relational SQL model, enabling data access through standard SQL queries.

Q: How do I set up the MCP Server with Claude Desktop? A: You need to create a config file for Claude Desktop (claude_desktop_config.json) to add the new MCP server, specifying the path to the Java executable, the MCP server JAR file, and the .prp configuration file.

Q: What is a .prp file and what properties should it contain? A: A .prp file contains the connection details for the JDBC connection. It should include properties like Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and optionally Tables.

Q: How do I configure the JDBC connection string for Dynamics 365? A: Use the CData JDBC Driver’s Connection String utility to configure the connection string. You can open it by running the command java -jar cdata.jdbc.dyanmics365.jar in the driver’s installation directory.

Q: What should I do if I cannot see the CData MCP Server in Claude Desktop? A: Ensure that you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Q: What should I do if Claude Desktop is unable to retrieve data? A: Verify that you have configured your connection properly. Use the Connection String builder to create the connection string and copy it into the property (.prp) file.

Q: Where can I get support for the CData JDBC Driver or the MCP server? A: For trouble connecting to your data source, contact the CData Support Team. For issues with the MCP server or general feedback, join the CData Community.

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

Q: What is UBOS? A: UBOS is a Full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. Our platform help you orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems.