Connect QlikView Desktop to Oracle

QlikView is a powerful business intelligence tool that enables users to create interactive and dynamic dashboards, reports, and visualizations. With QlikView, users can analyze data from various sources, uncover insights, and make data-driven decisions. You can use an ODBC driver to connect and import Oracle data into QlikView Desktop.

Note

You need to have a configured Data Source Name (DSN). For instructions, see Configure a Windows DSN for Oracle.

To import Oracle data:

1. In QlikView Desktop, select File > New.

The Start page with the expanded File menu

2. Close the Getting Started wizard, then select File > Edit Script.

A new sheet with the expanded File menu

The Edit Script dialog opens.

3. On the Data tab, under Database, select ODBC.

4. Click Connect.

The Edit Script dialog with the selected ODBC option in the Database field

The Connect to Data Source dialog opens.

5. In the User ID and Password fields, enter your Oracle credentials.

6. Under Data Sources, select your DSN.

Tip

If you have a user DSN, select Show User DSNs. The available user DSNs will appear under Data Sources.

The Connect to Data Source dialog with a selected DSN and entered credentials

7. Optional: Click Test Connection to verify the connection settings.

8. Click OK to save the settings.

9. Specify a SQL query using one of the following ways:

  • In the Main pane, enter your query under the pre-generated statements.

  • Construct a query:

    1. On the Data tab, click Select.

    2. In the Create Select Statement dialog, under Database Tables, select a table.

    3. Under Fields, select the fields you want to add to the query.

    4. Optional: To include fields from more tables, repeat the steps for each table: click Add, select a table and fields, then click Add.

    The constructed SQL query appears on the Script tab.

    5. After adding all required fields, click OK.

    The constructed SQL query appears under the pre-generated statements.

The Create Select Statement dialog with selected tables and fields

10. Click Reload to run the script.

The Edit Script dialog with a SELECT statement

If prompted to save the document, click OK and specify the save path on your computer.

The pop-up window prompting to save the document

After the script is run, the Sheet Properties dialog opens, and the data from the selected tables is loaded into QlikView memory.

11. Select the fields to display in list boxes.

12. Click Add, then click OK.

The Sheet Properties dialog with selected fields to be displayed as list boxes

The data appears in list boxes on the sheet.

A sheet with fields from Oracle displayed as list boxes