topic Can Qlikview write-back to an Oracle database? in QlikView

Can Qlikview write-back to an Oracle database?

Thu, 12 May 2011 00:19:06 GMT

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.

Can Qlikview write-back to an Oracle database?

Thu, 12 May 2011 05:19:09 GMT

Hi,

It is possible to write back to database using macros.

Re: Can Qlikview write-back to an Oracle database?

Tue, 06 Oct 2015 16:29:15 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

Re: Can Qlikview write-back to an Oracle database?

engishfaque — Wed, 07 Oct 2015 04:03:03 GMT

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

Re: Can Qlikview write-back to an Oracle database?

SreeniJD — Wed, 07 Oct 2015 04:42:50 GMT

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

Re: Can Qlikview write-back to an Oracle database?

Wed, 07 Oct 2015 04:45:14 GMT

please follow Write back to database via XML output or web service

Hope this will help

Re: Can Qlikview write-back to an Oracle database?

Wed, 07 Oct 2015 04:48:23 GMT

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.

Re: Can Qlikview write-back to an Oracle database?

Wed, 07 Oct 2015 08:13:19 GMT

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