topic Re: How to use QV as a in-memory data source ? in QlikView

How to use QV as a in-memory data source ?

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

Hello!

In my company we already use QV as a in-memory report tool which keeps stocks. Stocks are in in-memory.

I have another IT system which should get data from QV very quickly.

My questions is:

1) is it possible ?

2) if yes then how to implement it - can I read data directly from in-memory or from QV file ?

Picture below shows two Options:

Option-1 - read data quickly from in-memory

Option-2 - read data slowly (???) from QV file.

Please help.

BR, Alex.

Re: How to use QV as a in-memory data source ?

tresB — Wed, 19 Dec 2018 08:51:32 GMT

...another IT system ...

Is it also qlik environment? If not, I guess it would not be possible to utilize 'in-memory'/ read-from-qv file.

Re: How to use QV as a in-memory data source ?

marcus_sommer — Wed, 19 Dec 2018 13:44:46 GMT

Qlik has a very specific data-structure so that your IT system would need to be capable to address it in the same way like the Qlik engine does to access the in-memory data. Therefore I doubt that there is a real way especially not only by considering the technically aspects else also the legal ones.

Therefore I think you will need at least one layer between Qlik and your IT system. For this you could use any file-exchange or any write-back approach to a database or maybe a connector like this one: tiq-solutions.de - tiq-java-service-connector. You could contact the head - Ralf Becher - behind the connector to find out if it might be possible / sensible in your usecase.

- Marcus

Re: How to use QV as a in-memory data source ?

rbecher — Thu, 20 Dec 2018 09:10:40 GMT

Hi Alex,

I think there are perhaps some products for getting data out of QV in-memory models but I have my doubts that works well.

What I would do instead is to run a Qlik Sense server beside where you binary load your QVW, or having an app with same load script.

Then you can use the engine API to access the in-memory model by defining a HyperCube. There is also an open source project q-risotto I started which provides REST API wrapper for this to make it easy:

https://github.com/ralfbecher/q-risotto

- Ralf

Re: How to use QV as a in-memory data source ?

allon_s18 — Thu, 20 Dec 2018 09:35:09 GMT

Ralf, colleagues.

I appreciate your quickest response.

Thank you very much for your valuable help.

Sincerely yours, Alex.

Re: How to use QV as a in-memory data source ?

allon_s18 — Fri, 18 Jan 2019 12:27:07 GMT

Hello!

Another question.

QV has a report which I want to use as data source.

To export data to CSV I want to use NPrinting job from QV.

Is it possible to do it for QV-report which consists of 200 000 rows and 1200 columns ?

Are there some limitations and constraints for QV NPrinting ?

BR, Alex.

Re: How to use QV as a in-memory data source ?

marcus_sommer — Fri, 18 Jan 2019 13:28:01 GMT

I could imagine that you run into various problems with such a big table with or without NPrinting in regard to limitations/bugs within the object, the RAM consumption and the calculation/transfer-times. I wouldn't do a try in this direction else I would create this table within the script and store it as csv.

- Marcus