Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

DataBase Updates is possible through Qlikview Dev Environment

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.

1 Solution

Accepted Solutions

Re: DataBase Updates is possible through Qlikview Dev Environment

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.


talk is cheap, supply exceeds demand
2 Replies

Re: DataBase Updates is possible through Qlikview Dev Environment

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.


talk is cheap, supply exceeds demand
Not applicable

Re: DataBase Updates is possible through Qlikview Dev Environment

Hi Gysbert,

Could you provide an example for updating Oracle DB table.

Community Browser