none
An error occurred OData Basic Authentication with Azure Data Factory Connectivity

    Question

  • Please tell me about azure error. I have tried OData Basic Authentication with Azure Data Factory Connectivity.
    However an error occurred it.

    Error Message is UserError: Failed to create OData connection to https://*** to get metadata of odata service, please check if service url and credential is correct., activityId: 53f78879-d2f7-4b48-94cf-46095ff06166

    Saturday, April 14, 2018 3:50 PM

All replies

  • Hi Kazuya,

    Is your OData endpoint publicly accessible?

    If your OData endpoint is in a private network, make sure you are connecting via a self-hosted integration runtime:

    https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#self-hosted-integration-runtime

    https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime

    Tuesday, April 17, 2018 10:26 PM
    Moderator
  • Hi Jason

    Thank you for your reply.

    >Is your OData endpoint publicly accessible?

    Yes. It's publicly access endpoint.
    Because It's Dynamics 365 Business Central OData Endpoint, and I checked access from Postman app.

    Wednesday, April 18, 2018 5:00 AM
  • I am using OData for Onprem SharePoint connection - using self-hosted runtime. its not working, I keep getting 403 access forbidden.  I feel - ADF Odata will need OATH 2.0 connection, which It does not supports right now.  
    Wednesday, June 13, 2018 5:42 PM