topic Re: Dynamically Load one table to Oracle DB from Qlikview? in QlikView

Dynamically Load one table to Oracle DB from Qlikview?

chandu441 — Fri, 06 Jan 2017 16:50:40 GMT

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:

Cheers All,

Satya

Re: Dynamically Load one table to Oracle DB from Qlikview?

Gysbert_Wassenaar — Fri, 06 Jan 2017 18:48:46 GMT

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.

Re: Dynamically Load one table to Oracle DB from Qlikview?

chandu441 — Fri, 06 Jan 2017 19:08:35 GMT

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

Re: Dynamically Load one table to Oracle DB from Qlikview?

Gysbert_Wassenaar — Fri, 06 Jan 2017 19:17:44 GMT

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.