Prerequisites
Make sure that the following prerequisites have been met:
Qlik Replicate for Windows
Install Microsoft ODBC Driver 18.3 for Windows on the Qlik Replicate Server machine.
Qlik Replicate for Linux
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.
Install Microsoft ODBC Driver 18.3 for Linux on the Replicate machine.
Then, open a Unix shell and do the following:
-
Change the working directory to <Replicate-Install-Dir>/bin.
-
Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
-
Copy the driver location to the
site_arep_login.sh
file as follows: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.
-
Optionally, confirm that the driver location was copied:
cat site_arep_login.sh
-
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.
-
Replicate requires the following ODBC library: libmsodbcsql-18.3.so.1.1
To check which library version is currently installed Issue the following command:
ls /opt/microsoft/msodbcsql/lib64/
If the existing library has a different version number (e.g.
libmsodbcsql-18.0.so.1.1
), you need to create a symbolic link between the existing library and the required library.To do this, issue the following commands:
cd /opt/microsoft/msodbcsql18/lib64/
ln -s existing_library_name libmsodbcsql-18.3.so.1.1
where
existing_library_name
is the name of the currently installed library (e.g.libmsodbcsql-
).18.0.so.1.1
Other prerequisites
-
Ports:
- When Replicate Server runs on a machine outside Azure - Open port 1433 for outbound traffic.
-
When Replicate Server runs on an AzureVM - Open the following ports for outbound traffic:
- 1433
- 11000-11999
- 14000-14999
- A Microsoft Azure SQL Database account with the specific access privileges is required. See Target Permissions for more information.