topic Oracle Instant Client in QlikView

Oracle Instant Client

Wed, 01 Feb 2012 18:41:03 GMT

Will Qlikview Desktop version 10 work on Windows 7 (64-bit) work with Oracle 11g Instant Client? Thanks!

Oracle Instant Client

pover — Wed, 01 Feb 2012 18:46:01 GMT

QlikView uses the Oracle ODBC to connect to the Oracle database. As long as you install the ODBC when you install the Oracle client there should be no issue.

Lot's of people complain about this because they think the ODBC connection is slow, but with a good network connection, I've downloaded more than 1 million rows per minute with the Oracle ODBC connection.

Karl

Re: Oracle Instant Client

rbecher — Wed, 01 Feb 2012 18:59:08 GMT

Hi,

I think you would need both downloads:

Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Instant Client Package - ODBC: Additional libraries for enabling ODBC applications

But I've never tried the instant client with ODBC.

- Ralf

Oracle Instant Client

erichshiino — Fri, 03 Feb 2012 17:10:18 GMT

Hi,

I usually install Oracle ODAC (it contains OLEDB and ODBC drivers)

After this, I config the tnsnames.ora and I'm able to use an OLEDB connection.

Like an ODBC connection, it's easy to point all the connections to a different database by just updating the tnsnames.ora

Regards,

Erich