Import Data Connection to SAP HANA

How to create a connection that allows you to import models from SAP HANA views.

Prerequisites

You have completed ONE of the following setup options:

  • Performed setup using the SAP Analytics Cloud Agent Simple Deployment Kit. For more information, see SAP Analytics Cloud Agent Simple Deployment Kit.
    Note
    The SAP Java Connector (JCo) must be installed using the instructions in the Post-Setup Guide included in the kit.
  • Performed a manual setup of the following required components:
    1. The Cloud Connector must be installed. For more information, see Installing the Cloud Connector.
    2. The SAP Analytics Cloud agent must be installed. For more information, see Installing SAP Analytics Cloud Agent.
    3. The SAP JCo must be installed. For more information, see Installing the SAP Java Connector (JCo).
    4. The Cloud Connector must be configured. For more information, see Configuring the Cloud Connector.
    5. The SAP Analytics Cloud agent must be configured in SAP Analytics Cloud For more information, see Configuring SAP Analytics Cloud Agent.
    6. (Optional) For TLS security options, the JVM instance that is used to run the SAP Analytics Cloud agent (Tomcat) should be registered with keystore. Some things to consider:
      • Tomcat is not required to be secured with the same SSL certificate used to import data, nor does it require HTTPS.
      • SSL Certificates pointing to multiple DNS locations need to be further secured by having the certificate imported to the local SAP Analytics Cloud agent JVM keystore.

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 Acquire Data and select SAP HANA.
  3. In the New SAP HANA Connection dialog, enter the following information:
    1. In the Connection Information section, add a Connection Name and Description.
    2. In the Data Source Configuration section, select the Location of your Cloud Connector from the list.
    3. Enter the Host name.
    4. Choose a TLS security option.

      A TLS certificate is a digital certificate that authenticates the identity of a website. It is highly recommended that the TLS certificate be signed by a trusted certificate authority.

      TLS Option Description
      None Communication with the SAP HANA database is not encrypted.
      Self-signed certificate All communication with the SAP HANA database is encrypted. However, this option is less secure than the certificate authority option.
      Signed by a certificate authority This is the recommended option for best security.

      All communication with the SAP HANA database is encrypted. Also, the certificate is checked to verify whether it is signed by a trusted certificate authority, and if it isn't, the connection isn't established.

      If you choose this option, you can then enter a different host name if you want to override the host name in the certificate.
    5. Enter the Instance Number.
    6. Choose Single Container or Multiple Container.
    7. Enter the User Name and Password for your SAP HANA system.
      Note
      If you want to share the credential details, select the option Share these credentials when sharing this connection. Otherwise, users will need to enter their own credentials in order to use the connection. If you don't share your credentials, users will be able to edit their credentials at any time without having to start a data acquisition process.
  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
Related Information