Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

brantley_hobbs
New Contributor III

Where is Qlik ODBC Connectivity pack Oracle TNS names file?

Hi all!

I have a Qlik Sense Enterprise 3.1 server with the 64 bit Qlik ODBC connector package installed.

When I try to add an Oracle connection via the "Qlik ODBC Connector Package" option and select the Oracle driver, I'm prompted for hostname, port and service name.  I do have hostname and port, but I do not have a service name, as I don't know where the TNS names file is that the Qlik connector package supplied driver is located.

Can someone help me out here?  I have the definition to drop into the tnsnames file, I just don't know where that Qlik installed driver is looking for it.

Thanks!

1 Reply
MVP
MVP

Re: Where is Qlik ODBC Connectivity pack Oracle TNS names file?

The tnsnames.ora file is not used by this connector. However finding it and looking at it is necessary to do if you have a local installation of Oracle on your computer.

The service name to use if you have an Oracle XE installed is XE as default.

Oracle is often installed as a directory under root called something with ORACLExxxxx

The path to the tnsnames.ora for my installation of Oracle XE is

     C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora

If your path is different you could search for tnsnames.ora on your harddisk....