Extracting data – two hands-on examples

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

Extracting data from MS Access

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.

Note

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.

Configuring the driver

Drivers for MS...