Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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