Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting with Oracle Server

Hi,

I need to connect Qlikview with Oracle server

I do not have Oracle installed on my system, please suggest how to connect

9 Replies
Anil_Babu_Samineni

1) You want to connect other server Thru RDC?

2) Then only you can get the data from there, if you have the access of that.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

I have qlikview installed on my system

I want to create DSN to connect with Oracle server

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Install the Oracle Client on your Qlikview machine and make sure to install the odbc and/or oledb drivers. Then edit the tnsnames.ora file and add an entry for the listener of your oracle database. That is necessary so the odbc and/or oledb drivers can find the listener of your oracle database on the network and communicate with it. If you're going to use odbc then you need to define an odbc connection too using the odbc administration tool. All this is totally unrelated to Qlikview. If you don't understand what I've written above then ask your local friendly oracle database administrator or search the internet for more detailed instructions.


talk is cheap, supply exceeds demand
Not applicable
Author

Is there a way to do it without installing oracle client

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use the Microsoft ODBC for Oracle driver


talk is cheap, supply exceeds demand
Not applicable
Author

getting attached error

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Install the requirement software components


talk is cheap, supply exceeds demand
agomes1971
Specialist II
Specialist II

Not applicable
Author

Oracle client is available but I am getting below attached TNS error while creating user DSN  using Oracle diver

Oracle driver : Oracle in OraClient 11g_home1