Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading data to a database from Qlikview

Hello

I am loading data from flat files into QlikView.  I have a requirement to load back the data stored in QVD files to a database.

Is it possible to do so?

1 Reply
agilos_mla
Partner - Creator III
Partner - Creator III

Hi,

I think you could store the QVD in csv format (just replace file extension .qvd with .csv and (qvd) by (csv) in the store statement, the csv will have the table structure of the target database table. Then depending of the db engine you're running, you can make bulk load from the csv file such as SQL loader in Oracle, you could also prepare the insert statement in each line when writing down the qvd but not sure it helps more.

rgds,