SAP Knowledge Base Article - Public

3447176 - "Connection to service failed: OData Services. " error raises when trying to create an OData Services Connection

Symptom

The following error message occurs in SAP Analytics Cloud (SAC) when trying to create an OData Services Connection:

"Connection to service failed: OData Services. " 

Environment

SAP Datasphere

SAC Analytics Cloud

Resolution

The following blog contains the step by step of this configuration: 
Using the Datasphere OData API with SAP Analytics Cloud

Double check the Data Service URL maintained, it should be according to the SAP Help documentation:

https://<tenant_url>.cloud.sap/dwaas-core/odata/v4/consumption/relational/<Space_ID>/<view>

The setup of this connection requires to use URL from the view being consumed(with "Exposed for consumption" option), it must be persisted and any remote tables in its lineage must have their data replicated to SAP Datasphere. 
Also, the SAC connection points to a single dataset/view from SAP Datasphere.



See Also

Using the Datasphere OData API with SAP Analytics Cloud

Consume SAP Datasphere Data in SAP Analytics Cloud via an OData Service

Keywords

Data Service URL, Acquisition, dwc, correlation id , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Problem

Product

SAP Analytics Cloud all versions ; SAP Datasphere all versions