topic Re: Oracle and QlikView ?? in QlikView

Oracle and QlikView ??

Mon, 28 Apr 2014 13:43:06 GMT

How can I connect Oracle and QlikView??? Any chance ?

Re: Oracle and QlikView ??

Roop — Mon, 28 Apr 2014 13:46:51 GMT

Via ODBC or OLE DB in scripting Load command

Re: Oracle and QlikView ??

hic — Mon, 28 Apr 2014 13:47:46 GMT

It should be straightforward to connect using ORACLE ODBC or ORACLE OLEDB. But for that you need to install the ORACLE client.

HIC

Re: Oracle and QlikView ??

its_anandrjs — Mon, 28 Apr 2014 13:53:14 GMT

You need database connection string to connect with the Oracle and make a connection like

ODBC or OLE DB

After that you can pull data from the Oracle database but need to configure and installed the Oracle client on the PC from you connect.

The connection string look likes

(The below string is for the access database file)

ODBC CONNECT TO [MS Access Database;DBQ=D:\Data\aDatabase.accdb];

Re: Oracle and QlikView ??

fkeuroglian — Mon, 28 Apr 2014 13:54:13 GMT

Hi, as all recomend you have to install the oracle client and drivers

then you have to choose between oracle odbc or oracle oledb, the last one is faster than odbc but i recomend trying both and see the difference in the conection time

good luck

Fernando