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?