locked
Can't connect to Dynamics 365 using ADF v2 RRS feed

  • Question

  • Hi guys,

    I'm trying to connect to Dynamics 365 using ADF so that I can replicate the data to an Azure SQL Database.

    I've tried setting up an Integration Runtime with the same location (Australia East) as our CRM.

    No luck all!... It says "Unable to connect to Dynamics CRM"

    I've also tried connecting using the Odata feed, no luck. I've tried connecting to the same Odata URL using PowerBI just to make sure I had the URL correct and I WAS ABLE to connect using Power BI.

    Can you please help a brother out? 

    Fellow users who also had this problem, how were you able to connect?

    Cheers!


    • Edited by K.Zarar Saturday, May 25, 2019 3:43 AM
    Saturday, May 25, 2019 3:42 AM

All replies

  • Hi,

    Have you tried connecting to dynamics crm using data migration tool ? 

    https://community.dynamics.com/enterprise/b/dynamics365enterprisecloudfronts/archive/2017/04/25/crm-data-migration-tool

    You might want to check that out to make sure everything's right. 

    Also, have a look at this (similar) issue that may provide more insights:

    https://social.msdn.microsoft.com/Forums/azure/en-US/7ee778b2-5c9f-4697-8a40-c307c817c7f6/azure-data-factory-v2-dynamics-crm-and-dynamics-online-linked-services?forum=AzureDataFactory

    Monday, May 27, 2019 10:15 AM