Live Data Connections to SAP Data Warehouse Cloud

You can create live data connections to SAP Data Warehouse Cloud systems.

Prerequisites

Before setting up your live connection in SAP Analytics Cloud, you first need to add the URL of your SAP Analytics Cloud as a trusted origin in your SAP Data Warehouse Cloud system.
  1. Log in to your SAP Data Warehouse Cloud system with an administrator account.
  2. Click in the top bar and select Analytics to switch to your embedded Analytics application.
  3. From the side navigation, choose Start of the navigation path System Next navigation step  Administration Next navigation step App IntegrationEnd of the navigation path.
  4. Go to the Trusted Origins section and click Add a Trusted Origin.

  5. Add the URL of your separate SAP Analytics Cloud system.

  6. Click Save.

Context

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.

Note

Who can use this feature? Users with Execute permission on Other Datasources and Create, Read, Update, Delete, and Maintain permission on Connection.

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source dialog appears.
  2. Expand Connect to Live Data and select SAP Data Warehouse Cloud.
  3. In the dialog, enter a name and description for your connection.
    The connection name cannot be changed later.
  4. 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.

  1. Click OK and you'll be prompted to log on to SAP Data Warehouse Cloud.
  2. Enter a valid username and password for SAP Data Warehouse Cloud and click OK to set up the connection.

Next Steps

Once the connection is set up, test the connection by creating a new Story.

  1. From the side navigation, choose Stories.

  2. Under Create New, choose one of the story types.

  3. 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.

  4. Expand Connect to Live Data and select SAP Data Warehouse Cloud.

  5. (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.

    Note
    If there is only one connection then it is selected automatically and this dialog is not displayed.

  6. In the Select Your Space dialog, select an SAP Data Warehouse Cloud space with the data you want to access.

  7. In the Select Your Data dialog, select your dataset and click OK.

    Tip
    Only 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.
The data should load successfully. Add a simple chart with measures and dimensions to check that you see the data from SAP Data Warehouse Cloud.
Limitations
There are usage restrictions on the data from live connections to SAP Data Warehouse Cloud. Check out 2832606 Information published on SAP site for details.
Related Information