Skip to main content

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.

Note:

You can also use IBM DB2 for iSeries File Channel files as a source. For more information, see Using the Qlik Replicate file channel.

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

  1. In the Qlik Replicate console, click Add database to open the Add Endpoints 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 iSeries database. This is optional.
  4. Select SOURCE as the database role.
  5. Select IBM DB2 for iSeries as the database Type.

    Note:

    When this endpoint is used as 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:

    • Use database alias (DSN) - If you choose this option, specify the IBM DB2 for iSeries database ODBC DSN.
    • Use these connection properties - If you choose this option, enter the IBM DB2 for iSeries Server (hostname or IP address).
  7. Enter the IBM DB2 for iSeries authentication information (User Name, Password) for the authorized user for this IBM DB2 for iSeries database. If you do not know this information, see your IBM DB2 for iSeries database administrator (DBA).

    Note:

    This information is case sensitive.

    Note:

    Make sure that the specified user has the required access privileges.

  8. In the Journal Name field, enter the name of the journal containing the source tables.

    See also: Change Processing prerequisites.

  9. In the Journal Library field, enter the name of the library where the journal is located.

    See also: Change Processing prerequisites.