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) / synchronize the CRM da...
Microsoft Dynamics CRM (Archived)

synchronize the CRM database with cloud database

(0) ShareShare
ReportReport
Posted on by RohithSankar 27

how to synchronize the CRM database with cloud database

(AWS RDS-SQL server in this case).

 

Scenario is that lets say we have billing calculation done for 10,000 customer on AWS-SQL server. Now this needs to be updated in CRM. Currently we use some sort of synchronization which refreshes each 10 mins and syncs the data from SQL server to CRM. Needless to say we often encounter into error while this sync is being done.

 

It would be nice if someone could suggest a better way to synchronize/transfer this data

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    I usually use KingswaySoft adapters for this goal.

    Additionally I can recommend to take a look on architecture of your solution and update not all the customers but those for which data was changed since last sync.

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

    Adding my two cents:

    If you want to replicate whole database you

    1. can use SCRIBE replicating services also for such scenarios. It will allow your SQL server to sync with Dynamics 365 CE database.

    2. Another options would be to use DataExportServices however it will work only with SQL hosted on Azure I guess.

    If you want to have limited sync (specific entity(s) etc) then

    1. SSIS+KingswaySoft is good option.

    2. LogicApps can also be considered, it offers connectors and can be configured easily, however it can be quite expensive.

    Regards,

    Pranav

    If found useful, please mark the answer as verified

  • Vanda Profile Picture
    Vanda 5 on at

    You can use Skyvia to import data from Amawon RDS to Dynamics 365: skyvia.com/.../integrate-dynamics-crm-amazon-rds. You need only configure your import/export in convenient GUI wizards and use flexible scheduling settings to automate data operations. You can set the frequency of data updates — for example, once a minute.

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