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.


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

    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.

    For SAP HANA version 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.


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


  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 data source 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.

      This information is available from the SAP Cloud Platform Cockpit overview screen, when you have a running SAP HANA instance.

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

    (Beta) Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories. For details on scheduling, see Schedule a Publication.


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

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.