Write Back to Oracle Database

[Anonymous]

I have made a pricing tool in QlikVIew which basically reads raw pricing data from the database, user inputs discount, currency rate and shipping and handling charges, and I create a quote based on user input and pricing data from database.

My challenge now is to store this quote information back to the database so that I can have the history of all quotes. While I know that QlikView is basically a repoting tool, I am hoping that someone has a script which will connect to the Oracle database and issue an INSERT statement (from users input).

Any help would be appreciated.

Thanks,

Dinesh.

[Lee_Matthews]

Hi Dinesh  For a server based solution, try the following post for an example of how to write back to a database.  http://community.qlik.com/docs/DOC-2784  You obviously need to build your own specific solution, but this should set you heading in the right direction.  Regards

[#3]

Hello,

To insert data into ORACLE, 2 ways :

1. ODBC : add "MODE WRITE" in ODBC Connection string like below

ODBC

CONNECT32 TO [MICDW;DBQ=XXXXXXX] (XUserId is DJLJFDLKJDKLÖFLKÖFJD, XPassword is DFLHJ=DFKJKÖLKLDJF, Mode is write);

OR

2. Use Oracle OLEDB driver , works well !!!

64-bit Oracle Data Access Components (ODAC) Downloads

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

Regards