web
You’re offline. This is a read only version of the page.
close
Skip to main content
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?

I have the same question (0)
  • hortond00 Profile Picture
    hortond00 on at
    RE: How to copy data Using Azure data factory?

    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

  • BB-07082110-0 Profile Picture
    BB-07082110-0 on at
    RE: How to copy data Using Azure data factory?

    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.  

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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 141

#2
DAnny3211 Profile Picture

DAnny3211 134

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 70 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans