How to connect SAP Analytics Cloud and 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. As part of the embedded strategy of the SAP Analytics Cloud, each SAP Data Warehouse cloud contains an SAP Analytics Cloud, embedded version. With this you can directly access the data that is available in the warehouse. If you already have an SAC system and want to use DWC as a data source via a live connection, there are two variants:
- Space Aware Connectivity
- Cross-Tenant Connectivity
Space Aware Connectivity
If DWC and SAC are on the same tenant, they are automatically connected. They are now in the so-called “Space-Aware” mode. Artifacts of the SAP Analytics Cloud (Stories and Analytical Applications) can now consume data of particular SAP Data Warehouse Cloud spaces.
To use analytical datasets as data source in a cross-tenant SAP Analytics Cloud, two configurations must be made.
- The SAC tenant must be defined as Trusted Origin in DWC.
- A live connection from SAC to DWC must be established.
Defining a Trusted Origin in Data Warehouse Cloud
For adding a Trusted Origin in SAP Data Warehouse Cloud, you have to switch to the embedded Analytics application. To do so, click on the menu in the upper right corner and select Analytics.
Open Administration via the main menu.
In the administrator view, open App Integration. Scroll to the Trusted Origins section and click Add a Trusted Origin. Add the URL of your separate SAP Analytics Cloud system.
Note: To perform these steps, you need to have administrator role for the DWC tenant.
Add a new live connection
Now we have to switch to the SAP Analytics Cloud, which we just added as Trusted Origin. Open Connection through the main menu.
Expand Connect to Live Data and select SAP Data Warehouse Cloud.
In the next dialog, enter a Name and Description for your connection. Add your SAP Data Warehouse Cloud host name and enter 443 as the HTTPS port.
Note: SAML Single Sign On is preselected as the authentication method allowed. A valid SAP Data Warehouse Cloud user account in that tenant’s Identity Provider is required to log on to the data source.
Choose an analytical dataset as data source in a story
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.
Create a new story. Navigate from the main menu to Create, then Story. Choose Access and Explore Data to create a story. The Let’s add Some data! dialog appears. Select Data from a datasource.
In the dialog, expand Connect to Live Data and select SAP Data Warehouse Cloud. If you have more than one live connection to DWC systems, select the one you want.
In the Select Your Space dialog, select an SAP Data Warehouse Cloud space with the data you want to access. In the Select Your Data dialog, select your Analytical Data Set and click OK.
That’s it! Now the Analytical Data Set is defined as a data model inside the story and you can create the first chart.
More information like product features, roadmaps or guided playlists can be found here:
Yes! I've been looking forward to this. Regards, H
how would one connect an SAC tenant to DWC for Aquired data? This would be for SAC Planning to pull the data in and run planning scenarios.
Hi Jason, I fully understand your use case, but currently it is not possible to set up an import data connection between DWC and SAC.
Hi Josef, is it still not possible to set up an import data connection between DWC and SAC?
I'm sorry, I can't provide any news on this. But when the feature comes, you will certainly be able to read about it in the Road Map Explorer first. Here are the links to the Road Map Explorer for SAP Analytics Cloud and SAP Data Warehouse Cloud.
Thank you for informing us of useful information!
Great tutorial! Thank you!
Hi Josef, Thanks for this blog. After following the steps in DWC and SAC, I am able to see the connection in SAC but somehow the 'Select Space' dropdown does not show any Names from DWC. Could you suggest what could be the possible reasons and how do I fix this.
I have already created and deployed a graphical view in DWC space which is exposed for consumption and can be 'Run in Analytical Mode'
Hi Nikhil Sakhuja, I've faced the same issue. Were you able to solve it?
Great and helpful blog post Josef. Thank you!
I assume I would know both products are setup on the same tenant easily?
If one is setup on "name.eu10.hcs.cloud.sap"
and another is setup on "name-1.eu10.hcs.cloud.sap"
This is not the same tenant right? which means I cannot have "Space Aware Connectivity"?
How should i go about fixing this?
Hi Yan Gerzon i added a reply to your post here: SAC and DWC Space Aware Connectivity | SAP Community . Pls. do keep us posted. regards, H
Hi Yan Gerzon,
Space Aware Connectivity isn't available to tenants priovisioned after version 2021.03. For more informationen see this help page.
Today, you'll always use cross-tenant connectivity to connect SAC and DWC.