Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
ipauldur
Creator
Creator

Oracle connector

Hi,

Can we use oracle connector to connect the database for extracting data. Normally we are using odbc or oledb provider to extract data from the oracle database.

Is it possible to use oracle connector for extracing data in Qlikview?

Regards,

Durai.

1 Reply
stephencredmond
Luminary Alumni
Luminary Alumni

Hi,

You just need to install the Oracle Data Access Components and configure your TNS, etc., and then you should be able to use either OLEDB or ODBC. Note that there are specific versions (as of 10g) for 32bit and 64bit. Had a client with a 64bit server and tried to install the 9i drivers - didn't work because they only came in 32bit version.

In general, the latest version of the ODAC should be able to talk to any supported Oracle version.

Regards,

Stephen