topic Re: What is Real-Time Data Update? in QlikView

What is Real-Time Data Update?

Wed, 07 Nov 2012 12:37:57 GMT

Hi All,

Please tell me breifly about Real time Data Update.

Thanks in advance.

My thought is---> Real time Data Update----> If Source(Database,xml,text) have any new record and updated records then that will reflect to the Qvw file without reloading.

Is this correct or not?

Regards,

Kabilan K.

Re: What is Real-Time Data Update?

Wed, 07 Nov 2012 13:43:10 GMT

Hi,

You got it right.

If any records are added/updated in the source database, the change is instantly (as-it-happens) reflected on the other end (in this case, the QVW).

This feature was introduced in QlikView 11 under the name 'Dynamic Update'. This would avoid the hassle of reloading the document as changes will be reflected in real-time.

You can presumably find more information about this in the QlikView Manual or QlikView Help.

Hope that helps.

Regards,

-Khaled.

Re: What is Real-Time Data Update?

Fri, 09 Nov 2012 09:00:42 GMT

Hi Khaled,

Could You Please explain Briefly with Examples?

If we want to see the updated/new data in a QVW Document, Means is need to host that application?

Regards,

Kabilan K.

Re: What is Real-Time Data Update?

jagan — Fri, 09 Nov 2012 11:59:14 GMT

Hi Kabil,

I never heard about Real time Data Update, how qlikview knows when there is a change of data in source?

I am not sure about Real Time Data Update, but in QV 11.2 there is a concept called Direct Discovery, which fetches the data from source when the data is required for report. So that you always have the latest data for your report.

But in this there is a disadvantage it always hits the database for data, this may lead to performance issues.

http://www.qlik.com/us/company/press-room/press-releases/2012/en/1016-qlikview-direct-discovery-launched-for-rapid-visual-analysis

Hope this helps you.

Regards,

Jagan.

Re: What is Real-Time Data Update?

Mon, 19 Nov 2012 06:28:11 GMT

Hi Khaled,

How will we do this(Real time update)?

Please give some idea on this.

Thanks in Advance

Regards,

Kabilan K.

Re: What is Real-Time Data Update?

Anonymous — Mon, 19 Nov 2012 06:37:51 GMT

Kabilan,

You can search the forums for some examples.

However, like Jagan is suggesting, I would recommend holding off until the release of v 11.2 and explore the possibility of using Direct Discovery for close to real time requirements.

Re: What is Real-Time Data Update?

Mon, 19 Nov 2012 07:13:54 GMT

Hi,

I haven't had a chance to work on this yet, but yes like Johannes suggested, you can look up to the forums for some help or you can probably try waiting until Direct Discovery is released as Jagan advises.

For a starter, these posts might help you. There is also an example document i found on the community.

http://community.qlik.com/thread/45050

http://community.qlik.com/docs/DOC-1852

http://community.qlik.com/message/245363#245363

PFA...Hope that helps.

Regards,

-Khaled.