Sunday, March 03, 2013 5:05 PM
My requirement is to fetch CRM 2011 data (probably some tables or view) to SQL Server on a daily basis. The # of records in CRM will be approximately 3000.
What's the best way (probably the simpler way) to call CRM and transfer data to SQL Server?
Sunday, March 03, 2013 8:40 PMModerator
If you are using CRM OnPremise, then the easiest way to get data from CRM is to query it via SQL (query the filtered views). You could create an SSIS package to query the data, and populate your SQL tables, and schedule the package to run via a SqlAgent job.
If you're using CRM Online, then you can only get the data via the CRM web services. There are a few options for this:
- You could still use SSIS, but you'd either have to write code to call the CRM web services, or pay for a 3rd party CRM SSIS component (www.kingswaysoft.com or www.cozyroc.com )
- Or, write a console application to retrieve the data from CRM, write it to SQL Server. You could schedule this via the windows task scheduler, or SqlAgent
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
- Proposed As Answer by Guido Preite Sunday, March 03, 2013 9:59 PM
- Marked As Answer by JLattimerMicrosoft Community Contributor, Moderator Saturday, March 30, 2013 2:55 PM