Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Specialist III
Specialist III

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

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

Team,

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

Highlighted
MVP
MVP

google search for

advanced etl processor

etl-tools

Highlighted

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