Dynamic 365 Data connect via Azure Synapse

Question

How to connect Dynamic365 Database via Synapse workspace?

Answer 1

Hi @MG

Welcome to Microsoft Q&A platform and thanks for posting your question here.

To connect a Dynamics 365 database via Synapse workspace, you need to follow a few steps.

Firstly, create a linked service to connect to your Dynamics 365 database. You can do this by going to the Manage hub in your Synapse workspace, selecting Linked services, and then selecting New. From there, you can choose the appropriate connector for your Dynamics 365 database and enter the necessary connection details.

Next, create a dataset that references your Dynamics 365 database. To do this, select New in the Datasets tab of the Data hub. Then, choose the connector for your Dynamics 365 database and select the linked service that you created in the previous step.

After creating the dataset, you can create a data flow that uses your Dynamics 365 dataset as a source. To do this, go to the Data hub and select the Data flows tab. Then, click on the New button and select Data flow. Finally, choose your Dynamics 365 dataset as the source for your data flow.

Once you have created your data flow, you can add any necessary transformations to it. This will allow you to manipulate the data in your Dynamics 365 database before transferring it to your destination.

Next, create a sink dataset that references the destination where you want to store the data from your Dynamics 365 database. You can do this by selecting New in the Datasets tab of the Data hub, selecting the appropriate connector for your destination, and then selecting the appropriate destination details.

Finally, configure your data flow to use your sink dataset as the destination for your data. You can do this by selecting the appropriate sink transformation in your data flow and then selecting your sink dataset as the destination. Once you have completed these steps, you can run your data flow to transfer data from your Dynamics 365 database to your destination.

 

It's important to note that the specific steps may vary depending on the type of Dynamics 365 database you are using and the destination where you want to store the data. For more information on how to create linked services, datasets, and data flows in Synapse workspace, you can refer to the official Azure documentation:

https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory
https://learn.microsoft.com/en-us/dynamics365/customer-insights/data/connect-synapse
https://www.youtube.com/watch?v=YUKmiVPa2GY
Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.