Setting general connection properties

You can add an IBM DB2 for LUW database to Qlik Replicate to use as a source. For information on how to add endpoints, see Defining and managing endpoints.

To add an IBM DB2 for LUW source endpoint to Qlik Replicate:

1. In the Qlik Replicate console, click Manage Endpoint Connections to open the Manage Endpoint 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, type a description that helps to identify the IBM DB2 for LUW database. This is optional.
4. Select Source as the database role.

5. Select IBM DB2 for LUW 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. Choose one of the following:

   Information note

   When replicating from an IBM DB2 for LUW HADR environment and the task’s Apply Changes replication option is enabled, the endpoint must be configured to read from the primary instance.

   • Use database alias (DSN) - If you choose this option, specify the IBM DB2 for LUW database alias.
   • Use these connection properties - If you choose this option, enter the IBM DB2 for LUW Server (hostname or IP address), Port and Database name in the designated fields.

7. Enter the IBM DB2 for LUW authentication information (User Name, Password) for the authorized user for this IBM DB2 for LUW database. If you do not know this information, see your IBM DB2 for LUW database administrator (DBA).