Question 1

What is an MCP Server?

Accepted Answer

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.

Question 2

What is the purpose of the CData MCP Server for Dynamics 365?

Accepted Answer

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.

Question 3

Is this MCP Server read-only?

Accepted Answer

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.

Question 4

What is the CData JDBC Driver for Dynamics 365?

Accepted Answer

The CData JDBC Driver connects to Dynamics 365 by exposing it as a relational SQL model, enabling data access through standard SQL queries.

Question 5

How do I set up the MCP Server with Claude Desktop?

Accepted Answer

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.

Question 6

What is a `.prp` file and what properties should it contain?

Accepted Answer

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`.

Question 7

How do I configure the JDBC connection string for Dynamics 365?

Accepted Answer

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.

Question 8

What should I do if I cannot see the CData MCP Server in Claude Desktop?

Accepted Answer

Ensure that you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Question 9

What should I do if Claude Desktop is unable to retrieve data?

Accepted Answer

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.

Question 10

Where can I get support for the CData JDBC Driver or the MCP server?

Accepted Answer

For trouble connecting to your data source, contact the [CData Support Team](https://www.cdata.com/support/submit.aspx). For issues with the MCP server or general feedback, join the [CData Community](https://community.cdata.com).

Question 11

What license is the MCP server released under?

Accepted Answer

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.

Question 12

What is UBOS?

Accepted Answer

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.

Dynamics 365 MCP Server by CData

Resources

Project Details

Recomended MCP Servers

Featured Templates

Customer Relationship Management (CRM)

Unified Authorization Template

AI Voice Assistant (Voice-Text-Voice)

Speech to Text

Talk with Claude 3

Calculate Time Complexity with ChatGPT API

Start your free trial