Any way to keep a copy of dynamics365 (online) data locally on my PC

(0) Share

Report

Posted on by Ahmad Saud

790

dear all

i want to keep a copy of the entire dynamics365 data (or certain entities) locally on my PC, and i need this to be updated frequently (for example on daily basis), i tried SSRS but could not use it, so many errors and problems, is there any good way for doing this?

thanks,

Categories:

Integration with Other Products

Customization / Solutions / SDK and API

All responses (2)

Answers (1)

Ahmad Saud 790 on at

Like (0)

Report

RE: Any way to keep a copy of dynamics365 (online) data locally on my PC

thanks Johnny for your help.

i did not try it in practice, but i read a little about SSIS and it seems it will satisfy my requirements.

regards.
Verified answer

Johnny Gong 6,482 on at

Like (0)

Report

RE: Any way to keep a copy of dynamics365 (online) data locally on my PC

Hello Ahmad,

I would suggest SSIS to export the D365 Online data for certain entities including audit logs as a copy. It could help you to export the entity data from online to your own DB destination. Then you could read the Online data with DB Table Mode.

SSIS Download Linkage: [View:http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/download:750:50" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" class="gallery_video_main" allowfullscreen>

Read from Dynamics CRM in SSIS - Import from CRM 365 Online:

Video of Getting Started with SSIS Integration Toolkit for Microsoft Dynamics 365/CRM:

For your reference.

Regards

Johnny