topic Re: DataBase Doudt in QlikView

DataBase Doudt

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

Hi,

I am using Oracle data base tables as a source to my qlikview application. As qlikview is inbuilt memory the data stored in RAM. When we refresh the report, report fetches the data from data source or RAM data. When database is updated on daily basis is RAM data also resembles the same data?.

Please suggest.

Thanks.

Re: DataBase Doudt

HirisH_V7 — Mon, 02 Jan 2017 08:53:17 GMT

Hi,

Qlikview will fetch the data only when a reload happens i.e is at that point of time only , it will get connected to database and fetch the data and keep it in-Memory.

And Its not possible to load data when source data get changed, but you can schedule data reloading on time base, like every data, every hour. and so on.

-Hirish

Re: DataBase Doudt

Anonymous — Mon, 02 Jan 2017 10:21:15 GMT

Hi, QlikView only fetch data from datasource when the document is reloading. If you wanna reload data when data has changed you have to use EDX.

Regards!

Re: DataBase Doudt

PrashantSangle — Mon, 02 Jan 2017 10:27:04 GMT

Hi,

Have you read about 2 tier and 3 tier architecture?????

read blog regarding 2 tier and 3 tier architecture in qlikview.

search on community for that architecture.

Regards