Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract data from QVD file into JAVA Bean

I´m trying to find out a way to get each line of data from a type QVD file used in a QlikView Developer 9.0 version and put it into a Java Bean object. Does anyone have a tutorial, instructions or help that would assist me doing this transfer please. How would I go about creating this java class?

7 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

Opa, olá amigo! Acho que não dá... O QVD já vem no formato que o Qlik sobe na memória, meio "criptografado"... Mas no script da versão 9 acredito que você pode fazer um STORE em outros formatos como csv.

Translating... I think you can´t, but in QV9 Script Editor you can Store tables in another format like csv.

Or
MVP
MVP

You'd be better-served saving your data as a format other than QVD - for example, CSV - and reading from these files. If you absolutely have to read from QVD - it can be done, but I haven't seen the methods published anywhere in the public domain (Obviously reading from QVD can be done by external applications - for example, Vizubi is able to read QVDs). You could try contacting QlikTech's technical support and see if they can provide the read logic.

Not applicable
Author

Does anyone know where can I find an ODBC driver to access a qvw file from a java bean object? I´m trying to extract data from a table in qlikview file such as .qvw extension and put it on a java application.

Not applicable
Author

have you got the solution

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

QlikODBC driver won't help in your situation... I'd recommend using STORE commands to store the data as a CSV and then reading the data from CSV.

It's not a big deal to add a few STORE commands to extract the tables into a CSV. THis command will get performed every time the script is running. When you need the data to be accessed from Java application - just access the CSV. The data won't change between the reloads...

llauses243
Creator III
Creator III

Hi Eduardo,

From Spain this solution ...

. from your apply

. parms: QVD name, to filter: bookmark name, fielnames, values

. call qlikview.exe with parms, this contains:

.. load script: Load... &QVD name

.. macro: export table to clipboard

. output: clipboard, to your apply

123 to believe

rbecher
MVP
MVP

Hi Eduardo,

I'm working on a Java project to read/write QVD files:

tiqview.tumblr.com/post/26630334356/qlikview-data-integration-in-a-java-world-with-qvx

- Ralf

Astrato.io Head of R&D