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