How to Connect Microsoft Dynamics 365 to MCP

Connect Dynamics 365 to AI Agents

Microsoft Dynamics 365 is a leading ERP and CRM platform. By connecting D365 to MCP with AnythingMCP, AI agents can access accounts, opportunities, cases, and financial data through natural language.

Ready-made connectors: AnythingMCP has connectors for Dynamics 365 Business Central and Dynamics 365 Sales, which also covers other Dataverse apps. You sign in with your Microsoft account and need none of the steps below. The steps below are for building your own connector to other Dynamics 365 APIs.

Step-by-Step Guide

Step 1: Deploy AnythingMCP

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 2: Create a REST Connector

Open the AnythingMCP dashboard at http://localhost:3000 and create a new REST connector. Set the base URL to your Dynamics 365 Web API endpoint (e.g., https://yourorg.crm.dynamics.com/api/data/v9.2).

Step 3: Configure Authentication

In the connector settings, configure OAuth 2.0 with your Azure AD App Registration credentials. Use Client Credentials flow with appropriate Dynamics 365 API permissions.

Step 4: Import and Customize Tools

Configure endpoints for accounts, opportunities, leads, invoices, and cases in the dashboard. Customize tool names and descriptions for AI agent clarity.

Step 5: Test and Connect

Test each tool in the dashboard, then configure your MCP client:

{
  "mcpServers": {
    "dynamics365": {
      "url": "http://localhost:4000/mcp"
    }
  }
}

AI Agent Use Cases

• "Show me all opportunities closing this quarter over $100k"
• "Create a lead for Sarah at GlobalTech, industry: Technology"
• "What are the top 10 accounts by revenue?"
• "Open a high-priority service case for Contoso Ltd"
• "Show unpaid invoices older than 30 days"

Best Practices

1. Register an Azure AD app with Dynamics 365 API permissions
2. Use $select to limit returned fields for efficiency
3. OData filters — Leverage $filter, $top, $orderby for efficient queries
4. Security roles — Application user must have appropriate D365 security roles
5. Test in sandbox — Use a Dynamics 365 sandbox environment first

Next Steps

• Salesforce to MCP Guide — Alternative CRM
• SAP HANA to MCP Guide — ERP integration
• Dynamics 365 Business Central connector
• Dynamics 365 Sales connector