-
Book Overview & Buying
-
Table Of Contents
QlikView for Developers
By :
In this section, we will go through the steps required to extract data into a QlikView document. The extraction process through which we pull data into the QlikView document consists of:
Connecting to the database
Querying the database
Reloading the QlikView script
We will provide two examples of data extraction using two different data sources:
A Microsoft Access database
A table file
Our first example will demonstrate how to extract data from an MS Access database. It will be a good example since the connection process is very similar to that used when connecting to most major DBMSs. We will be using one of the drivers discussed in the previous section, and covering the steps required in the entire process.
Before continuing, make sure a database file named Dimension Tables.mdb is there in the Data Files\MDBs folder. If not, proceed to create the folder, if necessary, and copy the file.
Drivers for MS...