loading data

[prabhas277]

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

[dmac1971]

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.

[awhitfield]

Hi Prabhas,

use a scheduled reload from within QMC

HTH

Andy

[avinashelite]

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

check this attachment

[Anonymous]

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