DataBase Updates is possible through Qlikview Dev Environment

[#1]

Hi All,

To Update a table in Oracle DB..........., USing Qlikview Server Or Qlikview Desktop..............

We need check wether QVD's are Refreshed succesfully or not?

Kindly Help me.

Thanks in Advance,

Ram.

[Gysbert_Wassenaar · Accepted solution]

First the oracle user you use to connect to the oracle database needs to have the priviliges to update the table. Next you need to enable the option Open Database in Read and Write mode on the Settings tab of the script editor. You may also need to check the settings for the ODBC DSN or OLEDB data link to make sure that it's not configured to be read-only.

[#3]

Hi Gysbert,

Could you provide an example for updating Oracle DB table.