Extraction

First thing that Jim needs to do is to create a connection to the database. Microsoft Access database can be accessible to Qlik Sense via an ODBC driver, so he will have to create an ODBC connection to connect to the Access database.

Let us see the steps used by Jim to create an ODBC connection to the data source:

  1. Open the ODBC data source wizard.

You need to go to Control Panel | Administrative Tools | ODBC Data Source (32 Bit).

Once you click on that, the following window will open:

  1. Click on Add to create a new DSN (Deep Space Name). Once you do that, the following window will open:

You will be asked to choose the driver ...

Get Implementing Qlik Sense now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.