Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

flavio_fazzano
Not applicable

Real-time data update in QvS

Someone know how QVS realizes the Real-time data update ?
I have a couple questions:
1) If a new data was inserted into a DB Oracle, how is QVS notified?, and then, how is the process to add this new data in a qv document?
2) When does QVS download to disc the information that were "injected" into memory?

I am apology if I am not very clear, but I don't understand very well this features

Regards,

Flavio

6 Replies
Not applicable

Real-time data update in QvS

As far as adding the process of new data to qv doc is concerned, you would have to apply "Reload" and "Partial Reload" functionality to the script.

Regards

Eraaj

stephen-a_redmo
Not applicable

Real-time data update in QvS

Hi Flavio,

Insertion on QVS is via API and requires a license.

To get new data like this from Oracle, you would have to write a trigger in Oracle to insert the new rows via the API. Be warned that there are limits on teh number of rows that can be inserted per second has the document will need to recalculate.

Regards,

Stephen

flavio_fazzano
Not applicable

Real-time data update in QvS

Ok Stephen, thanks, but now let's suppose that a new information was inserted into qv document (sales.qvw) ,how this new data is stored in the Sales.qvw ?

stephen-a_redmo
Not applicable

Real-time data update in QvS

Hi Flavio,

You would use a Macro. I imagine that you are talking about a user being able to enter values in fields and then inserting them into the data?

Have a look at this document: http://community.qlik.com/media/p/66961.aspx

Stephen

flavio_fazzano
Not applicable

Real-time data update in QvS

Thanks again Stephen, but when the qv document is download from memory, the information that was injected (in run time) is lost, and my question is how this information can be save

Best regards,

Flavio

stephen-a_redmo
Not applicable

Real-time data update in QvS

Hi Flavio,

You need to make sure that the additional data is handled by your script.

Regards,

Stephen