Sign in

Microsoft.com

Microsoft

Remove From My Forums

need expert help in CRM integration without using any tool to transfer data from staging sql server table data to MS dynamic crm 2013

Question
0

Sign in to vote
Hi All,

I need help in CRM 2013 integration, My requirement is transfer data from staging sql server table data to MS dynamic crm 2013. I think this can be done using plugin creation and by using methods like create/update/delete. I tried to find out but none of solutions are relevant to my requirement as I don't want any 3rd party tool to be used for this purpose. Iwant to generate my own custom solutions. I have seen some solutions with SSIS but not proper one to use.

Can any one please send/help me with this regard. Pls it's very urgent.

Thanks In Advance ...
- Edited by DH kumar Friday, June 27, 2014 1:36 PM
Friday, June 27, 2014 1:33 PM

All replies

0

Sign in to vote

http://a33ik.blogspot.co.uk/2012/11/integrating-crm-2011-using-sql.html

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

How ever I would recoomend using a 3rd party tool like http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm

because it will make your life quite easy
Regards Faisal

Friday, June 27, 2014 2:12 PM
0

Sign in to vote

Hi,

You could write a C# application that can fetch your data using normal SQL calls and connections. These data sets would need to be mapped into CRM Entity objects and then created using the standard CRM web services.

You can download the CRM2013 SDK for more detail on how to construct these objects.

Plugins are not really used for this kind of thing (although its entirely possible), the objects you would use in the plugins are very similar to the ones in the normal C# application.

Hope this helps.

Don

PS just in case you don't know direct SQL update/inserts/delete into the CRM data are unsupported by microsoft.

Friday, June 27, 2014 10:14 PM
0

Sign in to vote

In addition to that you should be able to achieve your requirement using instance adapter as well
Our Website| Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

Saturday, June 28, 2014 9:22 AM

Moderator