Defining the connection parameters

This section describes how to use a Microsoft SQL Server database as a data warehouse in a Qlik Compose project. You can also use the Microsoft SQL Server data warehouse settings to specify connection details to a Microsoft Azure SQL Database.

To define Microsoft SQL Server as a data warehouse:

1. Open your project and click Manage in the bottom left of the Databases panel.

   The Manage Databases window opens.

2. Click the New toolbar button or click the Add new database link in the middle of the window.

   The New Data Warehouse dialog box opens.

3. From the Type drop-down list, select the desired data warehouse.

4. Enter the information as described below.

   • Connection input mode: Select Standard or Advanced.

     If you selected Standard connection input mode, specify the following:

     • Server Name: The name or IP address of the Microsoft SQL Server server machine.

     • Port: Optionally, change the default port.

       When connecting to a named instance using the instance name, either change the port to 0 to use the SQL Server Browser service to redirect.

     • Windows authentication / SQL Server authentication: Choose how you want Compose to log in to the Microsoft SQL Server database. If you choose Windows authentication, see Working with Windows Authentication below.
     • User Name: The user name for accessing the Microsoft SQL Server database. The specified user must have read/write privileges on the Microsoft SQL Server database.
     • Password: The password for accessing the Microsoft SQL Server database.

     If you selected Advanced connection input mode, specify the following:

     • Password: The password for accessing the Microsoft SQL Server database.
     • ODBC Connection String: The string of parameters required to connect to the Microsoft SQL Server ODBC Driver.
     • JDBC Connection String: The string of parameters required to connect to the Microsoft SQL Server JDBC Driver.
     Warning noteCompose will concatenate the database name to the ODBC/JDBC connection string.
   • Warehouse Properties: Specify the following:
     • Database Name: The name of the Microsoft SQL Server database.
     • Data Warehouse Schema: The schema in which to create the data warehouse tables.
     • Data Mart Schema: The schema in which to create the data mart.
5. Click Test Connection to verify that Compose is able to establish a connection with the specified data warehouse.

6. Click OK to save your settings.

   The database is added to the list on the left side of the Manage Databases window.

Working with Windows authentication

You can configure Qlik Compose for Data Warehouses to log in to Microsoft SQL Server using Windows authentication.

If you choose this option, you also need to make sure that:

• The Microsoft SQL Server instance is set up to allow Windows log on.

• The Qlik Compose for Data Warehouses user is specified as the "Log on as" user for the Qlik Compose for Data Warehouses service account.

  -OR-

• Microsoft SQL Server is configured to allow login for the Qlik Compose for Data Warehouses service account.