topic Re: loading data in QlikView

loading data

prabhas277 — Thu, 11 Feb 2016 11:36:03 GMT

Hi experts,

How do you load the data which is updating hourly in your database? and what type of loading is used in above scenarios?

Thanks in advance

Re: loading data

dmac1971 — Thu, 11 Feb 2016 11:39:47 GMT

On your QV server you create your data source to connect to your DB. Then schedule a task on your server to update the report hourly, when server hits the designated time it will connect to the DB through the connection you have created and update all your tables.

Re: loading data

awhitfield — Thu, 11 Feb 2016 11:44:03 GMT

Hi Prabhas,

use a scheduled reload from within QMC

HTH

Andy

Re: loading data

avinashelite — Thu, 11 Feb 2016 11:45:00 GMT

if you have the updated date in your database than INCREMENTAL loading will be the best approach

check this attachment

Re: loading data

Anonymous — Thu, 11 Feb 2016 15:52:24 GMT

When the data is updated that frequently its best to look for updated records and load only those. This reduces application load time. "Incremental load" approach using a .qvd file to compare against and a date column in your DB table does that. QlikView help has a good explanation of incremental load with the 4 scenarios applicable :

QlikView ‒ Using QVD files for incremental load