# 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](https://packages.microsoft.com/rhel/8/prod/Packages/m).

   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](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

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](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

## 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.