topic DataBase Updates is possible through Qlikview Dev Environment in QlikView

DataBase Updates is possible through Qlikview Dev Environment

Mon, 08 Jul 2013 13:42:10 GMT

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.

Re: DataBase Updates is possible through Qlikview Dev Environment

Gysbert_Wassenaar — Mon, 08 Jul 2013 17:10:16 GMT

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.

Re: DataBase Updates is possible through Qlikview Dev Environment

Thu, 10 Apr 2014 12:48:51 GMT

Hi Gysbert,

Could you provide an example for updating Oracle DB table.