Skip to main content Skip to complementary content

Prerequisites

Before you can use Microsoft Azure Synapse Analytics as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Install the Required Client

Install SQL Server Native Client 11 (for connecting to Microsoft Azure Synapse Analytics) on the Compose machine.

Permissions

The user specified in the Microsoft Azure Synapse Analytics connection settings must be granted the following permissions.

The Compose must be granted the db_owner user role on the specified target database.

The Compose must be granted SELECT access (by adding the user to the master database and then to the db_readers role, for example).

Open the Required Firewall Port(s)

  • When Compose runs on a machine outside Azure - Open port 1433 for outbound traffic.
  • When Compose runs on an AzureVM - Open the following ports for outbound traffic:
    • 1433
    • 11000-11999
    • 14000-14999

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!