Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connecting to CRM 2011 Web Service using SSIS 2008 Expand / Collapse
Author
Message
Posted Wednesday, February 15, 2012 3:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, February 16, 2012 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, March 6, 2012 8:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 11:11 AM
Points: 1, Visits: 18
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
Posted Friday, December 21, 2012 8:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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
Posted Friday, February 15, 2013 3:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, February 18, 2013 5:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:46 AM
Points: 119, Visits: 484
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 »

Add to briefcase

Permissions Expand / Collapse