Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Need to migrate N:N relationship entity from SQL DB to Dynamic D365 Using Azure Data Factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 53%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
ADF Developer
1
Reputation point
I am working in a assignment where we are migrating entity from CRM 2011 (SQL DB) to Dynamic 365 which is Target.
Problem Statement:
Azure Data Factory does not support N:N relationship migration using Dynamic D365 connector.
Tried to load data from SQL DB (CRM 2011 system) to online D365 CE instance, used "Copy Activity" and connected Dynamic 365 (Sink) using "Dynamic 365" connector.
ADF pipeline is not able to handle N:N relationship, throwing error.
Can anyone please suggest what could be the workaround if this thing need to be achieved using ADF.
Azure Data Factory
{count} votes
-
ADF Developer 1 Reputation point
2021-08-20T13:38:16.813+00:00 HI @Corey Huffman Amoruso,
I think you have worked on this. Could you please help me here?
-
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator2021-08-23T15:53:41.027+00:00 Hi @ADF Developer ,
Thank you for posting query in Microsoft Q&A Platform.
Could you please share your error message details and pipeline configuration details to understand better and help on this.
-
ADF Developer 1 Reputation point
2021-08-24T08:20:24.64+00:00 Thanks Maheer...I will share the details soon.
-
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator
2021-08-27T06:42:22.947+00:00 Hi @ADF Developer ,
Thank you. We will wait for update.
-
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator
2021-09-01T11:45:23.927+00:00 Hi @ADF Developer ,
Did you get chance to share requested details in above comment.
Sign in to comment
Sign in to answer