Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Save QVD into Teradata/ORACLE database

Hi,

Looking for a script code to save my qvd into Teradata/Oracle data base.

My requirement is to take the back up of my old qvd file to taradata.

Thanks,

Ragi

11 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

I believe you need QlikView Expressor to do this.

Regards

ASHFAQ

Not applicable
Author

Hi,

it should be possible during reload, with SQL statement.

regards

Darek

rbecher
MVP
MVP

What?

Astrato.io Head of R&D
Not applicable
Author

SQL INSERT .... should work

rbecher
MVP
MVP

And how you're gonna INSERT records of a whole QVD file??

Of course you can code a single INSERT statement (maybe loop) if you have a connection with the rights to write back but you'll never will get a repsonse if it was succesful from the db thru the ODBC/OLEDB connection..

Astrato.io Head of R&D
jeremy_fourman
Creator
Creator

Shooting from the hip here but read in a QVD, save the table to a csv file and using TPT or some importing process load the data back into the database? Basically just dump the data out and use another tool to get it into the database.

rbecher
MVP
MVP

Hi Venkata,

there are only a few tools around which can read an process QVD files externally to push data somewhere. The most easy way seems to be to load the QVD file into QlikView, store it as txt file (csv) and then load the txt file with the available database loader or ETL tool.

- Ralf

Astrato.io Head of R&D
Not applicable
Author

whole QVD ... hmm, of cours i thought about rows

but full file i hope from VB script should be possible

maybe this will help:

community.oracle.com/thread/195148?start=0&tstart=0

Not applicable
Author

What do you think about concatenation on QV script side, put it as param into stored procedure and insert inside database ?