Live Data Connections to SAP Data Warehouse Cloud
You can create live data connections to SAP Data Warehouse Cloud systems.
- Log in to your SAP Data Warehouse Cloud system with an administrator account.
- Click in the top bar and select Analytics to switch to your embedded Analytics application.
- From the side navigation, choose .
- Go to the Trusted Origins section and click Add a Trusted Origin.
Add the URL of your separate SAP Analytics Cloud system.
- Click Save.
If you have an SAP Data Warehouse Cloud tenant, you can leverage and combine the data management and modeling capabilities of SAP Data Warehouse Cloud with the business intelligence, predictive, and planning features in SAP Analytics Cloud. By creating a live connection in the Connections area to your SAP Data Warehouse Cloud tenant, your content creators can build stories directly against the data that is modeled in SAP Data Warehouse Cloud. Live connections between SAP Analytics Cloud and SAP Data Warehouse Cloud can be established across tenants and data centers.
Who can use this feature? Users with Execute permission on Other Datasources and Create, Read, Update, Delete, and Maintain permission on Connection.
From the side navigation, choose
.The Select a data source dialog appears.
- Expand Connect to Live Data and select SAP Data Warehouse Cloud.
In the dialog, enter a name and description for your connection.
The connection name cannot be changed later.
Add your SAP Data Warehouse Cloud host name and enter
443 as the HTTPS port.
For example, mydatawarehouse.eu10.hcs.cloud.sap and 443. You can copy the host name from the browser's address bar when logged on to your SAP Data Warehouse Cloud tenant:
Note that 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.
- Click OK and you'll be prompted to log on to SAP Data Warehouse Cloud.
- Enter a valid username and password for SAP Data Warehouse Cloud and click OK to set up the connection.
From the side navigation, choose Stories.
Under Create New, choose one of the story types.
Use the Story/Data control to switch to Data, and from the dialog choose Data from a data source
The Select a data source dialog appears.
Expand Connect to Live Data and select SAP Data Warehouse Cloud.
(Optional) If there is more than one SAP Data Warehouse Cloud connection to choose from, select the new connection you just created and click OK.NoteIf there is only one connection then it is selected automatically and this dialog is not displayed.
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 dataset and click OK.TipOnly Analytical Datasets are supported. If you don't see your dataset, check that it's deployed and set to allow consumption in your SAP Data Warehouse Cloud system.You can check the status of your Analytical Dataset in the Data Builder's Properties panel.