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.