CRM Crate

Access the Dynamics 365 data in SQL Database

We will learn to access the Dynamics 365 data in SQL Database. Before we start, make sure to subscribe to CRM Crate so that you stay up-to-date in the field of Dynamics 365.

Access the Dynamics 365 data in SQL Server Database

Prerequisites for accessing Dynamics 365 data from SQL Server Database

Below are the key prerequisites for accessing D365 data in SQL Server Database.

Validate the version & TDS settings

Let us now validate the environment version and TDS settings.

  • Open the Dynamics 365 CE and click on Settings >> About as shown below.
  • Verify if your environment version is above 9.1 as shown below.

Connect the Dynamics 365 in SQL Management Studio

FieldValue
Server TypeDatabase Engine
Server Name<Dynamics 365 URL>,5558

For example: – crmcrateindia.crm8.dynamics.com, 5558
AuthenticationAzure Active Directory – Password
User NameYour administrator user name
Password Your administrator password
  • Once connected, you can access the database in read-only mode.
  • Due to limited access, you can only perform the below given operations.

List of operations –

SELECT
UNION
JOIN
FILTER
Batch operations 
Aggregate operations like COUNT() and MIN() or MAX()
  • Below are the Dynamics 365 & SQL Server snapshot of data present in the “Sample Entity”
Dynamics 365 Advance Find Data
SQL Server Data

Thus we learned to access the Dynamics 365 data in SQL Server Database.

5 1 vote
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
error: CRM Crate Security Engine - Disabled Right Click & Selection!

Congratulations!

Well Done,
Welcome to CRM Crate

Stay tuned with us and get all latest updates and learning in Microsoft CRM and related techonologes.