topic Re: loading data from oracle in QlikView

loading data from oracle

Wed, 10 Jul 2013 09:00:36 GMT

Can anybody pls tell me how can i connect to oracle database from qlikview.

i also installed ODAC101040.exe bt still mt getting oracle as option while connecting..thnx in advance

Re: loading data from oracle

Wed, 10 Jul 2013 09:07:34 GMT

go to control panel--> administrative tools--> data sources(ODBC)--> from the window that appears select system DSN--> add new source --> select microsoft ODBC for Oracle and check (test) connection

now in the qlikview script connect to the newly created ODBC connection

hope this would work

Re: loading data from oracle

Wed, 10 Jul 2013 09:10:34 GMT

thnx rishbh bt the problem is am not getting ODBC for oracle option in DSN..i have installed oracle expressedition 10 32 bit on 64bit machine..i downlaoded the OLEDB cnnector for oracle and hav installed it..bt still not getting oracle as option in DSN(add new sorce).i am nt understanding what went wrong..

Re: loading data from oracle

Wed, 10 Jul 2013 09:18:47 GMT

thnx can i use oracle express edition connect it to qlikview

Re: loading data from oracle

Wed, 10 Jul 2013 09:26:53 GMT

ohh ya..after doin forced 32 i got the option of of OLEDB for oracle..thnxbt one more help what shd i put in datasource..ORCL??

Re: loading data from oracle

Wed, 10 Jul 2013 10:25:00 GMT

Can u pls tell me what shd i write in datasource ..

Re: loading data from oracle

prodanov — Wed, 10 Jul 2013 10:48:17 GMT

You must install Oracle Client. You must set up connection in config file manual. Config file is tnsnames.ora. You will find it in oracle folder.

Re: loading data from oracle

Wed, 10 Jul 2013 12:46:33 GMT

thnx dimitar..useful answer

Re: loading data from oracle

prodanov — Wed, 10 Jul 2013 14:19:26 GMT

Welcome