Integrating with SAP Data Warehouse Cloud

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Access data from SAP Data Warehouse Cloud

SAP Data Warehouse Cloud

As part of SAP HANA Cloud Services, SAP Analytics Cloud (SAC) and SAP Data Warehouse Cloud (DWC) are an essential part of the SAP strategy. The combination of both is a powerful tool that is designed for complex analytics scenarios based on hybrid system architectures.

There are several ways to visualize data from DWC in SAC. Each SAP Data Warehouse cloud contains an SAP Analytics Cloud, embedded version. With this embedded version you can directly access the data that is available in the warehouse. If you already have an SAC system, you can access DWC data via a live connection. To do so, an SAC connection must be created and SAC must be added as a trusted origin. For more information, use this link: https://blogs.sap.com/2020/05/19/how-to-connect-sap-analytics-cloud-and-sap-data-warehouse-cloud/.

It is important to know that it is not required to create a data model in SAC. SAP Analytics Cloud can directly access analytical datasets within SAP Data Warehouse Cloud and use it as data source.

Note
As of September 2022, only live connections to DWC are available.

Access Data from SAP Data Warehouse Cloud

Steps

  1. Create a connection to DWC.

  2. In DWC, set the SAC tenant URL as a trusted origin.

  3. In SAC:

    • Create a story
    • Go to the Data tab → Select Datasource → Select the SAP Data Warehouse Cloud live connection. (in the training system the DWC connection should already be set up. If not, use Host: sapeducdwc.eu10.hcs.cloud.sap Port: 443 Authentication Method: SAML Single Sign On.
    • Log into DWC if needed (Note for instructor: see the SSG for the user & password).
    • Select a DWC workspace (such as Business Area Sales in the training server) → Select a DWC Analytical Data Set (such as Sales__Country in the training server).
    • Add a table and configure it with product id in the columns.
    • Save the story.

Save progress to your learning plan by logging in or creating an account