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:

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.