Make sure that the following prerequisites have been met:
Qlik Replicate for Windows
Install Microsoft ODBC Driver 17.6 for Windows on the Qlik Replicate Server machine.
Qlik Replicate for Linux
Install Microsoft ODBC Driver 17.6 for Linux on the Qlik Replicate Server machine.
Then, on the Qlik Replicate Server machine, open a Unix shell and perform the following steps:
The procedure below assumes that you have installed a single default instance of Replicate on Linux (areplicate). If you have installed multiple instances, replace areplicate with the name of the instance running the task with a Microsoft SQL Server source. If several instances are running such as task, the procedure needs to be repeated for each instance.
Change the working directory to:
Stop the Replicate service:
Optionally, confirm that the service has stopped:
Copy the driver location to the
site_arep_login.shfile as follows:
echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql17/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.
Optionally, confirm that the driver location was copied:
Start the Replicate instance:
Optionally confirm that the instance has started:
Replicate requires the following ODBC library: libmsodbcsql-17.6.so.1.1
To check which library version is currently installed Issue the following command:
If the existing library has a different version number (e.g.
libmsodbcsql-17.6.so.0.2), you need to create a symbolic link between the existing library and the required library.
To do this, issue the following commands:
ln -s existing_library_name libmsodbcsql-17.6.so.1.1
existing_library_nameis the name of the currently installed library (e.g.
- A Microsoft SQL Server account with the specific access privileges is required. See Source Permissions for more information.
- Microsoft SQL Server as a source must be configured for a full backup to work with Qlik Replicate. For more information, see Preparing Microsoft SQL Server backup and recovery.
- When decompressing a compressed backup transaction log, Replicate writes the decompressed log to the same location as the compressed log. Consequently, the location of the compressed backup transaction log must have enough space to contain the decompressed log as well.
If your environment matches the following:
- Microsoft SQL Server versions 2012 or 2014
- Microsoft ODBC Driver 17 installed on Red Hat 8.1
Then, in order to work with TLS 1.2, you must install a specific Service Pack on the Windows machine where Microsoft SQL Server is installed.
For more information, see the following Microsoft article.