Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content
Qlik Resources

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.3 on the Qlik Replicate Server machine.

Qlik Replicate for Linux

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

    Example file name: msodbcsql18-18.3.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.3 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.

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.

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!

Leave your feedback here