Prerequisites

Before you begin to work with an IBM Informix database as a source in Qlik Replicate, make sure that the following prerequisites have been met:

• Qlik Replicate machine:

  • Qlik Replicate installed in your network.
  • IBM Informix ODBC Driver (64-bit) version 3.70 or later must be installed on the computer where Qlik Replicate is located.
  • The DB_LOCALE=<Informix_db_locale_value> environment variable must be set to be the name of the IBM Informix database locale from which you want to capture data.
  • The INFORMIXSQLHOSTS environment variable must be set to include the names of the IBM Informix servers that are available for use as Replicate source endpoints.

• IBM Informix Server:

  • An IBM Informix account with the required Required permissions.

  • CDC enabled. To enable CDC, run the script $INFORMIXDIR/etc/syscdcv1.sql on the IBM Informix server.

    Information note

    This requires DBA privileges (User 'IBM Informix' or another DBA user).

  • Make sure that the database to be replicated was created with either the WITH LOG or the WITH BUFFERED LOG property.