web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to copy data Using...
Customer experience | Sales, Customer Insights,...
Unanswered

How to copy data Using Azure data factory?

(0) ShareShare
ReportReport
Posted on by TerryShowman 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?

  • BB-07082110-0 Profile Picture
    BB-07082110-0 Microsoft Employee on at

    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.  

  • hortond00 Profile Picture
    hortond00 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 87 Most Valuable Professional

#2
11manish Profile Picture

11manish 67 Super User 2026 Season 2

#3
Travis South Profile Picture

Travis South 35

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans