topic Write Back to Oracle Database in QlikView

Write Back to Oracle Database

Anonymous — Tue, 10 Jan 2012 01:14:38 GMT

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.

Write Back to Oracle Database

Lee_Matthews — Tue, 07 Feb 2012 04:35:03 GMT

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

Re: Write Back to Oracle Database

Tue, 06 Oct 2015 16:26:57 GMT

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);

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