Configuring a SAP HANA technical User in the On-Premise SAP HANA System

Prerequisites

SAP HANA APL is installed and configured. Refer to the previous section for install information:Installing SAP HANA Automated Predictive Library (APL)

You configure the SAP HANA technical user in your on-premise SAP HANA system:

Create a database schema in your on-premise SAP HANA system, in which predictions are persistent when a user initiates a predictive model training in SAP Analytics Cloud.
Create a technical user in the on-premise SAP HANA system. This user needs the following privileges and roles:
- SELECT privileges on the SAP HANA tables/SQL views used by SAC users for predictive models training and application in SAP Analytics Cloud.
- Privileges on the “write-back” schema that allows the user to write back to the data repository, for example CREATE ANY, UPDATE, INSERT, DELETE and SELECT.
  Example
  Here is a sample SQL Script that you can use: grant SELECT, CREATE ANY, INSERT, UPDATE, DELETE on SCHEMA "<write_back_schema_name>" to <technical_user_name>.
  Replace "<write_back_schema_name>" and <technical_user_name> by the corresponding values.
- APL database role sap.pa.apl.bases.roles::APL_EXECUTE. This role is required to use APL. To set this role, you must first install APL and then need to run the following script:
```
call _SYS_REPO.GRANT_ACTIVATED_ROLE ('sap.pa.apl.base.roles::APL_EXECUTE','<APL_user>');
```
  where <APL_user> is the user name.
  Note
  
  You can access full information on user privileges, installation and configuration of SAP HANA APL in the SAP HANA Automated Predictive Library Reference Guide.