We have a large number of customer records that needs to be kept in sync with a CRM 2011 implementation.
On average we have 40,000 reasonably complex records (name, contact details, address, usage data etc) that change every 15 minutes with infrequent peaks of up to 750,000 changes. The information is external to the CRM application and needs to be kept synchronised with it.
Could you let me know the best approach to achieve this please?
Are you using OnLine or OnPrem?
For OnLine, the fastest way to sync I've seen is to use Simego - http://www.simego.com/Blog/2013/05/How-to-insert-a-large-amount-of-records-into-Dynamics-CRM-Online
They do some very clever optimisations to make the sync process as fast as possible.
- Proposed as answer by Scott Durow (MVP)MVP, Editor Monday, September 09, 2013 7:44 AM
Would you please confirm the system in which you storing customers and want to synchronize with CRM?
You can create console application and schedule it to run after every 2-3 hours or every night. This will run and will read the customer from the System and will synch CRM Customers.
Hope this helps!