Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Connecting to CRM 2011 Web Service using SSIS 2008


Connecting to CRM 2011 Web Service using SSIS 2008

Author
Message
pukkauk
pukkauk
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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.
pukkauk
pukkauk
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
danielcai
danielcai
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 20
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
CozyRoc
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1150 Visits: 2235
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/


ramdane.berkane
ramdane.berkane
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
Paul Hernández
Paul Hernández
SSC-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 Visits: 654
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search