how to insert data from qlikview to oracle databas... - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-06-28

how to insert data from qlikview to oracle database ?

Anonymous · ‎2015-03-16

Yes You can...

buzzy996 · ‎2015-03-16

it's big thing,but u can achieve through web services.

but in other way,some one said above if u like,

1.export from qlikview into excel

2. load from excel into ur database table

(For this:

1. start

2.Program

3.sql import and export wizard

4. set ur authorization details

5. select ur excel file

6. click finish).

Anonymous · ‎2015-03-16

Yes.

You can also export to XML and don't use excel.

You can also use a program with capture XML generated and insert it's contents into DB.

So You Can....

Report Inappropriate Content · ‎2015-10-06

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

Regards