Setting Up Live SAP HANA Connectivity

To allow Smart Predict to use live datasets in your on-premise SAP HANA system, you have to complete the following configuration pre-requisites:

  • Configure SAP HANA 2.0 SPS05 revision 51+. For information on installing and configuring SAP HANA, refer to the SAP HANA Master Guide.
  • Create a schema on the SAP HANA system, which will be used by Smart Predict to store predictions and predictive models. This is described in the SAP HANA Developer Guide.
  • Implement these connectivity steps:
    Live connectivity set up step Description Link
    Install the latest version of SAP Automated Predictive Library (APL). The SAP Automated Predictive Library is an Application Function Library (AFL) that exposes automated machine learning capabilities in SAP HANA. The database role sap.pa.apl.base.roles::APL_EXECUTE must be assigned to the SAP HANA technical user to ensure full access to the schema, and execution of functions. Installing the SAP Automated Predictive Library is a pre-requisite. While we recommend that you install the latest version, please note that if you haven't installed the latest version, you should at least have version 2201 or higher. Installing SAP HANA Automated Predictive Library (APL)
    Configure the SAP HANA technical user in your on-premise SAP HANA system. You need to assign
    • READ access on the data used for the training and application of the predictive model, as well as the APL rolesap.pa.apl.base.roles::APL_EXECUTE .
    • WRITE permissions for output tables and for the schema, in which predictive models, debriefing and predictions will be persisted.
    		 Configuring a SAP HANA technical User in the On-Premise SAP HANA System
    Install the Cloud Connector.

    The Cloud Connector is a component available with the SAP Business Technology Platform (BTP). The Cloud Connector is deployed on the on-premise system and allows any TCP connection from the BTP system to tunnel securely through the Transport Layer Security (TLS) to the on-premise system.

    		 Installing the Cloud Connector
    Configure the Cloud Connector. Configure the Cloud Connector to enable SAP Analytics Cloud to connect to the SAP HANA system. Configuring the Cloud Connector
    Add and configure the data repository to SAP Analytics Cloud. The data repository references your on-premise SAP HANA system. Based on the rights granted in each of the previous stages of the live connectivity setup, the SAP HANA technical user can see the schemas to train and apply predictive models. Adding and Configuring the Data Repository in SAP Analytics Cloud
Restriction
You can use Smart Predict on SAP HANA on-premise only. Cloud deployments of SAP HANA are not supported.