CubeServ Blog
Stay up-to-date on the data-driven business with tools for analytics from SAP & Co. and do not miss any news, downloads & events.

Activate data exchange Data Warehouse Cloud and SAP Analytics Cloud

SAP has created a new option for data exchange between Data Warehouse Cloud (DWC) and SAP Analytics Cloud (SAC): OData API. This allows you to use another useful SAP function – especially for planning applications.

OData (Open Data Protocol) is a standardized protocol for data exchange between different systems and is mainly used for cloud data sources. The interface offers a practical integration of DWC and SAC. It is also a way of saving the data recorded in SAC in DWC.

The following video shows in detail how to activate the interface:

A few steps to the interface

  1. Look up the redirect URL in SAC
    Identify the redirect URL for the connection to DWC in SAC.
  1. Create an OAuth client in DWC
    Create a new OAuth client in DWC with the redirect URL.
  1. Identify OData connection parameters in DWC
    Data Service URL
    OAuth Client ID
    Secret
    Token URL
    Authorization URL
  1. Identify OData source in DWC (Data Service URL)
    Search the available Spaces in DWC with a URL and verify the assets contained therein. Identify the dataset and copy the Asset Relational Data URL required for the SAC OData connection.
  1. Create OData connection in SAC
    Create the OData connection in SAC. Use the DWC connection parameters.

Once the connection has been successfully created, you can import the data from the OData connection into SAC.

Prerequisites

The following requirements must be met before you can use the interface:
  • DWC version 2022.11 and higher
  • The interface must first be activated by SAP. You must request this from the SAP Help Portal.
As soon as the interface is activated, you can start with the configuration.
Front End
Marina Yesayan

Import SAP analysis authorizations into Power BI

We take a look at the question of whether it is possible to import SAP analysis authorizations directly from SAP and thus integrate them seamlessly into Power BI. Read our article and find out more about the possibilities.

REST-API
Uncategorized
Marina Yesayan

Transfer data to SAP BW via REST API

Our training video on the REST API interface in ABAP programming shows how you can transfer data from other data sources to the SAP Business Warehouse (BW) and process it there.

Subscribe our Newsletter

Keep up to date on SAP Analytics Cloud, SAP Data Hub, and Big Data, and do not miss any news, downloads & events.

Author
Expert Team