3780465 - Odata service connection fails using administration namespaces/providers endpoint in data export api (error: connection to service failed: odata services) - SAP analytics cloud

• Creating an OData Service connection with the Data Export API path /api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers fails during validation.
• Error message: "Connection to service failed: OData Services."
• Creating an OData Service connection using the Data Export API endpoint /api/v1/dataexport/providers/sac/<model_id> succeeds.

SAP Analytics Cloud

1. Open the OData Service connection creation workflow.
2. Enter the Data Service URL pointing to /api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers.
3. Provide required authentication details and attempt to save the connection.
4. Observe the validation error: "Connection to service failed: OData Services."

The specified Data Service URL is not an OData service root endpoint.

During creation of an OData Service connection, SAP Analytics Cloud validates that the specified Data Service URL is an OData service root endpoint by accessing:

<Data Service URL>/$metadata

Since

/api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers

is not an OData service root endpoint, the corresponding

.../$metadata

is not a valid metadata endpoint. As a result, the connection validation fails.

• Specify an OData service root endpoint as the Data Service URL.
  Examples of valid OData service root endpoints include:
  - /api/v1/dataexport/administration
  - /api/v1/dataexport/providers/sac/<model_id>
  These endpoints expose the required metadata document at: <Data Service URL>/$metadata and can therefore be used successfully when creating an OData Service connection.
• Do not use /api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers as the Data Service URL, as it is not an OData service root endpoint and cannot pass the required metadata validation.
• If the intention is to use a single OData Service connection for multiple planning models by specifying the endpoint /api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers, this scenario is currently not supported because the endpoint is not an OData service root endpoint.
  If this functionality is required, please submit an enhancement request through the SAP Influence channel: https://influence.sap.com/sap/ino/#/campaign/884.

• refer to: Create OData Services Connections
• refer to: Use Data Export Service to replicate data
• refer to: SAP Analytics Cloud Influence

odata service connection, data export api, $metadata, odata service root endpoint, namespaces providers, connection to service failed: odata services, sac planning model, providers/sac, data service url validation, create connection error, multiple models, administration endpoint, metadata validation, odata root url, sac data integration , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem