Does Qlikview have the capability to write-back to the fact tables or dim tables in an Oracle or SQL db? It would be highly efficient if adjustments could be made with Qlikview's What-if tool and then submitted to a database with almost instaneous results populated.
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
Yes, you can write back into oracle using QlikView Macros.
Please note, this is not good practice to write back through QlikView.
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
Also, you can generate CSV from Qlikview and use SQL loader to insert data into oracle. For the huge amount of data tio be inserted please follow this method.
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