Setting general connection properties
This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.
To add a SAP HANA target endpoint to Qlik Replicate:
- In the Qlik Replicate console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box.
- In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
- In the Description field, optionally enter a description that helps to identify the SAP HANA database.
-
Select Target as the database role.
You can do this step before any of the other steps if you want, however before you can continue with the next step in this process, you must select the database role.
- Select SAP HANA as the database Type.
-
In the Server field, specify the IP address or host name of the SAP HANA database server.
To connect to a High Availability Cluster, specify all of the cluster nodes and port numbers in the Server field. The nodes should be separated by a comma.
Example:
12.12.1.123:3033,12.12.1.124:3034
-
In the Instance field, enter the instance number of the target SAP HANA database.
-
Select either Single tenant or Multi tenant according to your Database architecture. If you selected Multi tenant, enter the target Database name.
Information noteThe Multi tenant option is supported from Replicate May 2022 Service Release 02 only. -
Enter the Username and Password required to access the SAP HANA database. If you do not know this information, see your SAP HANA database administrator (DBA).
Information noteThis information is case sensitive.
-
To connect to SAP HANA using SSL, do the following:
Information noteTo connect to SAP HANA using SSL, the client must be configured to authenticate the SSL server certificate. For more information, see SSL prerequisites.-
Select the Enable SSL check box.
-
In the Crypto provider field, select your cryptographic library provider from the drop-down list.
-
In the Keystore file field, enter the file path to the SSL Keystore file that contains the client identity.
-
In the Truststore file field, enter the file path to your SSL Truststore file that contains the server’s public certificates.
-
In the Server host name in certificate field, enter the name of the server host specified in the server certificate. This verifies the identity of the server, rather than the host name with which the connection was established. If you specify * as the host name, the server host name is not validated.
-
In the Server name indication field, enter the name of the SSL server.
-
To validate your SSL certificate, select the Validate certificate check box. This step is optional, but strongly recommended for optimal security.
-
- Click Test Connection to verify that the specified settings are correct.