Failed to create odata connection to RequestUrl

Yeshwant Muralidhar 1 Reputation point
2022-08-15T17:54:54.37+00:00

I am trying to connect to SAP ECC using ADF. We have activated the OData Service in SAP ECC, but when we enter the URL in the Linked serivce and test connection i get following error

Failed to create odata connection to RequestUrl.
An error occurred while sending the request.
The remote name could not be resolved: 'mmc-sapides01'

Can anyone guide on what could be the issue and how to solve it.

Thanks
Yeshwant

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
119 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,481 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2022-08-17T17:05:29.19+00:00

    Hello @Yeshwant Muralidhar ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to connect the odata service and connet to OData Service in SAP ECC , please do let us know if its not accurate.
    From the error details which you have pasted , it seems to me that the odata service is running locally/local network . If thats the case we need to use SHIR .

    https://learn.microsoft.com/en-us/azure/data-factory/connector-odata?tabs=data-factory#prerequisites

    << snippet from the link above >>

    Prerequisites

    If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.
    If your data store is a managed cloud data service, you can use the Azure Integration Runtime. If the access is restricted to IPs that are approved in the firewall rules, you can add Azure Integration Runtime IPs to the allow list.
    You can also use the managed virtual network integration runtime feature in Azure Data Factory to access the on-premises network without installing and configuring a self-hosted integration runtime.
    For more information about the network security mechanisms and options supported by Data Factory, see Data access strategies.

    Please do let me if you have any queries.
    Thanks
    Himanshu

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments