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:

  1. Connecting to the database
  2. Querying the database
  3. 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 live online training, plus books, videos, and digital content from nearly 200 publishers.