Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jaisaiqlik
New Contributor

Data Refreash

The Database Which I connected with my Qlik Sense. That database gets refreshed every week so here my question is how should i refresh the data in Qlik Sense automatically 


For manually reload it taking 9 hours


So client want to get data refreshed automatically in Qlik sense as well every week when ever the database gets refreshed?

5 Replies
mark6505
Valued Contributor III

Re: Data Refreash

Hi Jay,

You will need to have a QlikSense server to schedule the reload and you will need to look at Incremental loads for your data, so you are only getting newer data on reload.

Mark

jaisaiqlik
New Contributor

Re: Data Refreash

On what field I have to do with incremental and also you said Qlik Sense Server reload schedule. 


What is that can you brief it please you mean we can schedule the automatic jobs in Qlik Sense Server?


mark6505
Valued Contributor III

Re: Data Refreash

Hi Jay,

The normal approach would be a date field, but if it is transactions you could use the transaction number.

First you would load all the data you have then store to QVD.

Once you have your qvd, you update your loader, so it pick up your max date.

then load from source where greater than your max date.

The store back to qvd.

There is lots on here about the sense server if you have a look around, but yes it allows you schedule your reloads and much more.

jaisaiqlik
New Contributor

Re: Data Refreash

Thanks Mark

mithilesh17
Contributor

Re: Data Refreash

Hi Jay,

If you have data of several years, one approach would be freeze the old data which not gets updated and store it in qvd say data till 31st Dec, 2016 (one time activity)

and reload only current year data ( i.e for 2017 year data)

In the app, concatenate both qvds. It will save your valuable time.

Regards,