Ssis and Crm

Ssis and Crm

Post by ZG90bmV0Zm » Thu, 03 May 2007 03:00:01


Please confirm.

Ssis does not have a source/transformation/destination adapter for
connecting to Ms Crm.

Scribe is the preferred solution for interfacing with the Ms Crm Web Service
Interface.

Are there plans for an Ssis Ms Crm interface?
 
 
 

Ssis and Crm

Post by ZG90bmV0Zm » Fri, 04 May 2007 01:11:01

I suppose I ought not expect a reply to my question anytime soon?

 
 
 

Ssis and Crm

Post by TWljaGFlbC » Fri, 04 May 2007 02:40:01

Depends on what you want to do. If it's a one-time data migration into CRM,
then you can use the Data Migration Framework and/or the Bulk Import utility.

If it's more of an ongoing integration, then Scribe is a better choice.
Otherwise, you will need to create a custom application.

Michael Cross
Navint
http://www.yqcomputer.com/
 
 
 

Ssis and Crm

Post by ZG90bmV0Zm » Fri, 04 May 2007 07:16:00

I was told that data migration could not be used for custom entities.

I was told that using data migration is cumbersome and does not offer useful
error messages.

Is it true?
 
 
 

Ssis and Crm

Post by ZG90bmV0Zm » Fri, 04 May 2007 07:19:02

How does one become familiar with the Crm Sdk?

Also, when I downloaded the kit from the microsoft download site, I did not
find any compiled assemblies there. There were a couple of assemblies that
the sample projects appear to want to reference, but I could not find them
anywhere.

Is there a good book or guide to learning this toolkit?
 
 
 

Ssis and Crm

Post by TWljaGFlbC » Fri, 04 May 2007 09:25:00

Yes on both counts. The Data Migration Framework is definitely not the
perfect tool.

Both Scribe Insight and c360 Import Manager can be good choices for a
one-time data migration involving custom entities. They both use the CRM SDK,
so they are considered to be supported by Microsoft.

Unless you're a serious programmer, or have access to one, trying to build a
data migration solution yourself using the CRM SDK is going to be hard.

You can access the CRM SDK through the Microsoft website. Just search for it.

Michael Cross
Navint
http://www.yqcomputer.com/
 
 
 

Ssis and Crm

Post by John O'Don » Fri, 04 May 2007 12:20:19


best book outside of the offiicial microsoft training courses is this book

http://www.yqcomputer.com/



==============================
John O'Donnell
Microsoft CRM MVP
http://www.yqcomputer.com/
 
 
 

Ssis and Crm

Post by ZG90bmV0Zm » Sat, 05 May 2007 01:29:06

Hi John, Thanks for that. That will be a help. I just ordered it.
 
 
 

Ssis and Crm

Post by QnJ1Y2UgTm » Thu, 10 May 2007 04:25:00

Hi there

We have developed an SSIS component which can connect CRM to a data
destination and visa versa. This is performed through the supported Microsoft
CRM 3.0 web service interface.

If you wish to request pricing or have any further questiosn please feel
free to contact me at: bruce (at) i5.co.za

Regards,
Bruce
 
 
 

Ssis and Crm

Post by ZG90bmV0Zm » Sat, 12 May 2007 10:59:02

Yeah, e-mail me at dotnetfellow ( a t ) yahoo.com