topic QVD utilization as source to other reporting tools in QlikView

QVD utilization as source to other reporting tools

Wed, 20 Nov 2013 14:21:41 GMT

Hi,

I was asked a interesting question by my client. Can i use a .QVD file as a data source to other reporting tools.

Ex: Can i run SAP Business Objects reports or Congnos Reporting tool against my .QVD file (as source)?

Can anyone please share your experiences.

Thanks,

Chris

Re: QVD utilization as source to other reporting tools

Bill_Britt — Wed, 20 Nov 2013 14:25:46 GMT

Hi Sekhar,

I have not heard of anyone doing this. I would think that they would have to create an option in their software to read the file, bing it is part binary.

Bill

Re: QVD utilization as source to other reporting tools

Wed, 20 Nov 2013 15:11:31 GMT

No I'm afraid that's not possible. QVD is a proprietary format.

Using the QVX (QlikView data eXchange) format is worth exploring. Admittedly I have never used it myself but it is based on XML standards so with a bit of effort you might be able to develop a feed into another system.

Alternatively have a look at QlikView Expressor.

Re: QVD utilization as source to other reporting tools

jcoggon — Wed, 20 Nov 2013 15:34:36 GMT

There is company called ETL-Tools (Home) that allows you to write QVDs into another data source e.g. MS SQL and then have the other reporting tools read the source. But as far as reading directly from a QVD, dont think its possible.

Re: QVD utilization as source to other reporting tools

Clever_Anjos — Wed, 20 Nov 2013 15:36:17 GMT

QVD is proprietary format.

There´s some comercial libs (Java and .Net) that can open this format.

However I would recomend you to export the values to csv flat files when you´re storing your qvd´s

Store mytable to $(Pathqvd)\myqvd(qvd);
Store mytable to $(Pathcsv)\mycsv(txt);

Re: QVD utilization as source to other reporting tools

Bill_Britt — Wed, 20 Nov 2013 15:49:28 GMT

Hi,

A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for mininum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats.

So that might work, but the export to cvs will be limited.

Bill

Re: QVD utilization as source to other reporting tools

Bill_Britt — Wed, 20 Nov 2013 17:34:00 GMT

Yea, but that isn't really the answer to the question. He is wanting to use the QVD's in other BI tools.

Bill