Connect D365 CRM CDS Database From SQL Server

Connect D365 CRM CDS Database from SQL Server


Many times, we feel like why I can’t access D365 CRM Database directly from MS SQL Server, so here is my blog that will guide you on how you can connect D365 CRM CDS Database using MS SQL Server.

Steps to enable D365 CRM CDS Database to make it connect from MS SQL Server:

  1. Login to https://admin.powerplatform.microsoft.com/ using administrator credentials.
  2. In Environment section, click on your environment for which you want to enable D365 CRM CDS for MS SQL Server. (In my case I am clicking on DemoEnvironment as shown below.)
  3. When Environment opens click on settings in header.
  4. Settings page will open, Click on Product and then click on Features.
  5. When features Page opens enable TDS Endpoint (Preview) and click save.
  6. Now, we have successfully enabled D365 CRM CDS to connect it from MS SQL Server.

Steps to Connect CDS Database from MS SQL Server:

  1. Open MS SQL Server.
  2. In connect to SQL Server Window enter Server name (It will be your D365 CRM URL) followed by comma and Port Number (5558) e.g. of server name yourdomain.crm.dynamics.com,5558.
  3. Select Authentication as Azure Active Directory – Password.
  4. Enter Username: Your admin user id e.g. admin@xyz.com
  5. Enter Password: (Your Login password) ********
  6. Click Connect.
  7. Now, you have successfully connected to D365 CRM DB.
  8. Write a select query and test if it’s working.

Enjoy!!!

Comments

Post a Comment

Popular posts from this blog

Send note's PDF as email attachment using Power Automate

Image
Many times, we may get requirement to send PDF attached in notes as Email to a person. This blog will guide you on how you can do the same. In this blog, we will trigger a flow on notes Entity when a note is created Steps: 1. Add 1 st step as when a record is created in notes entity(annotation) with filter expression as subject eq "ABCDDDDDDDDDDDDd           Note: “ABCDDDDDDDDDDDDd” is used to trigger a flow when subject field of note’s record is equal to " ABCDDDDDDDDDDDDd’. 2.  Send an Email to user with required details. Here an Important thing is to convert the document (Base 64 file content) in binary string i.e. (“ base64ToBinary(triggerOutputs()?['body/documentbody']) ” ) without conversion, the PDF will not work in email attachment. 3.  Now you have successfully able to send PDF as E-mail attachment. Hope this helps!
Read more

Convert an Array to comma separated string in Power Automate

Image
Many times when we have an Array in Power Automate and we want to make it comma separated string in such cases we use loop to iterate each element in an array and append comma, we can avoid this loop and create desired string by using Join function available in Power Automate. My blog will guide you how you can achieve the same. Note : I am using hard code array in my blog, but you can use dynamic array as well Steps: Initialize a variable of type array with [ 'a', 'b', 'c', 'd', 'e' ] as its element. Add a new Compose step and use join function ( join (variables('Array 1'),',') ) to make array a comma separated string as shown below. Join function accepts 2 parameters, first parameter as Array in my case its Array 1 (variable) and second parameter as delimiter in my case I passed ‘,’ as we want to make comma separated string but you can use any delimiter and create your own string. Now, save and execute the flow and check if it
Read more

Make D365 CRM Entity as Read only

Image
Hi, this blog will guide you on how you can make an Entity as Read only in Dynamics 365 CRM. Steps : Ensure that the entity which you want to make read only is not already read only. In my case it is account entity and you can see it in not read only. Now, Open solution. Expand Entities node and click on Account. After clicking Accounts on right side you will see a general tab. In, General tab just scroll down and go to Outlook and Mobile section and ‘Tick’ Enable for Unified Client and then ‘Tick’ Read-only in Unified Client. Now save and Publish the solution. G o back to entity and check it is now read only. Hope this helps you out!
Read more