Dataverse Tables Data Migration using Azure Data Factory (Many-to-Many)
Hi Team,
I am trying to migrate data from SQL server to Dataverse. Currently, I am migrating data for a many-to-many relationship using Azure Data Factory. I have followed the below steps:
- Using ADF, imported Table1 - Employee
- Using ADF, imported Table 2 - Training
- Using ADF, imported Intermediate table (Employee_Training)
Note: I have created the required intermediate table data (GUIDs) in Azure SQL - EmployeeID, TrainingID
In step 3, my ADF has failed because I am not able to provide the Alternative Key in the Sink configuration. Please note Employee & Training tables relationship is System many-to-many relationship and not the manual many-to-many relationship, so I don't have access to the table to create an Alternative Key.
ErrorCode=DynamicsMissingKeyColumns,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=,Source=,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Input DataSet must contain keycolumn(s) in Upsert/Update scenario. Missing key column(s): pp_training_employeeid
Any workaround? Please advise.
Thank you!