Connecting to CRM 2011 Web Service using SSIS 2008

Question

Post reply

Connecting to CRM 2011 Web Service using SSIS 2008

pukkauk

Valued Member

Points: 60
More actions
February 15, 2012 at 3:11 pm

#264515

I would like to backup MS Dynamics CRM 2011 Online using SSIS. My current code allows me to download known entities and known fields one record at a time. The issues I have to solve include..
1. How do I obtain a list of all entities
2. How do I obtain a list of all fields within each entity
3. How can I download - lets say 500 records at a time.
I do not want to use expensive ETL tools. I prefer to use SSIS.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

pukkauk Valued Member Points: 60 More actions · Answer 1

Hi

MS Support provided me this information. That we may all find useful in relation to this query.

http://msdn.microsoft.com/en-us/library/cc151047.aspx

Any further info on initial question and above is welcome

How can I download more that 1 record at a time from MS Dynamics CRM Online 2011

Thanks

danielcai SSC Journeyman Points: 99 More actions · Answer 2

Writing C# code in SSIS to talk to CRM web service is not an easy take. We have an affordable solution which you can check out.

http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

Another inexpensive alternative for SSIS is the COZYROC SSIS+[/url] library. It includes Dynamics CRM adapters among many other useful extensions. All deployment types are supported: Premise, Live, Hosted, Federation. No programming skills are required. The pricing starts at $399.95/Year

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

ramdane.berkane Newbie Points: 5 More actions · Answer 4

Hello,

I tried to use SSIS 200R2 and Dynamics CRM Online but I have an error when I tried to authenticate Dynamics CRM Online from Dll 3.5 library proxy.

Did you succed the authentication ?

please help me.

Thanks in advaned,

Ramdane.

Paul Hernández SSCarpal Tunnel Points: 4961 More actions · Answer 5

Hi,

In my current job the Cozyroc componets are used and I can recommend them. It´s a supported way to write data into the CRM entities. However, to make a backup you don't need to write data, instead you just need to read data.

To solve your issues:

1. How do I obtain a list of all entities -- Use the data dictionary (i.e. InformationSchema System Views)

2. How do I obtain a list of all fields within each entity -- Use the data dictionary (i.e. InformationSchema System Views)

3. How can I download - lets say 500 records at a time. -- Use the Cozyroc library, make your own component extension. The problem hier is how to make a kind of batch/bulk request to the web service. The Cozyroc "Dynamic CRM Source" has an option called "BatchSize" (Specify the number of rows to be retrieved as a batch. The maximum is 500.) Here is the link to the documentation. I think you could try it for free.

If not you could always extend a component, but you have to put in a balance the development cost and time in order to accomplish such a task.

Kind Regards.

Paul Hernández