Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

write to an Oracle database from qlikview

to write to an Oracle database from qlikview with script? it's possible?

Labels (1)
2 Replies
asinha1991
Creator III
Creator III

yes in the script it is possible...create a connection and then fire your query

sql insert into …

sql update tbl

sql call procname() etc.

you can also pass variables to these 

sql call procname($(par1)) for example

Brett_Bleess
Former Employee
Former Employee

Souad, there is another step involved here, in the Script Editor, you will need to go to the Settings tab, lower left area of the dialog, and in those tab settings, set the DB read write and you may need to set allow execute as well.  I believe that should cover things.  Please be sure you thoroughly test things before putting into production.  

Oh, and since this is Oracle, there is a good chance the account running things may need some extra security rights in the Oracle side as well, in particular if you are using Publisher to run things...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.