Hi all
We're currently using Dynamics CRM and need to keep data synced between it and a SQL database used by our other internal apps
Our current ETL product seems like overkill and expensive
We are synchronizing 1 to 100 records every two minutes and 10k to 100k nightly
There are no complex transformations involved, just inserts and updates
The CRM is hosted in Azure
The Sql Server is hosted on prem
Our staff is knowledgeable in SSIS so SSIS connectors are fine
Our main concerns are that it run in a timely fashion and be kept updated with any changes Microsoft makes to CRM
There seems to be a good number of options detailed in this Technet article below:
but I'm looking for pointers and wondering what your experiences have been
Thanks
Manny B
