Symptom
Connecting to a ODATA url in the on-premise system like http://<Hostname>:<Port>/sap/opu/odata/IWBEP/RMTSAMPLEFLIGHT_2/?sap-client=<cient_number> gives error Cause:
Invalid odata connection! Getting odata metadata failed because of <HTTP/1.1 200 OK> Get $metadata
response:<metadata.xml> Exception: Tag with name 'Edmx' was not found.
Environment
SAP Datasphere
Cause
Currently SAP Datasphere supports only ODATA URL without the client information.
Resolution
Review and adjust the following settings:
- In the on-premise system, set the relevant client as the default client.
- Ensure the OData service URL is published under the default client.
See Also
- KBA 3192250 - Generic Odata connection couldn’t be established
- SAP Help Portal Documentation: How to set up a Generic OData connection in SAP Datasphere
Keywords
ODATA, Datasphere, on-premise, S/4 HANA, Generic ODATA connection, client, Exception: Tag with name 'Edmx' was not found , KBA , DS-DI-CON , Connections , Problem
SAP Knowledge Base Article - Public