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. Go to Start of the navigation path (Main Menu) Next navigation step  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 but also when running both products in the same tenant.

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. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path
    The Select a Datasource 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 logon to SAP Data Warehouse Cloud.
  2. Enter a valid username and password for SAP Data Warehouse Cloud and click OK to setup the connection.

Next Steps

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

  1. From the () Main Menu, select Start of the navigation path Create Next navigation step  StoryEnd of the navigation path.

  2. Select Access & Explore Data and from the dialog choose Data from a datasource

    The Select a Datasource dialog appears.

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

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

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

  6. 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 current limitations on the data from live connections to SAP Data Warehouse Cloud. Check out 2832606 Information published on SAP site for details.