topic Qlik Mashup - Reading QVD Data direct from QVD using an API. in Integration, Extension & APIs

Qlik Mashup - Reading QVD Data direct from QVD using an API.

peachman — Fri, 13 Aug 2021 18:44:03 GMT

Hi All,

I have been looking through the documentation for trying to get data directly from a QVD and not via an apps app.getData() methods.

Has anyone been able to do this, I cannot find any methods in the documentation to achieve such endeavour ?

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

bijoy — Thu, 12 Jan 2023 20:22:41 GMT

I have also a similar requirement to read a QVD using API calls. Were you able to find a solution for this?

Thanks

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

alex_colombo — Mon, 16 Jan 2023 13:26:22 GMT

Hi @peachman and @bijoy, what is the entire use case? Why do you need to access data from a QVD which is not be loaded in a QS app?
There is no documentation on it because there is no API for this kind of requirement.

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

bijoy — Mon, 16 Jan 2023 13:53:16 GMT

Hi @alex_colombo ,

My use case is that I want to reuse the QVDs in some other databases or systems as a source.

For e.g. I want to load the QVDs to Power BI. For that I am looking for a connector /API

Appreciate your help!

Thanks

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

alex_colombo — Mon, 16 Jan 2023 14:50:15 GMT

I suggest to read QVD data directly from source system and not from another BI tool. As per my previous message, there are no APIs for this scenario

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

Cyriac — Mon, 16 Jan 2023 14:58:22 GMT

We are using Qlik essentially as an ETL tool. We did a lot of work on ETL side and now there is a treasure of cleansed and aggregated data resides in QVDs.

To avoid redoing alll the work in Power BI, we are looking for an option to connect to QVDs from Power BI

Thanks

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

stefanstoichev123 — Mon, 16 Jan 2023 15:42:35 GMT

Qlik can store data into TXT/CSV as well. Then the generated files then can be used from other systems as well.

// store into qvd store mytable into myfile.qvd (qvd); // store into csv store mytable into myfile.txt (txt);

Store command

Delimiter options

Stefan

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

Cyriac — Mon, 16 Jan 2023 16:06:26 GMT

Thanks @stefanstoichev123 .

Yes , I know this option. But this create the duplicate data sets. So thought of finding a better way to do this( probably a QVD connector)

Thanks

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

stefanstoichev123 — Mon, 16 Jan 2023 16:12:23 GMT

It will indeed.

Unfortunately there is no (easy) way to read QVD files.

As far as Im aware there is no reliable js package (or in any other language in that matter) that can read QVD files.

Stefan

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

alex_colombo — Mon, 16 Jan 2023 16:27:51 GMT

@Cyriac there is a way for reading QVD data. Indeed QVDs are basically xml files and there are software which can read data within QVDs such as QViewer.

Re: Qlik Mashup - Reading QVD Data direct from QVD using an API.

stefanstoichev123 — Mon, 16 Jan 2023 16:40:37 GMT

Correct but the "readable" XML part will provide just the meta data. If you need the actual data then the situation is more complex and you'll have to read/parse the binary data somehow (read the indexes bit by bit based on offsets etc.)

Stefan