Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
anat
Contributor

loading data form QVD to any DataBase or Files

Hi Team,

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

5 Replies
vardhancse
Valued Contributor III

Re: loading data form QVD to any DataBase or Files

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

Partner
Partner

Re: loading data form QVD to any DataBase or Files

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
Contributor

Re: loading data form QVD to any DataBase or Files

Team,

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

MVP
MVP

Re: loading data form QVD to any DataBase or Files

google search for

advanced etl processor

etl-tools

Re: loading data form QVD to any DataBase or Files

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