Install the required client

Install the required driver as described below.

Qlik Replicate for Windows

Install Microsoft ODBC Driver for SQL Server 18.5 on the Qlik Replicate Server machine.

Qlik Replicate for Linux

1. Download Microsoft ODBC Driver 18.5 for Linux from the Microsoft package page.

   Example file name: msodbcsql18-18.5.1.1-1.x86_64.rpm

2. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

3. Install Microsoft ODBC Driver for SQL Server 18.5 on the Replicate machine.

4. Change the working directory to <REPLICATE_INSTALL_DIR>/bin.

5. Copy the driver location to the site_arep_login.sh file as follows:

   echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql<version>/lib64/" >> site_arep_login.sh

   Example:

   echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql18/lib64/" >> 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.

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

   cat site_arep_login.sh

7. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.