Does Azure Data Factory support Many to Many table copy to Dataverse?

Question

Hi Team,

Does Azure Data Factory support Many to Many Table data copy to Dataverse?

I have followed the below steps:

1. Using ADF, imported Table1 - Employee
2. Using ADF, imported Table 2 - Training
3. Using ADF, when I try to import the Intermediate table (Employee_Training), I am getting the below error:

ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147219456, error message: The 'Create' method does not support entities of type 'pp_training_employee'. MessageProcessorCache returned MessageProcessor.Empty. .,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'

Any suggestion?

Answer 1

you can follow the links below :

You need some external tools to help you manage NN relationship. I recommend you to use XrmToolBox plugin for Importing N:N relationships.

XrmToolBox : https://www.xrmtoolbox.com/

Manage NN relationships: https://github.com/MscrmTools/XrmToolBox/wiki/Manage-NN-relationships

Answer 2

I know this is from a while back, but we faced a similar challenge recenltly, and we used ADF but instead of a Copy Task we had it use an HTTP activity and had it call the Dataverse Web API with the right arguments to associate records - took a bit of fiddling to get the connection right, but works great

Answer 3

Hi @Sandeep009 . I have been in a similar scenario where in many to many relationships the data will be sitting in a intermediate table, and when you try to populate with the ADF it wont support, and my suggestions is to use XRM tool box where you can populate the table that has many to many relationship.