Wednesday, June 3, 2020

How to Connect to Dynamics 365 or CDS Database from SQL Management Studio

Hello Friends!

It's been a while (close to 2 years) since I was last here. Had been super busy with my team doing and managing multiple implementations full-on with Dynamics 365 suite of Products.


  • Dynamics 365 Finance
  • Dynamics 365 Supply Chain Management
  • Dynamics 365 Business Central Online
  • Dynamics 365 Customer Engagement
  • Dynamics 365 Customer Service


And, I'm super excited with the platform and what it has to offer in the upcoming releases.

Recently, for a client of mine, we were helping with implementation of Customer Service and as part of the implementation, they wanted to do quick reconciliation of customers and accounts between their current ERP system - Pronto and Dynamics 365 Customer Service.

As some of you might be already aware, Microsoft quite recently have announced a preview version of CDS SQL Connector wherein you can use the famous SQL Management Studio to connect to Dynamics 365 Customer Service or any CDS database. This applies to Dynamics 365 Sales or Dynamics 365 Customer Engagement as well.

So, to get started you need to do the following:



SQL Management Studio in Action:

Points to be noted:


  • This is still in preview mode
  • Microsoft's recommendation is not to run in PROD, however I have tried it and it works but i will stick with Microsoft's advise
  • Database is read-only mode
  • No IUDs can be done

No comments:

Post a Comment