Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fouaddba
New Contributor

Trying to connect Oracle Database

Hi,

New to QlikSense, trying to connect my Oracle 11g db, using the same steps, as mentioned here:

http://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Oracle/Create-Oracl...

But the problem is Oracle ODBC driver is not visible from MS ODBC admin.

Landed to this page: How to create ODBC connection to Oracle

And followed the process to download and tried to install, but instead of 11g, did 12c - is this a problem?

One change, instead of 11g, downloaded 12_2 ODBC driver, these 2 files:

1. Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

Download instantclient-basic-windows.x64-12.2.0.1.0.zip (75,062,441 bytes) (cksum - 1462971172)

2. Instant Client Package - ODBC Updated 9/20/2017: Additional libraries for enabling ODBC applications

Download instantclient-odbc-windows.x64-12.2.0.1.0-2.zip (804,715 bytes) (cksum - 1844846476)

As mentioned in the steps, created a folder: C:\oracle\instantclient_12_2

Saved both extracted files contents here, but when trying to install, it's giving this msg:

C:\oracle\instantclient_12_2>odbc_install.exe

Oracle ODBC Driver with same name already exists.

And when checking at MS ODBC admin, it's only showing Sql Server, not showing Oracle, please advise/guide, how to fix this problem, or if I'm doing anything wrong here.

Thanks in advance.

Regards

Syed

8 Replies
OmarBenSalem
Esteemed Contributor

Re: Trying to connect Oracle Database

what if u create the connection as follow:

Capture.PNG

Capture.PNG

fouaddba
New Contributor

Re: Trying to connect Oracle Database

Thanks ... when tried this, got this error, please advise:

20180111.png

OmarBenSalem
Esteemed Contributor

Re: Trying to connect Oracle Database

u have to fill the fields with the right information

fouaddba
New Contributor

Re: Trying to connect Oracle Database

the info are all correct, was able to connect using sqlplus.

error msg is about ODBC, do update.

fouaddba
New Contributor

Re: Trying to connect Oracle Database

any assistance/update possible? ... still not resolved.

oferprat
New Contributor

Re: Trying to connect Oracle Database

Were you able to solve this? I am at the same situation now...

p_hamot_cf
New Contributor

Re: Trying to connect Oracle Database

I've exactly the same pb !

If someone has any update on the subject...

ek_qv_user
New Contributor

Re: Trying to connect Oracle Database

Community Browser