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.