Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
It is possible to write back to database using macros.
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
Dear Dannyragsdale1523,
Yes, you can write back into oracle using QlikView Macros.
Please note, this is not good practice to write back through QlikView.
Kind regards,
Ishfaque Ahmed
Hi There,
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
Sreeni
please follow Write back to database via XML output or web service
Hope this will 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
BUT
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
Regards