Data Reloading

[agni_gold]

I have some doubts regarding qlikview Application:

If i have a QVW file with data loading and some more functionality . I want , if any data changes in the source table or file then , can it reload automatically? if yes then how it is possible?

Something like trigger.

[Anonymous]

You can only schedule the reload processes for varying time, but

it cannot reload automatically whenever there is change in Datasource, this would be a real time system and it would create a great impact on performance of live system(transactional system).

Resolution, why not you reaload your application on hourly of half hourly basis.??

Regards

Nitin

[israrkhan]

Hi,

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.

Secondly, you said change in database fields, but they changed the fields name, then use the * keyword, instead of mentioning field name in the load script.

[#4]

In QlikView Server there is a component called Publisher. This component exposes an API called EDX which you can use from external processes to launch Publisher tasks like reloading a document. You could use a trigger in your data source system to launch a QlikView reload task.

More information about EDX here (http://community.qlik.com/docs/DOC-2650) or in the SDK (http://community.qlik.com/docs/DOC-2639).

[suresh_rawat]

Hi Agnivesh,

In QlikView you can only schedule your reload in QlikView Access Point.

And that depends how quickly your data updating in your system.

You can schedule your reload accordingly - for half-hourly, hourly, daily, monthly.....

Regards

Suresh Rawat

[#6]

Hi,

As suggested by everyone, you can schedule the file.

I had a similar scenario with a slight variation. I had a field called "load_progress" whose value if greater than 20 then it would mean that the data in the source tables have refreshed and have changes, so I scheduled the file reload on this condition.

So, if you have a field whose values can indicate whether the source tables have reloaded or not, then you can schedule the reload of the file based on the value of that field.

Hope this helps!

[agni_gold]

Thanks Israr,

So can we schedule this loading on client side ? if yes then how ?

[brijesh1991]

EDX trigger is working fine in my case.

You can use it without hesitation, but make sure it won't affect your performance i.e how frequently data is changing

[agni_gold]

So can we schedule this loading on client side ? if yes then how ?