Setting general connection properties

You can add a SAP HANA endpoint to Qlik Replicate to use as a source. For more information on how to add endpoints, see Defining and managing endpoints.

To add a SAP HANA source endpoint to Qlik Replicate:

1. In the Qlik Replicate console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, optionally enter a description that helps to identify the SAP HANA database.

4. Select Source 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.

5. Select SAP HANA as the database Type.

   Information note

   When this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream check box and then select the relevant Log Stream Staging task from the drop-down list.

   For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.

6. 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

7. In the Instance number field, enter the instance number of the SAP HANA database with the source tables.

8. Select either Single tenant or Multi tenant according to your Database architecture. If you selected Multi tenant, enter the source Database name.

9. 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 note

     This information is case sensitive.

10. To connect to SAP HANA using SSL, in the Security section, do the following:

    1. Select the Enable SSL check box.

    2. In the Crypto provider field, select your cryptographic library provider from the drop-down list.

    3. In the Keystore file field, enter the file path to the SSL Keystore file that contains the client identity.

    4. In the Truststore file field, enter the file path to your SSL Truststore file that contains the server’s public certificates.

    5. 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.

    6. In the Server name indication field, enter the name of the SSL server.

    7. To validate your SSL certificate, select the Validate certificate check box. This step is optional, but strongly recommended for security reasons.

    Information noteTo connect to SAP HANA using SSL, the client must be configured to authenticate the SSL server certificate. For more information, see Prerequisites.
11. Click Test Connection to verify that the specified settings are correct.