Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Extract Data from CRM Online 2013 to Azure RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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