Defining the connection parameters

This section describes how to use an Amazon Redshift database as a data warehouse in a Qlik Compose project.

To define Amazon Redshift 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 Amazon Redshift cluster.
     • Port: Optionally, change the default port.
     • User Name: The user name for accessing the Amazon Redshift database. The specified user must have read/write privileges on the Amazon Redshift database.
     • Password: The password for accessing the Amazon Redshift database.

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

     • Password: The password for accessing the Amazon Redshift database.
     • ODBC Connection String: A string of parameters required to connect to the Amazon Redshift ODBC Driver. After entry, click Test to verify that a connection was established.
     • JDBC Connection String: A string of parameters required to connect to the Amazon Redshift JDBC Driver. After entry, click Test to verify that a connection was established.
     Warning noteYou must include the name of the Amazon Redshift database in the connection string.
   • Warehouse Properties: Specify the following:
     • Database Name: The name of the Amazon Redshift 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.
   • More Options: Click to see or hide the following advanced options:

     • Character column size in bytes: This should be calculated according to the largest value you are likely to store in a VARCHAR column. Tables in the Landing Zone will be divided by the specified value (and rounded up).

       For example, if the value of Character column size in bytes is 3 (the default), both VARCHAR (12 bytes) and VARCHAR (10 bytes) will be discovered as VARCHAR (4 characters).

       See: Use the smallest possible columnsize - Amazon Redshift

       Information note

       If this value is changed, existing tables will not be affected (i.e. the change will only take effect if new columns are added to the model and the data warehouse tables are updated accordingly).

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.