Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Fetch data from CRM 2011 to SQL Server

Answered Fetch data from CRM 2011 to SQL Server

  • Sunday, March 03, 2013 5:05 PM
     
     
    Sign In to Vote
    0

    Hi,

    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?

    Regards

    JK

    JJ

     

All Replies

  • Sunday, March 03, 2013 8:40 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    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