topic Re: loading data form QVD to any DataBase or Files in QlikView

loading data form QVD to any DataBase or Files

anat — Fri, 20 Nov 2020 18:02:30 GMT

Hi Team,

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

Re: loading data form QVD to any DataBase or Files

vardhancse — Wed, 08 Jul 2015 11:20:40 GMT

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

Re: loading data form QVD to any DataBase or Files

Gabriel — Wed, 08 Jul 2015 11:20:56 GMT

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

Re: loading data form QVD to any DataBase or Files

anat — Fri, 14 Aug 2015 13:10:10 GMT

Team,

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

Re: loading data form QVD to any DataBase or Files

maxgro — Fri, 14 Aug 2015 13:14:26 GMT

google search for

advanced etl processor

etl-tools

Re: loading data form QVD to any DataBase or Files

Peter_Cammaert — Fri, 14 Aug 2015 13:18:24 GMT

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