Loading data from databases

Data from commercial database systems is loaded into QlikView via the Microsoft OLE DB/ ODBC interface. To do so, you must install a driver to support your DBMS and you must configure the database as ODBC data source.

When this is done, you can set up a connection to the database in the Edit Script dialog by clicking the Connect button. This generates a Connect statement in the script.

After that, you define the fields and tables to be loaded in a Select statement. To create this statement, click the Select button.

Create Select Statement

You can also define the fields and tables to be loaded with a Direct Query statement.

You can also load aggregated query results from large datasets without loading them into the QlikView data model, using the Direct Discovery function.

Direct Discovery