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 ...
Get QlikView 11 for Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
