topic Re: Save QVD into Teradata/ORACLE database in QlikView

Save QVD into Teradata/ORACLE database

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Save QVD into Teradata/ORACLE database

ashfaq_haseeb — Tue, 03 Jun 2014 13:43:07 GMT

Hi,

I believe you need QlikView Expressor to do this.

Regards

ASHFAQ

Re: Save QVD into Teradata/ORACLE database

Tue, 03 Jun 2014 13:47:59 GMT

Hi,

it should be possible during reload, with SQL statement.

regards

Darek

Re: Save QVD into Teradata/ORACLE database

rbecher — Tue, 03 Jun 2014 13:52:31 GMT

What?

Re: Save QVD into Teradata/ORACLE database

Tue, 03 Jun 2014 13:53:14 GMT

SQL INSERT .... should work

Re: Save QVD into Teradata/ORACLE database

rbecher — Tue, 03 Jun 2014 13:56:49 GMT

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..

Re: Save QVD into Teradata/ORACLE database

jeremy_fourman — Tue, 03 Jun 2014 14:02:08 GMT

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.

Re: Save QVD into Teradata/ORACLE database

rbecher — Tue, 03 Jun 2014 14:02:47 GMT

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

Re: Re: Save QVD into Teradata/ORACLE database

Tue, 03 Jun 2014 14:04:35 GMT

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

Re: Save QVD into Teradata/ORACLE database

Tue, 03 Jun 2014 14:30:20 GMT

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

Re: Save QVD into Teradata/ORACLE database

Anonymous — Sat, 07 Jun 2014 01:09:44 GMT

Don't think LOAD Script can ever write anything to DB.

Agree with ASHFAQ, simply create a dataflow in Expressor should do it.

Re: Save QVD into Teradata/ORACLE database

Sat, 07 Jun 2014 06:52:22 GMT

Of course, expressor is the best for it.

But if you dont have expressor and your files are not large, and you need to do it once, i think, you may use script. Store data from qvd into another file format and then load it into DB with another tool or try to prepare INSERT statemants or statemants to run stored procedure inside script and fire it with SQL caluse. Trying those solutions is not big cost. Simple find the best approach in your case . I agree, that inserting data into external DB from script is not the best idea in the world, but i think, that in some cases we may try to use it.

regards

Darek