Lesson 7 – Exercises


In this lesson you are going to repeat all you learned on your own with your acquired skills and techniques.

Task 1 – Dataloader Adventure Works

  1. Create a dataloader with a connetion to the acces file – AdventureWorksSample which can be found in “Admin/Common/Libs/QVComponents/Examples/DbExtract”
  2. Qualify the datas and save them into the DataStaging (work with variables)

Screenshot 2015-03-28 15.10.09


Include the data source as an ODBC system source.

Screenshot 2015-03-28 15.31.09

Screenshot 2015-03-28 15.32.59

If you are using a 64Bit system it is important to activate the “Force32Bit” option when working with 32Bit data sources. (MS Access is 32 Bit)

Your script for this first task should look something like this:

If you execute the script and set all settings correctly, then the table “Product” should appear in your DEV/02 DATASTAGING – index.

Task 2 – Integration of a webdata source

There are numerous datasources on the internet, most of which can easily be integrated into QlikView. An interesting website to look around a bit is: http://www.programmableweb.com – REST – API’s are the easiest to integrate, because they are already collecting data after a single URL-request. We are going to get some weather-informations from www.data.gv.at .

Our landig point is described here in detail: http://at-wetter.tk/index.php?men=api

In the end the script should start like task 1 and the loading rider like the following:

Screenshot 2015-03-28 17.13.22

 Task 3 – Load the weatherdata of all days of the month 03

Autonomous working- 15 min time.