Live Data Connection to SAPCP with Password Authentication

You can create a live data connection to an SAP Cloud Platform (SAPCP) system, and give an SAP HANA user permissions to use the connection in SAP Analytics Cloud.

Prerequisites

  • You have set up and activated the SAP HANA Info Access Service (InA), version 4.10.0 or above, on your SAP HANA system.
    Note

    For more information on how to set up your SAP HANA InA service, see Installing the SAP HANA Info Access Toolkit, API and Service.

  • The SAP HANA user you add must be assigned the sap.bc.ina.service.v2.userRole::INA_USER role.
    Note

    For SAP HANA version 1.00.112.04 and above, users require both the INA_USER role, and additional object rights. The SAP HANA administrator must grant users SELECT privileges on all view items in the _SYS_BIC schema that users should have access to. For more information, see SAP Knowledge Base Article 2353833.

Note

For information on supported versions of SAP HANA, see System Requirements and Technical Prerequisites.

Procedure

  1. Enable basic authentication in your SAP HANA system.

    The following steps must be completed if basic authentication is not enabled:

    1. In the XS Admin page of your SAP HANA system, select Start of the navigation path (menu) Next navigation step XS Artifact AdministrationEnd of the navigation path.
    2. In the Packages area, select Start of the navigation pathsap Next navigation step bc Next navigation step ina Next navigation step service Next navigation step v2End of the navigation path.

      The SAP Security and Admin page appears.

    3. Select Edit.
    4. Select the Basic Authentication checkbox if the checkbox is not already enabled.
    5. Select Save.
  2. Add a remote system to SAP Analytics Cloud:
    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 will appear.

    2. Expand Connect to Live Data and select SAP HANA.
    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 SAP Cloud Platform.
    5. Add your SAPCP account name, database name, and landscape host.
      Note
      The following landscape hosts are not yet available: Europe (Frankfurt), KSA (Riyadh), Russia (Moscow), UAE (Dubai).
    6. (Optional) Choose a Default Language from the list.
      This language will always be used for this connection and cannot be changed by users without administrator privileges.
      Note
      You must know which languages are installed on your SAPCP system before adding a language code. If the language code you enter is invalid, SAP Analytics Cloud will default to the language specified by your system metadata.
    7. Under Authentication Method, select User Name and Password.
    8. Enter an SAP HANA user name and password.
      Note
      The user must be assigned to the sap.bc.ina.service.v2.userRole::INA_USER role in SAP HANA.
    9. (Optional) Select Save this credential for all users on this system.

      If this option is selected, all users with Read or Maintain privileges on the Connection permission will be able to view all models or stories created from this connection that the user entered in Step 7 has access to. For more information, see Permissions.

    1. Select OK.

Results

The connection is saved. The user whose credentials you added will have access to the live data connection.
Note

If the user logs out of SAP Analytics Cloud, or closes the browser, they will need to enter their user name and password to use the remote connection again.

The connection is not tested until you create a model. For more information, see Creating a Model from a Live Data Connection.