Clone Online Microsoft Dynamics CRM Database and keep up to date with changes

  • 89Views
  • Last Post 02 January 2018
  • Topic Is Solved
0
votes
Bipin Butala posted this 29 December 2017

Hello,

My organization has a Office 365 hosted Microsoft Dynamics CRM database.  I would like to clone this to a local db and keep the local db up to date with any changes made to the online CRM database.

The reason I want to do this is so we can connect our internally developed web apps to the online MS dynamics CRM date with greater ease.  currently we are making OData calls via REST like requests.  

Can Skyvia provide this functionality and what would the approx cost per year be?

Thanks so much for you help!

 

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 02 January 2018

You can take a look at the Replication package for this scenario. Skyvia replication operation is used to create a copy of cloud application data in a relational database and keep it up-to-date.

Useful information regarding replication packages:

https://skyvia.com/resources/docs/index.html?replication_overview.htm

https://skyvia.com/resources/docs/index.html?replication_package.htm

https://skyvia.com/resources/docs/index.html?setting_up_replication.htm

 

Please note, when working with the relational databases, the main requirement is that your database must be available through the Internet. If connecting to database on the local computer, it is required to allow such connections in your firewall. If connecting to a computer in the local network, it is necessary to use port forwarding.

Also, if you want to execute Replication packages via Amazon Redshift connection, you need to click the Advanced button and set parameters for connecting to Amazon S3 storage service. This is necessary, because for replication Skyvia uses Redshift data import from Amazon S3. It loads data as CSV files to Amazon S3, tells Redshift to import data from it, and deletes the CSV file after the import. 

Please refer to: 

https://skyvia.com/resources/docs/index.html?relational_databases.htm

https://skyvia.com/resources/docs/index.html?dynamics_connections.htm

  • Supported by
  • Bipin Butala
1
votes
Mariia Zaharova posted this 02 January 2018

The price and limits are specified for one Skyvia account per month: https://skyvia.com/pricing
For import and replication, the number records, successfully added/modified/deleted in the target objects or tables, is counted. 
For export we count the number of records added to CSV file. 
For synchronization, the total number of records, successfully added, modified, or deleted in both sources, is counted. 
For each package run, you can find the number of records used in the package Run History.

  • Supported by
  • Bipin Butala
Close