Answered by:
MSCRM 2013 Integration - SSIS or Web Services

Question
-
Dear MVPs,
Few scenarios in which I need your assistance -
a. Need to import data from Flat Files (.csv format) in MSCRM 2013 on scheduled basis,
b. Need to import data from MS SQL 2012 in MSCRM 2013 on scheduled basis
c. Point to Point Integration between MS SQL 2012 and MSCRM 2013 on real time basis.
Kindly suggest approach for the same. Should I go for SSIS packages for scheduled basis and Web Services for real time basis? How far is SSIS Integration supported for MSCRM 2013.
Thanks - Abbas
Sunday, December 8, 2013 12:56 PM
Answers
-
Hello,
I would suggest you to use KingsWay Soft adapter for CRM - http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog
- Edited by Andrii ButenkoMVP, Moderator Sunday, December 8, 2013 3:36 PM
- Proposed as answer by HIMBAPModerator Monday, December 9, 2013 8:57 AM
- Marked as answer by HIMBAPModerator Thursday, April 3, 2014 12:33 AM
Sunday, December 8, 2013 3:35 PMModerator -
Hello Abbas,
In that case if you can do your own custom development and utilize MS CRM APIs, you could develop your custom .net component to get data from flat files and pass this data to MS CRM using web services.
Please check below links if you want for SSIS if you want want to buy SSIS adapter:
http://a33ik.blogspot.in/2012/02/integrating-crm-2011-using-sql.html
http://blogs.msdn.com/b/apurvghai/archive/2012/06/06/ssis-2008-integration-with-crm-2011-on-premise.aspx
HTH
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.- Marked as answer by HIMBAPModerator Thursday, April 3, 2014 12:33 AM
Monday, December 9, 2013 9:03 AMModerator
All replies
-
Hello,
I would suggest you to use KingsWay Soft adapter for CRM - http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog
- Edited by Andrii ButenkoMVP, Moderator Sunday, December 8, 2013 3:36 PM
- Proposed as answer by HIMBAPModerator Monday, December 9, 2013 8:57 AM
- Marked as answer by HIMBAPModerator Thursday, April 3, 2014 12:33 AM
Sunday, December 8, 2013 3:35 PMModerator -
Hi Andrii,
Thanks for your prompt reply.
We don't want to go for any third party components. Can you please suggest something out of the box or with custom development.
Thanks - Abbas
Monday, December 9, 2013 7:14 AM -
Hello Abbas,
In that case if you can do your own custom development and utilize MS CRM APIs, you could develop your custom .net component to get data from flat files and pass this data to MS CRM using web services.
Please check below links if you want for SSIS if you want want to buy SSIS adapter:
http://a33ik.blogspot.in/2012/02/integrating-crm-2011-using-sql.html
http://blogs.msdn.com/b/apurvghai/archive/2012/06/06/ssis-2008-integration-with-crm-2011-on-premise.aspx
HTH
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.- Marked as answer by HIMBAPModerator Thursday, April 3, 2014 12:33 AM
Monday, December 9, 2013 9:03 AMModerator