Extract Data from CRM Online 2013 to Azure RRS feed

  • Question

  • I need some help and input from the community here. I am using CRM Online 2013 and I have to do reporting with custom code and there are reports that just cannot be done with Fetch XML. So my question is.

    1. Can I use Azure integration with CRM Online 2013 to extract CRM data of entities into Azure DB through some ETL tool like SSIS or any other (recommend please) and do the reporting through SSRS SQL in Azure?

    If yes, then how is there a blog/documentation etc which shows how I extract data from CRM Online and load it into my Azure DB.

    Friday, June 6, 2014 10:56 AM

All replies

  • You could maybe try implementing CRM connector http://www.microsoft.com/en-gb/download/details.aspx?id=10381 This would let you sync the data between the two environments, you would need to investigate scheduling.
    Sunday, June 8, 2014 10:30 PM
  • Are you sure this will help me connect my CRM Online to Azure DB? I think this is a connector for Dynamics products only. Correct me if I am wrong though. 
    Monday, June 9, 2014 7:38 AM