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

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 (menu) XS Artifact Administration.
2. In the Packages area, select sap bc ina service v2.
  
  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:
1. Go to (Main Menu) Connection Connections (Add Connection)
  
  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 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.
Note

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

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.