Execution of project

Now that Jim has frozen the data architecture and best fit data model, he can start the development work. He decides to start with the extraction process. (For this example, we will fetch the data from data warehouse available in Microsoft Access database.)

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:

2. 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 which you want to use to connect to your database. In our case, we choose the drive which...