How to import a large amount of data in an online organization CRM 2011?

Question

I need to import millions of records into CRM 2011 objects online. Is there an effective way to do this?

Answer 1

With CRM 2011 Online you have different ways:

• Use standard Import Data Wizard functionality
• Use CRM web services for additional features for importing data, in more detail here: Import data in Microsoft Dynamics CRM
• Use CRM web services to create your own import tool using the new ExecuteMultipleRequest , in more detail here: Use ExecuteMultiple to improve performance for bulk data loading
• Use integration software like Scribe

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

Answer 2

There are several other import tools for importing data. The SSIS integration tool is one and the Import Manager is another.

Answer 3

We have a CRM migration tool that allows you to import data into CRM, both locally and online, using the bulk import features that CRM provides.

Our product supports several table mappings for one migration project, defines several data sources, and when you perform your import during the development process, you can clone the connections into a new environment, for example SIT, UAT or PROD, and restart your import there when it is ready . Coding is not required, so anyone who has knowledge of the BA / DB schema can use this tool to import migration.

http://www.splsolutions.com.au

Any questions, please contact us.

amuses Paul

Answer 4

This tutorial can help. It shows how to send data stored in an SQL database to MSCRM 4.0 through CRM web services using SSIS.

The comments mention alternatives.

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