Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
chandu441
Creator
Creator

Dynamically Load one table to Oracle DB from Qlikview?

Hi all,

I am having one typical requirement. I have created one table in Qlikview script level in the final i am saving it to QVD.

What ever i am saving in QVD have to save in Oracle DB dynamically which already created Table in DB.

Sample Screenshot Table:

Capture.JPG

Cheers All,

Satya

3 Replies
Gysbert_Wassenaar

When you save the table to a qvd file, also save the table in csv format. Then import that csv file into your oracle database. Or use the csv file as an external table in your oracle database.


talk is cheap, supply exceeds demand
chandu441
Creator
Creator
Author

Hi gysbert,

Even i got the same idea but still waiting that we can do something else than this approach.

Thanks for your input Gysbert

Gysbert_Wassenaar

Sure, there are lots of very cumbersome ways to basically do the same thing. Qlikview is designed to load data and visualize that data. It is definitely not designed to pump data in other databases. If you need that functionality then use a real ETL tool designed for that purpose.


talk is cheap, supply exceeds demand