Skip to Content

Connect SAP Analytics Cloud to SAP Data Warehouse Cloud

Intermediate
10 min.
SAP Data Warehouse Cloud, Intermediate, Tutorial, SAP Analytics Cloud
With SAP Data Warehouse Cloud and SAP Analytics Cloud together, you can handle complex analytics scenarios based on hybrid system architectures. Learn how to connect SAP Analytics Cloud to SAP Data Warehouse Cloud in this tutorial.
You will learn
  • How to connect SAP Analytics Cloud to SAP Data Warehouse Cloud
jmmargojmmargoJanuary 20, 2023
Created by
jmmargo
January 6, 2023
Contributors
jmmargo
meganhoy

Prerequisites

  • Step 1

    In order to ensure the data entities and models created in your SAP Data Warehouse Cloud tenant are consumable by SAP Analytics Cloud, it is important to expose them for consumption.

    If the entity was created in the data builder, simply click on the entity and set the Expose for Consumption toggle to ON as below.

    Consumable

    If the entity was created in the business builder, the toggle shows up as a Allow public data access checkbox in it’s properties tab. Simple click on the data entity to open it, and ensure the checkbox is ticked.

    Consumable
  • Step 2

    Until now, SAP Data Warehouse Cloud delivered an embedded version of SAP Analytics Cloud with a five user license, but most of our customers either already had an existing SAP Analytics Cloud tenant or needed far more than the embedded 5 user license. Therefore, starting February 2021, customers that purchase SAP Data Warehouse Cloud will then become two separate tenants, one for SAP Data Warehouse Cloud and one for SAP Analytics Cloud.

    You can connect SAP Data Warehouse Cloud as a remote live connection to any SAP Analytics Cloud system. SAP Data Warehouse Cloud and SAP Analytics Cloud need to be on different tenants.

    1. To link the SAP Analytics Cloud to the SAP Data Warehouse Cloud tenant, navigate to Configuration on the bottom left, and select Tenant Links.

    2. Here, you can enter the link to your SAP Analytics Cloud tenant.

    In SAP Analytics Cloud, you can now create stories using SAP Data Warehouse Cloud data as a source and combine it with additional data (e.g. from a file).

    If required any number of SAP Data Warehouse Cloud systems from multiple tenants can be connected to any SAP Analytics Cloud system. Any SAP Data Warehouse Cloud can be connected to any SAP Analytics Cloud as a live data connection. For more information, see the official SAP Data Warehouse Cloud documentation.

    When you link your tenants, you’ll enable the product switch in the top right of the shell bar, and be able to easily navigate between them.

    Switcher

    Well done!

    You have completed the 1st tutorial of this group! Now you know how to connect SAP Analytics Cloud to SAP Data Warehouse Cloud.

    Learn in the next tutorial how to create a database user in SAP Data Warehouse Cloud.

  • Step 3

    What does the combination of SAP Data Warehouse Cloud and SAP Analytics Cloud provide?

Back to Top
Back to top