Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Can Qlikview write-back to an Oracle database?

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. 

7 Replies
Not applicable

Can Qlikview write-back to an Oracle database?

Hi,

It is possible to write back to database using macros.

Not applicable

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

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

engishfaque
Valued Contributor III

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

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

jaaldurgam
Valued Contributor

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

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

Not applicable

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

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

Hope this will help

Not applicable

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

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.

Not applicable

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

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