Azure Data Factory and Dynamics CRM Online

Recently ive been looking at downloading some data from Dynamics CRM Online to Azure Data Lake using Azure Data Factory but I found there was little if any guidance on how to do it with CRM.  There is an OData connector in Data Factory but there was no samples to show you how to use CRM so i decided to do a little nugget video below.

 

 

Also just to call out a couple of Gotchas:

  1. Watch out for the version number in the url for Dynamics.  If you upgrade you might need to modify the url used by data factory
  2. Watch for any entities with un-supported data types and filter those fields using the query and $select option