To insert data into ORACLE, 2 ways :
1. ODBC : add "MODE WRITE" in ODBC Connection string like below
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
You can do writeback to Oracle or any other DB through Qlikview. However it is not a best practice to do so for Oracle DB. Oracle is a very good RDBMS and it enforces referential integrity in its tables. Tables are always in Third Normal Form. So, there might be some chance of errors of violating the Normal Form rules while doing Writeback from QV to Oracle..
So, I strongly recommend not to writeback to Oracle DB.
Happy to Help
I'm agree with all of you :
For huge amount, best practice is to generate flatfile with qlikview and use Oracle SQL*Loader to load it fast into Oracle
in some few cases, will be very interesting and easy to do insert or update for few rows from Qlikview to an Oracle Table. In my case i will use it for Technical table, Staging tables, not for Tables used in a relational model, with users working on of course