Dataverse Tables Data Migration using Azure Data Factory (Many-to-Many)

Sandeep009 1 Reputation point
2022-04-25T22:49:26.393+00:00

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:

  1. Using ADF, imported Table1 - Employee
  2. Using ADF, imported Table 2 - Training
  3. 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.

196333-image.png

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!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,343 questions
{count} votes