Connecting to CRM 2011 Web Service using SSIS 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Strategies and Ideas » Connecting to CRM 2011 Web Service using SSIS...

Connecting to CRM 2011 Web Service using SSIS 2008

Rate Topic

Display Mode

Topic Options

Author

Message

pukkauk

Posted Wednesday, February 15, 2012 3:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 20, 2012 9:30 AM
Points: 2, Visits: 4

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.

Post #1252777

pukkauk

Posted Thursday, February 16, 2012 8:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 20, 2012 9:30 AM
Points: 2, Visits: 4

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

Post #1253162

danielcai

Posted Tuesday, March 06, 2012 8:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:00 PM
Points: 1, Visits: 9

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

Post #1262281

CozyRoc

Posted Friday, December 21, 2012 8:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 1,106, Visits: 2,111

Another inexpensive alternative for SSIS is the COZYROC SSIS+ 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/

Post #1399642

ramdane.berkane

Posted Friday, February 15, 2013 3:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 18, 2013 1:17 PM
Points: 1, Visits: 2

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.

Post #1420460

Paul Hernández

Posted Monday, February 18, 2013 5:43 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 7:09 AM
Points: 73, Visits: 253

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
http://hernandezpaul.wordpress.com/
https://twitter.com/paul_eng

Post #1421162

« Prev Topic | Next Topic »

Permissions