loading data form QVD to any DataBase or Files

[anat]

Hi Team,

Is any way to load the data from QVD to any DataBase or Files.

[vardhancse]

QVD is the qlikview readable data format with better optimization algorithms.

If we want to export the data from QVD, only option is to reload using qlikview client and export to excel

[Gabriel]

Hi,

You can load data from QVD into QlikView but what you can't do is to load data from QVD to database.

Maybe check Extension object

[anat]

Team,

any idea to load data from qvd to database or files?

[maxgro]

google search for

advanced etl processor

etl-tools

[Peter_Cammaert]

Databases and files should be treated entirely differently.

QVD's can only be exported using a script in a QlikView document. Always start by loading a QVD in its entirety in memory. Then, depending on the required output format, do one of these:

• Files: use a STORE statement to store data into a csv file. All data processing should be performed before using the STORE statement.
• Databases: CONNECT to your RDBMS and use SQL UPDATE/SQL INSERT statements to transfer the memory-resident data to DB Tables. Do not forget to put the connection in ReadWrite mode (see "Open Database in ReadWrite mode" in the Settings tab in the Script Editor)

Peter