Solved

CRM 2011 - Data Sync between external MS SQL database and CRM 2011

Posted on 2013-05-23
4
726 Views
Last Modified: 2014-01-29
I have over 10 millions records to update per year spreading over 20 entities.  What are all the different options available for data sync (unidirectional - from SQL database to CRM or bidirectional).

I am looking for a cost effective solution for a long term purpose.
0
Comment
Question by:tommym121
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 250 total points
ID: 39190743
Scribe - http://www.scribe.com/
Inaport - http://www.inaplex.com/Products/inaport.aspx

Not sure of the costs but you can check the websites.

Note that adding records to CRM must be done via the CRM SDK and not directly to the SQL database tables.
0
 

Author Comment

by:tommym121
ID: 39190790
Do you know if there is any free connector that will transfer data from an external SQL database (not the underlying SQL database of CRM 2011) to CRM 2011
0
 
LVL 27

Assisted Solution

by:Chinmay Patel
Chinmay Patel earned 250 total points
ID: 39190810
Hi tommy121,

There is no "free" lunch. :) If you are comfortable writing code you can write 1 for yourself though.

Regards,
Chinmay.
0
 

Author Comment

by:tommym121
ID: 39190833
Thanks.  In case I meet a free lunch.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now