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.
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