Prerequisites
The following sections describe the prerequisites necessary for using Microsoft Fabric Data Warehouse as a target endpoint in a Replicate task.
Driver setup
Install the required driver as described below.
Qlik Replicate for Windows
Install Microsoft ODBC Driver for SQL Server 18.1 on the Qlik Replicate Server machine.
Qlik Replicate for Linux
-
Download Microsoft ODBC Driver 18.1 for Linux from the Microsoft package page.
Example file name: msodbcsql18-18.1.1.1-1.x86_64.rpm
-
Stop the Replicate service:
./areplicate stop
-
Optionally, confirm that the service has stopped:
./areplicate status
-
Install Microsoft ODBC Driver for SQL Server 18.1 on the Replicate machine.
-
Change the working directory to <REPLICATE_INSTALL_DIR>/bin.
-
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.
-
Optionally, confirm that the driver location was copied:
cat site_arep_login.sh
-
Start the Replicate service:
./areplicate start
-
Optionally confirm that the service has started:
./areplicate status
Required permissions
The following section describes which permissions are required when using Microsoft Fabric Data Warehouse as a target endpoint in a Replicate task.
Storage permissions
The user specified in the Microsoft Fabric Data Warehouse endpoint settings must be granted the following ADLS Gen2 storage permissions.
- On the storage container: LIST
- On the storage directory: READ, WRITE and DELETE
- In the Access Control (IAM) settings for the ADLS Gen2 file system, assign the “Storage Blob Data Contributor” role to Replicate (AD App ID). It may take a few minutes for the role to take effect.
Database permissions
The Azure Active Directory User/Service Principal specified in the ODBC Access section of the Microsoft Fabric Data Warehouse endpoint settings must be granted the Contributor role.
Required firewall port
Open port 1433 for outbound communication.