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.

Who does this apply to?
  • Users with any of these permissions for Connections: Create, Read, Update, Delete, and Maintain.
  • Users with Execute permission for Other Data Sources.
  • Users with any of these standard application roles: Admin, Application Creator, BI Content Creator, BI Admin, and Planner Reporter.
  • Setting up a live connection requires working with the SAP Analytics Cloud system owner and different IT and application stakeholders within your organization. Most configuration steps are done on your SAP HANA server before creating the connection in your SAP Analytics Cloud tenant.
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 Info Access, Toolkit, API, and Service.

  • If end users will access the live data connection from outside of your corporate network, ensure that the SAP Information Access (InA) service (/sap/bc/ina/service/v2) on your SAP HANA server is exposed to browser users directly.
  • Ensure that the sap.bc.ina.service.v2.userRole::INA_USER role is assigned to all users who will use the live connection. This role is required in addition to the usual roles and authorizations that are granted to users for data access purposes.
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.
Related Information

Enable basic authentication in your SAP HANA system

Context

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

Procedure

  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.

Add a remote system to SAP Analytics Cloud

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

    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 SAP HANA 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.
    • For the User Name and Password option, enter an SAP HANA user name and password.
  8. (Optional) Select Save this credential for all users on this system.
    If this option is selected, all users with Read or Maintain permissions for Connection 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.
  9. Select OK.
    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.
    Note
    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.

Results

The connection is saved.
Note
The connection is not tested until you create a model. For more information, see Create a New Model.