Remove From My Forums

MSCRM 2013 Integration - SSIS or Web Services

Question
0

Sign in to vote

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

0

Sign in to vote
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 PM

Moderator
0

Sign in to vote
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 AM

Moderator

All replies

0

Sign in to vote
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 PM

Moderator
0

Sign in to vote

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
0

Sign in to vote
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 AM

Moderator

Answered by:

MSCRM 2013 Integration - SSIS or Web Services

Question

Answers

All replies