Service to import contacts

(0) Share

Report

Posted on by Mir Hassan Ali

1,720

I have to write a service that imports contacts from another system (not CRM). I have written this service in C# using the CRM SDK and it all works but the performance is a bit of an issue. I have to import about a million records and the speed with the CRM SDK is creating records, its going to take more than 48 hours. I have tried using the bulk creation using ExecuteMultipleRequest but that doesn't help much as it also uses the Execute method to create the record. Is there any supported way through which I can bypass the service (OrganizationService) and create the records directly into the CRM database or any other way of improving the performance.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

CRMInnovation.com on at

Like (0)

Report

RE: Service to import contacts

You cannot create records directly in CRM in a supported manner.

You should be getting more speed that you are experiencing. Although since you didn't indicate if this was for CRM online or on premise your performance can vary.

You should review this blog posting http://blogs.msdn.com/b/thecrmguys/archive/2013/01/09/hands-on-with-dynamics-crm-2011-s-new-executemultiple-request.aspx

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

RE: Service to import contacts

No Hasan,

Do not bypass the CRM API Service. It wil break your data security.

You might try the SSIS + Kingswaysoft and doing the multi threading load balance data ditribution

blog.sonomapartners.com/.../multi-threading-your-ssis-crm-integration-for-performance.html

Or if need the async service import using the ParseImport request

Example:

msdn.microsoft.com/.../gg328031.aspx

msdn.microsoft.com/.../hh547396.aspx

lakshmanindian.wordpress.com/.../import-data-programmatically-in-microsoft-dynamics-crm-2011

Jope this helps.

Thanks.

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report

RE: Service to import contacts

Hi,

There are multiple options

1.

If you are just importing contact records and there is not much child records, then you can use CRM data import also.. but CRM import has file size limitation of 8MB for csv, text or xml file.. you can load upto 32 MB of zip file..

This process is pretty faster and CRM loaded those records asynchronously.

Here are some details.

msdn.microsoft.com/.../gg328321.aspx

mahadeomatre.blogspot.com/.../resolve-circular-reference-in-crm-data.html

2.

Another option would be ExecuteMultipleRequest.. which you are already using..

3.

Create SSIS package

You can create SSIS package to import data.. and there are SSIS tools are also available

Here is some more details on SSIS

danielcai.blogspot.com/.../use-ssis-to-implement-data-quality.html

a33ik.blogspot.com/.../integrating-crm-2011-using-sql.html

www.concurrency.com/.../using-ssis-import-data-dynamics-crm

blogs.msdn.com/.../integrating-crm-using-sql-integration-services-ssis.aspx

www.cozyroc.com/products

4. you can use third party tools like Scribe,

social.technet.microsoft.com/.../3995.integrate-microsoft-dynamics-crm.aspx

Hope this will help..

Thanks,

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (0)

Report

RE: Service to import contacts

Hi

I can't use SSIS or a third party solution. The service that I am writing should read data directly from the source using their given web service and then create records in CRM using the CRM service. This service will also be used in a polling system to check if new records have been created in the source system and then bring them into the CRM.

Thanks for the suggestions.

Mir

Was this reply helpful? Yes No