Import Data Connection to SAP HANA
How to create a connection that allows you to import models from SAP HANA views.
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.NoteThe 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:
- The Cloud Connector must be installed. For more information, see Installing the Cloud Connector.
- The SAP Analytics Cloud agent must be installed. For more information, see Installing SAP Analytics Cloud Agent.
- The SAP JCo must be installed. For more information, see Installing the SAP Java Connector (JCo).
- The Cloud Connector must be configured. For more information, see Configuring the Cloud Connector.
- The SAP Analytics Cloud agent must be configured in SAP Analytics Cloud For more information, see Configuring SAP Analytics Cloud Agent.
(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.
From the side navigation, choose
.The Select a data source dialog will appear.
- Expand Acquire Data and select SAP HANA.
In the New SAP HANA Connection dialog, enter the following
- In the Connection Information section, add a Connection Name and Description.
- In the Data Source Configuration section, select the Location of your Cloud Connector from the list.
- Enter the Host name.
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.
- Enter the Instance Number.
- Choose Single Container or Multiple Container.
Enter the User Name and Password for your
SAP HANA system.
NoteIf 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.
The new connection is added to the list of connections on the Connections screen.