Frequently Asked Questions about CData MCP Server for Dynamics 365 Business Central

Q: What is the CData MCP Server for Dynamics 365 Business Central? A: It’s a server that allows Large Language Models (LLMs) like Claude Desktop to access and query data from Dynamics 365 Business Central using natural language. It acts as a bridge between the LLM and your data source.

Q: What is MCP? A: MCP stands for Model Context Protocol. It’s an open protocol that standardizes how applications provide context to LLMs, enabling them to interact with external data sources and tools.

Q: What are the benefits of using this MCP Server? A: You can query your Dynamics 365 Business Central data using natural language instead of SQL, get real-time data access, simplify reporting, and enable AI-powered decision-making.

Q: Is this a read-only server? A: Yes, this particular build is read-only. However, CData offers a free (beta) read/write version with full capabilities.

Q: Where can I find the read/write beta version? A: It’s available at https://www.cdata.com/solutions/mcp.

Q: What is the CData JDBC Driver? A: The CData JDBC Driver for Dynamics 365 Business Central enables connectivity by exposing your Dynamics 365 Business Central data as relational SQL models.

Q: Where can I download the CData JDBC Driver? A: You can download it from https://www.cdata.com/drivers/d365businesscentral/download/jdbc.

Q: How do I set up the server? A: The setup involves cloning the repository, building the server, downloading and licensing the JDBC driver, configuring your connection, creating a .prp file, and configuring your client (e.g., Claude Desktop).

Q: What is a .prp file? A: It’s a properties file that contains connection details like the JDBC URL, driver path, server name and database tables for your Dynamics 365 Business Central data source.

Q: Can I use this server with other AI clients besides Claude Desktop? A: While the setup guide focuses on Claude Desktop, the server can be used with any client that supports the Model Context Protocol and can communicate via stdio.

Q: What are some example use cases for this server? A: AI-powered reporting, intelligent customer service, data-driven decision-making, and automated data analysis are some potential use cases.

Q: What kind of queries can I run? A: You can ask questions like “What is the correlation between my closed won opportunities and the account industry?”, “How many open tickets do I have in the SUPPORT project?”, or “Can you tell me what calendar events I have today?”

Q: What if I’m having trouble connecting to my data source? A: Contact the CData Support Team for assistance.

Q: What if I have feedback or issues with the MCP server? A: Join the CData Community to share your feedback or ask questions.

Q: What is UBOS and how does it relate to this MCP Server? A: UBOS is a full-stack AI Agent Development Platform that can be used to orchestrate AI Agents, connect them with enterprise data (like Dynamics 365 using this MCP Server), and build custom AI Agents.

Q: Where can I find more information about UBOS? A: Visit https://ubos.tech to learn more about the UBOS Platform.