60
I'd like to copy from one online crm(Contoso1) to another online(Contoso2) the account entity. I set from origin to sink the a few columns name,accountid,ownerId, and the rows are created but, ownerId it's the user configured in ADF's connection, but should be the owner from the first CRM(Contoso1).
thanks, does someone known how to solved Ownership migration?
Did you ever get this figured out? If not, I think I can help. A few questions for you:
1. Are the two instances of Dynamics 365 on the same tenant?
2. If not, are all of the users (potential owners) from the first instance also in the second?
ownerid is a lookup field to the systemuser entity, and that data will only populate during a migration if the data provided in the ownerid field matches with a user record that already exists in the destination instance. If the users don't already exist, you'll need to import stub users to the second system. Let me know if you need help with that.
Also, you should make sure the login you're using to connect to the destination instance has permission to assign records to users
Have you seen this reference to mapping the GUID? https://docs.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365#writing-data-to-a-lookup-field
Haven't tried it but have done it with Kingswaysoft and Scribe.
#1
André Arnaud de Cal...
291,602
Super User 2024 Season 2
#2
Martin Dráb
230,340
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
