Skip to main content

Adding a data warehouse

The data warehouse contains the landing area tables (the target of the Qlik Replicate task), the staging tables, the actual data warehouse tables and the data mart tables.

For more information on the data warehouse structure in an project Qlik Compose for Data Warehouses project, see Qlik Compose for Data Warehouses architecture.

Note that Qlik Compose for Data Warehouses will not let you add data sources before you add a data warehouse. This is because the server connection settings for the source landing area are derived from the data warehouse settings.

For more information on adding data sources, see Setting up Landing Area and Data Source connections.

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

    The Manage Databases dialog box opens.

  2. Click the New toolbar button.

    The New Data Warehouse dialog box opens.

  3. Specify a display name for your database.
  4. From the Type drop-down list, select the desired data warehouse.
  5. Continue from one of the following according to the data warehouse you selected: