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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Data Export Service
Microsoft Dynamics CRM (Archived)

Data Export Service

(0) ShareShare
ReportReport
Posted on by CRM Beginner 795

Hi,

I have exported Dynamics 365 CRM Data to an Azure Database using Data Export Service solution by generating an Azure KeyVault URL.But, what i found resulting data a little complex to understand. 

My requirement was still fulfilled but i want to know is there any other way that can export Online 365 CRM Data to external Azure DB in easily understandable format?

Thanks,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi,

    That's the only supported way to replicate data from CRM to Azure DB. When you export, it creates the table for each entity with the configured field. You should be able to query the table pretty easily. whats not working or complex?

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi,

    That's the only supported way to replicate data from CRM to Azure DB. When you export, it creates the table for each entity with the configured field. You should be able to query the table pretty easily. what's not working or complex?

  • CRM Beginner Profile Picture
    CRM Beginner 795 on at

    I mean will it be necessary that the data export service do export the metadata along with it to Azure db ?

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Yes, data export services do export metadata changes to the azure db. Read more about it here:

    blogs.msdn.microsoft.com/.../introduction-to-dynamics-365-data-export-service

    docs.microsoft.com/.../mt744592(v=crm.8)

    Hope this helps.

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    Hi,

    SCRIBE also provides replication services, which does the similar thing. It  provides a robust and easy-to-use tool that makes a copy of data in your CRM Online organization and syncs that data to an on-premises database that you have full control over. I am not very sure whether it provides conditional entitywise sync or not.

    www.scribesoft.com/.../scribe-online-replication-services-rs

    If you just want to sync few entities then Microsoft Flow or Azure LogicApps could be a good solution. They provide connectors for Dynamics and Azure SQL server. I have implemented Azure LogicApps to sync my contact data. Although flow was one way. Contacts gets created in CRM, LogicApp workflow triggers and data flows to SQL server.

    Regards,

    Pranav

  • CRM Beginner Profile Picture
    CRM Beginner 795 on at

    Thanks for the reply guys.

    One more clarification that i need is when i exported Online 365 Data to Azure , it doesn't have any option to select specific fields to be exported..Only entities were required to be selected.. Can i export specific fields of my choice of specific entities using Data Export Service?

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Initially I thought we can select fields as well but looking into it now, we can't unfortunately.

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    I think any type of filtering be it vertical or horizontal, are not allowed in DataExport Services. So effectively selective rows and columns are out of question. It will sync data as a whole. And beware if you delete record from azure DB I think it will be deleted from CRM as well (you may want to double check that).

    Regards,

    Pranav

    If found useful, please mark the answer as verified

  • CRM Beginner Profile Picture
    CRM Beginner 795 on at

    And what if i really wish to export the data using filtering of some specific entities and that too specific fields in those entities, how may i do that ?

    Any idea?

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    That's what is suggested above that it is not possible with data export services.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans