Skip to main content Skip to complementary content

Prerequisites

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

Client

Microsoft SQL Server Native Client must be installed on the Qlik Compose machine.

Permissions

To use Microsoft SQL Server as a Data Warehouse a Qlik Compose project, the Compose user must be granted the following privileges in the Microsoft SQL Server database:

  • The Qlik Compose user must have at least the db_owner user role on the Microsoft SQL Server database.
  • The Qlik Compose user must be granted the CREATE VIEW permission on the Microsoft SQL Server database.
  • A Microsoft SQL Server system administrator must provide this permission for all Qlik Compose users.

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!