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.)
Execution of project
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:
- Open the ODBC data source wizard.
You need to go to Control Panel | Administrative Tools | ODBC Data Source (32 Bit).
Once you...