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.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
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.
For information on supported versions of SAP HANA, see System Requirements and Technical Prerequisites.
Enable basic authentication in your SAP HANA system.
The following steps must be completed if basic authentication is not enabled:
- In the XS Admin page of your SAP HANA system, select .
In the Packages area, select .
The SAP Security and Admin page appears.
- Select Edit.
- Select the Basic Authentication checkbox if the checkbox is not already enabled.
- Select Save.
Add a remote system to SAP Analytics Cloud:
The Select a data source dialog will appear.
- Expand Connect to Live Data and select SAP HANA.
In the dialog, enter a name and description for your connection.
The connection name cannot be changed later.
- Set the connection type to SAP Cloud Platform.
Add your SAPCP account name, database name, and
This information is available from the SAP Cloud Platform Cockpit overview screen, when you have a running SAP HANA instance.NoteThe following landscape hosts are not yet available: Europe (Frankfurt), KSA (Riyadh), Russia (Moscow), UAE (Dubai).
(Optional) Choose a Default Language from the
This language will always be used for this connection and cannot be changed by users without administrator privileges.NoteYou 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.
- Under Authentication Method, select User Name and Password.
Enter an SAP HANA user name and password.
NoteThe user must be assigned to the sap.bc.ina.service.v2.userRole::INA_USER role in SAP HANA.
(Optional) Select Save this credential for all users on this
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.
- 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.
- Go to
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.