Oracle and QlikView ??

[#1]

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

[Roop]

Via ODBC or OLE DB in scripting Load command

[hic]

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

HIC

[its_anandrjs]

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];

[fkeuroglian]

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