Solved: Re: ODBC greyed out - Qlik Community

Tool_Tip · ‎2024-09-19

Dear all,

We are first time trying to create ODBC connection with oracle so we have selected the ODBC from the data connection list but it seems greyed out:

p_verkooijen · ‎2024-09-19

Hi @Tool_Tip

The QlikOdbcConnectorPackage is for QlikView. It's embedded in Qlik Sense see help

Setup using Qlik Sense ODBC connector

Create new connection and search for Oracle

Setup using the Oracle driver

If you want to use the Oracle driver and an ODBC connection you have to set it up first in Windows, it only shows existing connections.

To create a ODBC using te Oracle driver you must download and install multiple packages

Go to https://www.oracle.com/nl/database/technologies/instant-client/winx64-64-downloads.html

Choose the correct version and download Base and ODBC Package

Base - one of these packages is required
- Basic
- Basic Light
Development and Runtime - optional packages
- ODBC Package

1. Install the Instant Client Basic or Basic Light.
Download Instant Client Basic or Basic Light package and unzip it into the designated directory (e.g. C:\oracle\product). Once the package is unzipped, a new directory with name instantclient_XX_Y (where XX refers the major version and Y refers the minor version of Instant Client)

2. Now unzip the downloaded Instant Client ODBC from the same designated directory where the basic or basic light was unzipped.

Combine the contents of these zip files into 1 folder

3. Execute odbc_install.exe to install the Oracle ODBC driver from the Instant Client directory.

4. Place the tnsnames.ora file in a subfolder C:\OracleDriver\instantclient_XX_Y\network\admin

https://www.ibm.com/docs/en/tnpm/1.4.4?topic=client-creating-tnsnamesora-file

After this you are able to setup the ODBC connection

Create a System DSN so the ODBC connection is visible for all users.

View solution in original post

Rohan · ‎2024-09-19

Hi @Tool_Tip ,

you will have to create an odbc driver on your server where you have installed qlik sense. & then you will be able to access those in this list & connect to your desired db system. Hope this helps you.

Regards,

Rohan.

Tool_Tip · ‎2024-09-19

Hi Rohan,

The same I was thinking of, can you help with the steps to perform this activity? and what are all the software I will required to install.

Rohan · ‎2024-09-19

Hi @Tool_Tip ,

Check out the following article once :

https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-ODBC-connection-to-Oracle/td-p/788946

Regard,

Rohan.

Tool_Tip · ‎2024-09-19

Thank you rohan, I will check.

Before going any further things, I also want to inform you that I have already installed the below file from qlik, hopefully you know this. so just want to confirm still I have follow the steps you have given ?

Rohan · ‎2024-09-19

Just go through the given links in that article. you will have clarity on getting it done.

Regard,

Rohan.

Tool_Tip · ‎2024-09-19

I have downloaded oracle instant client as per the URL you have given and followed the steps from the document:

I am getting below error in cmd:

Rohan · ‎2024-09-19

Hi @Tool_Tip ,

Check this one out instead :

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm#:~:te....

Regards,

Rohan.

Tool_Tip · ‎2024-09-19

Now I am getting below error :

Rohan · ‎2024-09-19

Check if the proper drivers have been installed.

https://community.progress.com/s/article/ODBC-Driver-cannot-be-loaded-due-to-system-error-126

Regards,

Rohan.