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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?