Live Data Connection to SAP Universes Using a Direct Connection

You can create a direct live data connection to SAP BusinessObjects Business Intelligence (BI) Universes.

Prerequisites

Caution

As of Google Chrome version 80, Chrome restricts cookies to first-party access by default, and requires you to explicitly mark cookies for access in third-party, or cross-site, contexts.

To ensure that Chrome and other browsers allow cross-site access to your SAP on-premise data source cookies from SAP Analytics Cloud, you must configure your SAP on-premise data source to issue cookies with specific attributes. Without these settings, user authentication to your live data connections will fail, and Story visualizations based on these connections will not render.

For details, see SameSite Cookie Configuration for Live Data Connections.

Make sure that you have the following elements in place before installing the SAP BusinessObjects Live Data Connect component for SAP Analytics Cloud:

  • An SAP BusinessObjects Business Intelligence 4.2 SP9, 4.3 SP1 or higher system installed.
  • An SAP BusinessObjects Web Intelligence license
  • Microsoft Visual C++ 2015 Redistributable Packages.
  • A signed SSL certificate in JKS format for the machine running SAP BusinessObjects Live Data Connect.
  • One of the supported operating system listed below:
    • Windows Server 2012 R2
    • Windows Server 2016
    • Windows Server 2019
    • SuSE SLES 12 x86_64
    • SuSE SLES 15 x86_64
    • RedHat EL 7.7 x86_64
    • RedHat EL 8 x86_64
    • Oracle Linux 7.2 (RHCK) (UEK)
    • Oracle Linux 7.5 (RHCK) (UEK)
    • Oracle Linux 7.7 (RHCK) (UEK)
  • You must configure CORS to work with the SAP BusinessObjects Live Data Connect component. For more information, see Configuring Cross-Origin Resource Sharing (CORS).

With the 3.0 release, the Java Virtual Machine, the application server and the .war file are shipped as a standalone executable package.

Context

You can leverage your SAP BusinessObjects Business Intelligence system and get access to SAP Universes directly and Web Intelligence documents in SAP Analytics Cloud using the SAP BusinessObjects Live Data Connect component.

Procedure

  1. Verify end-users' web browser configuration and access.

    Your end users' web browsers must be configured to:

    • Allow pop-up windows from your SAP Analytics Cloud domain, if you'll be choosing the single sign-on (SSO) authentication method in step 2. For example:
      [*.]sapanalytics.cloud
      [*.]hanacloudservices.cloud.sap
      [*.]hcs.cloud.sap
      [*.]analytics.sapcloud.cn
    • Allow 3rd party cookies from the Tomcat server's domain. For example, in Internet Explorer 11, go to Start of the navigation pathInternet Options Next navigation step Security Next navigation step Trusted SitesEnd of the navigation path, add your domain name, then select Enable Protected Mode.
  2. Add a remote system to SAP Analytics Cloud:
    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 will appear.
    2. Expand Connect to Live Data and select SAP Universe.
    3. In the dialog, enter a name and description for your connection.
      The connection name cannot be changed later.
    4. Set the connection type to Direct.
    5. Add your SAP BusinessObjects Live Data Connect server host name, and HTTPS port. The HTTPS port is referenced by the connector.https.port parameter in the ldc.properties file.
    6. Select an Authentication Method and set the required information.
      Choose one of the following options:
      • Select SAML Single Sign-On if you use SAML SSO.
      • Select User Name and Password if you use basic authentication, and enter your credentials for the remote system.
      Note
      After creating a connection to a remote system and before creating a model from a remote system, you must log off and log on to SAP Analytics Cloud again.
    7. Enter an SAP BusinessObjects BI user name and password.
    8. Select OK.
  3. Enable the SAML identity provider using the steps described in the Enable a Custom SAML Identity Provider section.