Prerequisites

The following sections describe the prerequisites necessary for using Microsoft Fabric as a target endpoint in a Replicate task. Note that some of the prerequisites are not relevant or are different when replicating to a mirrored database.

Driver setup

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.

Required permissions

The following section describes which permissions are required when using Microsoft Fabric as a target endpoint in a Replicate task.

Storage permissions

When replicating to a data warehouse:

1. The application specified in the endpoint settings' Staging on Azure section must be granted the “Storage Blob Data Contributor” role. The role should be granted either on the ADLS Gen2 Storage Account or on the specific Container. After the role is granted, it might take a few minutes to take effect.

2. The SAS Token specified in the endpoint settings' Data Loading section must have LIST and READ permissions on the Container.

When replicating to a mirrored database:

• The application specified in the endpoint settings' Staging on Azure section must be granted the Contributor role on the Fabric workspace, to allow it access to OneLake storage.

Database permissions

The Azure Active Directory User/Service Principal specified in the endpoint settings' Fabric Access section must be granted the Contributor role.

Required firewall port

Open port 1433 for outbound communication.

Mirrored database

Before you can use the Mirrored Database option described in the General tab settings, your DBA must create a mirrored database and start its replication.