Skip to main content Skip to complementary content

Defining the connection parameters

You can add a Microsoft SQL Server database to Qlik Compose to use as a source. You can also use the Microsoft SQL Server source to specify connection details to a Microsoft Azure SQL Database.

When using Microsoft Azure SQL Database as the data warehouse, the data warehouse database must be the same as the database that you will later define for the landing zone, although it should use a different schema.

  1. In the New Data Source window, enter the information as described in the table below.

    Data source fields

    Field

    Description

    Type

    Select Microsoft SQL Server.

    Server Name

    Specify the name or IP address of the Microsoft SQL Server machine.

    Port

    Optionally, change the default port.

    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

    Specify your user name for accessing the Microsoft SQL Server database.

    The specified user must have read/write privileges on the Microsoft SQL Server database.

    Password

    Specify your password for accessing the Microsoft SQL Server database.

    Database Name

    Specify the name of the Microsoft SQL Server database.

    Schema

    Specify the schema containing the source tables.

  2. Click Test Connection to verify that Compose is able to establish a connection with the specified database and/or landing zone.
  3. 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.

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!