topic Re: Writeback to database in QlikView

Writeback to database

vijetas42 — Tue, 30 Jul 2019 08:11:11 GMT

Hi All,

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

Thanks!

Re: Writeback to database

Brett_Bleess — Wed, 21 Aug 2019 14:47:46 GMT

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

Regards,
Brett

Re: Writeback to database

shiveshsingh — Wed, 21 Aug 2019 14:50:38 GMT

AFAIK, it is not possible without a macro.

Re: Writeback to database

vijetas42 — Thu, 22 Aug 2019 13:49:05 GMT

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

Re: Writeback to database

Brett_Bleess — Thu, 22 Aug 2019 15:29:19 GMT

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