Solved

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

Posted on 2013-05-23
4
734 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

729 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