Azure Data Factory pipeline - copy data from on-prem SQL Server and Dynamics CRM

%3CLINGO-SUB%20id%3D%22lingo-sub-1836783%22%20slang%3D%22en-US%22%3EAzure%20Data%20Factory%20pipeline%20-%20copy%20data%20from%20on-prem%20SQL%20Server%20and%20Dynamics%20CRM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1836783%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20need%20to%20transfer%20data%20from%20an%20on-premises%20SQL%20Server%20into%20CDS%20(Dynamics%20365).%3CBR%20%2F%3EThis%20can%20be%20achieved%20by%20using%20a%20CopyData%20activity%2C%20if%20all%20data%20to%20be%20transferred%20is%20already%20stored%20in%20SQL%20Server%26nbsp%3B%3CBR%20%2F%3EUnfortunately%2C%20this%20is%20not%20my%20case.%3CBR%20%2F%3ESteps%20for%20my%20requirement%20are%3A%3CBR%20%2F%3E-%20create%20a%20CRM%20record%20(parent%20record)%3B%3CBR%20%2F%3E-%20the%20GUID%20of%20this%20record%20must%20be%20then%20included%20into%20the%20source%20data%20for%20CopyData%20activity.%3CBR%20%2F%3EIn%20fact%2C%20all%20the%20data%20transferred%20into%20CRM%20(by%20CopyData%20activity)%20need%20to%20be%20child%20records%20of%20the%20previous%20parent%20record.%3C%2FP%3E%3CP%3EHow%20can%20I%20accomplish%20this%20data%20flow%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3CBR%20%2F%3ERadu%20Antonache%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1836783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql%20server%20on%20premise%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello,


I need to transfer data from an on-premises SQL Server into CDS (Dynamics 365).
This can be achieved by using a CopyData activity, if all data to be transferred is already stored in SQL Server 
Unfortunately, this is not my case.
Steps for my requirement are:
- create a CRM record (parent record);
- the GUID of this record must be then included into the source data for CopyData activity.
In fact, all the data transferred into CRM (by CopyData activity) need to be child records of the previous parent record.

How can I accomplish this data flow, please?

 

Best regards,
Radu Antonache

0 Replies