3558656 - OData Service Error when calling API

• "Unable to connect to datasource" error appears when trying to create the OData connection

• SAP Analytics Cloud
• Odata based connection

1. Launch SAC Tenant
2. Select Connection
3. Select + to add Connection
4. Select OData Services for datasource type
5. Provide Connection Name as desired
6. Enter Data Service URL value (Odata URL)
7. Change Authentication Type to No Authentication
8. Click Create

The error "Unable to connect to datasource" appears and the connection does not get created

• Not all "OData" looking connections are created equal
• In order for SAC to properly recognize an OData URL, there must be metadata available from the service URL
• Usually it is a simple test of adding the $metadata syntax to the end of the given OData URL (eg. https://Odata_URL/$metadata)
• If you get an error after adding this syntax, then there is an issue with the metadata and SAC will have an issue trying to use it

We don't get involved in resolving why there is no metadata returned from the service URL, you would need to discuss this with whomever administers the OData datasource that you are wanting to use

SAC Odata metadata , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem