Sunday, February 2, 2014

SSIS + Microsoft CRM?

Hi and welcome back?

Do like the POWER of SSIS?

Do you like to migrate/create integrations in hours without writing a single line of .NET an still be able to use the Microsoft CRM API?

Then you will like the following SSIS components:

1. Kingswaysoft
This is my favorite for small/mid-size projects! Extremely easy to install, "no-brainer" components to use if you know SSIS. CHEAP and very nice option to use in POC's!
Gives you the basic components to create a good SSIS integration to MS CRM from any type of database and/or system!

Kingswaysoft have SSIS components to
- AX 2009/2012+
- MS CRM 4.0/2011/2013
- Salesforce

2. PragmaticWork: Task-factory
A SUPER tool if you need components for more then just Microsoft CRM! Gives you an option to choose between a few packages of components. Gives you advanced components to create a good SSIS integration to MS CRM from any type of database and/or system! Mid-size and Large SSIS solutions!

Kingswaysoft have SSIS components to
- MS CRM 2011/2013
- Salesforce
- SharePoint

I always miss the following components when using one of the other SSIS components on this site: 
 - Upsert Destination,
- Advanced Derived Column
- Terminator Destination

- Dimension Merge SCD Transform (formally Kimball SCD)

3. CrazyRocks!
Only used when testing Microsoft CRM SSIS components on the market. So I realy don't know too much about this component. Please update me :)

Hope you liked this post.. I'll soon make a few HOW TO with SSIS!

Best Regards

Inge-Andre Fredrikstad