Skip to main content Skip to complementary content

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

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com