Skip to main content Skip to complementary content

Prerequisites

This topic describes the client prerequisites when replicating to a Microsoft Azure Database for PostgreSQL target.

Qlik Replicate Server for Windows

  • The PostgreSQL ODBC Driver: PostgreSQL ODBC Driver psqlodbc_13_01_0000-x64 or above must be installed on the Qlik Replicate machine.

  • PgAdmin:

    1. Download and install pgAdmin 4 (Windows) on the Qlik Replicate machine.
    2. Add the "psql.exe" path to the system PATH.
  • Microsoft Visual Studio 2013 Redistributable (x86) - not (x64) - must be installed on the Qlik Replicate machine.

Qlik Replicate Server for Linux

Download PostgreSQL 13 ODBC driver, and client programs and libraries.

  • Example PostgreSQL ODBC file name: postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm
  • PostgreSQL client programs and libraries file name: postgresql13-13.8-1PGDG.rhel<version>.x86_64.rpm

Then, open a shell prompt and do the following:

  1. Stop the Replicate service:

    ./areplicate stop
  2. Optionally, confirm that the service has stopped:

    ./areplicate status
  3. Install PostgreSQL 13 client programs and libraries.

  4. Install the ODBC driver for PostgreSQL 13.

  5. Change the working directory to <Replicate-Install-Dir>/bin.

  6. Copy the driver location to the site_arep_login.sh file:

    echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-13/lib" >> site_arep_login.sh

    This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.

  7. Optionally, confirm that the driver location was copied:

    cat site_arep_login.sh
  8. Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:

    [PostgreSQL Unicode(x64)]

    Description = PostgreSQL ODBC driver

    Driver = /usr/pgsql-13/lib/psqlodbc.so

    Setup = /usr/pgsql-13/lib/psqlodbcw.so

    UsageCount = 1

  9. Start the Replicate service:

    ./areplicate start
  10. Optionally, confirm that the service has started:

    ./areplicate status

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!