Hello,
We are attempting to configure an OData connection from Microsoft Fabric to SAP S/4HANA, in order to consume OData services.
Our goal is to use this connection either via the Copy Data activity in Data Factory or through Dataflow Gen2—either approach is acceptable for our scenario.
We have set up an on-premises Data Gateway that has connectivity to SAP and includes all required libraries. We are using a service account that has the necessary permissions to access the SAP environment.
Following the official documentation (link), we tried to connect to the root of the OData service.
However, we encountered the following error:
Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (The server has not found any resource matching the Data Services Request URI)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (The server has not found any resource matching the Data Services Request URI)
Details:
Reason = DataSource.Error
ErrorCode = 10122
DataSourceKind = OData
DataSourcePath = https://<sap-hostname>:<port>/sap/opu/odata
Interestingly, when connecting directly to a specific OData service—for example:
https://<sap-hostname>:<port>/sap/opu/odata/sap/API_COMPANYCODE_SRV/A_CompanyCode
—we are able to successfully retrieve data.
The question is: how can we connect to the root OData service URL in order to browse and list all available OData services? We would like to avoid creating a separate connection for each individual OData endpoint if possible.
Thank you for your support.
