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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-06-03 09:36 AM

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

Labels (1)
Labels
2,915 Views
11 Replies
Anonymous
Not applicable
‎2014-06-06 09:09 PM
Author

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

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

322 Views
0 Likes
Not applicable
‎2014-06-07 02:52 AM
Author

In response to Anonymous

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

322 Views