Skip to main content
Qlik Resources

Defining the connection parameters

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

To define Oracle 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.

  1. 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 Oracle server machine.
      • Port: If you specified a TNS name in the Server Name field, make sure this field is empty. Optionally, change the default port.
      • User Name: The user name for accessing the Oracle database. The specified user must have read/write privileges on the Oracle database.
      • Password: The password for accessing the Oracle database.
      • SID: If you specified a TNS name in the Server Name field, make sure this field is empty. Optionally, specify the Oracle SID.

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

      • Password: The password for accessing the Oracle database.
      • ODBC Connection String: The string of parameters required to connect to the Oracle ODBC Driver.
      • JDBC Connection String: The string of parameters required to connect to the Oracle JDBC Driver.
        • Warning noteCompose will concatenate the database name to the ODBC/JDBC connection string.
    • Warehouse Properties: Specify the following:
      • 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.
      • Maximum length of identifier names is 128: Select this check box to limit the length of Oracle dimension table identifier names to 128 characters. This should match your Oracle configuration. This option is available for Oracle versions starting from 12.2.
  2. Click Test Connection to verify that Compose is able to establish a connection with the specified data warehouse.

  3. Click OK to save your settings.

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

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!

Leave your feedback here