How to import large volume of data into CRM 2011 Online entities?

Question

I need to import millions of records into a CRM 2011 Online entities. Is there any efficient way to do it?

Answer 1

We have a CRM migration tool that allows you to import data into CRM, both on-premise and online using the bulk import functionality which CRM provides.

Our product supports multiple table mappings per migration project, defining multiple data sources, and when you are done running your import in development, you can clone the connections into a new environment , for example SIT, UAT or PROD and re-run your import against there when ready. No coding required, so essentially anyone with BA / DB schema knowledge can use this tool to perform migration imports.

http://www.splsolutions.com.au

Any questions, please feel free to get in touch with us.

cheers, Paul

Answer 2

This tutorial might help. It shows how to send data stored in a SQL database to MSCRM 4.0 via CRM Web Services using SSIS.

The comments mention alternative options.

http://blogs.msdn.com/b/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx

Answer 3

With CRM 2011 Online you have different ways:

• Use the standard Import Data Wizard functionality
• Use CRM Web Services to get the additional capabilities for import data, more details here: Import Data in Microsoft Dynamics CRM
• Use CRM Web Services to build your own import tool using the new ExecuteMultipleRequest, more details here: Use ExecuteMultiple to Improve Performance for Bulk Data Load
• Use an integration software as Scribe

Which one is more efficient between these methods depends on your crm structure, the source of your data, the complexity of the transformation, etc.

Answer 4

There are a couple of other import tools for importing data SSIS integration toolkit is one and Import manager another