Re: Writeback to database - Qlik Community

vijetas42 · ‎2019-07-30

Hi All,

How can we write back to oracle database tables through qlikview dashboard except macro?

Thanks!

Brett_Bleess · ‎2019-08-21

In order to get a better response, it would be helpful if you explain the use case here...

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.

shiveshsingh · ‎2019-08-21

AFAIK, it is not possible without a macro.

vijetas42 · ‎2019-08-22

As, it's a Compensation related application. So, In one of the screen we have form associated with id's when admin logs in he can make changes to available values and

after saving that values should get updated into oracle table as we have modified. Also, reflect the same into dashboard after next refresh

Regards,

Vijeta

Brett_Bleess · ‎2019-08-22

Only method to do that would be the Edit Module and SQL code there, but there are a ton of caveats with that use case, it is likely better to do this outside our product somehow via capturing the things that need to be updated and exporting those etc. to something else that can then run the update in the DB...

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.