SAP Knowledge Base Article - Public

3563695 - How to create Odata connection to SAP Datasphere in SAP Analytics Cloud (SAC)

Symptom

It is requested to create a new Odata Service Connection in SAP Analytics Cloud connecting to SAP Datasphere.

Environment

  • SAP Analytics Cloud (SAC)
  • SAP Datasphere

Reproducing the Issue

NA

Cause

NA

Resolution

  1. Log on to SAC tenant and navigate to Connections > Create a new Odata Service Connection.
  2. Authentication Type set to Oauth 2.0 Authorization Code, then note down the Redirect URL for this connection.
  3. Keep the dialog open and open a new browser tab to logon to SAP Datasphere system, navigate to System > Administration > App Integration
  4. Note down Authorization URL and Token URL under Oauth Clients in this page.
  5. Click to add an Oauth Client
  6. Give it a name and Purpose set to Interactive Usage, for Redirect URL input the information copied in step 2
  7. Click Add and Copy the Secret (The secret Key for this Oauth client can only be copied during creation.)
  8. Note down the Client ID for this new-created Oauth Client in SAP Datasphere.
  9. Navigate back to SAC and open the previous page for creating Odata Service Connection.
  10. Give it a connection name.
  11. Data Service URL should be in following format:
    https://<TenantURL>.cloud.sap/api/v1/dwc/consumption/relational/<SpaceID>/<View>
  12. Oauth Client ID please use the ID copied in step8.
  13. Secret is the Secret key copied in step7.
  14. Input Token URL and Authorization URL copied in step4.
  15. Click Create.

See Also

Keywords

Best practice, guide, document, DWC, imported, import, acquired , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0