question

RajuChoudharyADFDeveloper-6259 avatar image
0 Votes"
RajuChoudharyADFDeveloper-6259 asked ShaikMaheer-MSFT commented

Need to migrate N:N relationship entity from SQL DB to Dynamic D365 Using Azure Data Factory

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
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @Corey Amoruso,

I think you have worked on this. Could you please help me here?

0 Votes 0 ·

Hi @RajuChoudharyADFDeveloper-6259 ,

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.

0 Votes 0 ·

Thanks Maheer...I will share the details soon.

0 Votes 0 ·
ShaikMaheer-MSFT avatar image ShaikMaheer-MSFT RajuChoudharyADFDeveloper-6259 ·

Hi @RajuChoudharyADFDeveloper-6259 ,

Thank you. We will wait for update.

0 Votes 0 ·

Hi @RajuChoudharyADFDeveloper-6259 ,

Did you get chance to share requested details in above comment.

0 Votes 0 ·

0 Answers