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.
- Click Test Connection to verify that the specified settings are correct.