Re: Using online query in Qliksense - Qlik Community

onkarkulkarni · ‎2018-08-06

Hi Folks,

I am working on a requirement to update dashboard as and when there is any change in backend DB table. earlier I had scheduled dashboard refresh on hourly basis. However business wants the dashboard to reflect the changes at the very moment.

Is there any mechanism/function which I can use?

Note : My backend DB is Oracle.

Regards,

Onkar Kulkarni

agigliotti · ‎2018-08-06

I suggest you to take a look at direct discovery feature, at https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/DirectDiscovery/access-large-data-...

I hope it can helps.

petter · ‎2018-08-06

There are essentially three mechanisms you can employ - but all three needs the user to press a "button" or do a query/selection to get anything updated - but the updated data will be as-of the query performed:

1) Qlik Direct Discovery as Andrea G mentioned above

2) On Demand App generation (ODAG)

3) Advanced Analytics Integration AAI using SSE (Server Side Extensions) using one of several "middleware" tools like for instance Python. With Python as middleware you can query directly to Oracle via Python Oracle Drivers and get the results immediately visualized using SSE in the UI.

balabhaskarqlik · ‎2018-08-06

You can make all these setting in QMC, create a trigger that updates your data on every 3 minutes.

OR

Using Mash ups:

you could also use an HTML page with this :

<head>

</head>

it refresh document every 30 seconds.