topic sql data automatically refresh in QlikView

sql data automatically refresh

riishabhz — Wed, 25 Nov 2020 16:16:04 GMT

hello every one.

my question is that now i have connected my sql in to qlikview and tables in sql are updated every day and have so much of information in them. is there a way to automatically refresh the sql table because manually when i do it starts from 2013/01/01 to current date and its very time cosuming as it takes around 1hr to load just for one day sql data .

hope i am clear about my question.

ps my data is in sql and i have connected already to qlikview.

Re: sql data automatically refresh

gf — Mon, 08 Jul 2019 06:38:55 GMT

If your project runs on a server, it should be no problem. Just reload it every day at 11 pm or maybe 5 am.

Re: sql data automatically refresh

Vegar — Mon, 08 Jul 2019 06:51:53 GMT

It can be really time and resource consuming to load the whole database every time, you could look into the concept of incremental load. A setup where you only fetch the new and updated dataset from the database and store all historic data in a QVD layer.

You may choose to fetch the updated data on a daily, hourly or whatever frequency you like (or your system can handle)

From Qlik help page: Using QVD files for incremental load

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/QVD_Incremental.htm