Steps for getting an ODBC connection to the YourDbName database on a local machine:
Get an Oracle client on your machine:
- First, go to the Oracle instant client download page (Instant Client downloads for Microsoft Windows (x64)) and download the ‘Instant Client Package – Basic’ – it’s the first one.
- Extract the contents of the downloaded zip file to C:\Oracle
Create a TNS names file:
- Copy the following text into a blank text file:
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1800))
(SERVICE_NAME = )
- Save this text file into the C:/Oracle/network/admin folder (create it if it doesn’t exist already), and name it tnsnames.ora (if you have a tnsnames.ora file already, add the copied text to the end of it.
- Go to ‘My Computer’ -> Properties -> Advanced -> Environment Variables, and under ‘User variables’, add a new variable with name TNS_ADMIN, and value ‘C:/Oracle/network/admin’ (or wherever your tnsnames.ora file is)
Create an ODBC Data Source:
- Go to Control Panel -> Data Sources (ODBC) -> System DSN, and click Add..
- Scroll to the bottom of the list and select ‘Oracle in instantclient_11_2’
- Create a data source
How do you intend to connect to the data source?
Commonly Oracle database can be reached with ODBC or OLEDB regardless of client. These tow are also feasible options for QlikView.
Why do you think you need to download something? Have you managed to connect to the data source through any client, so that you know the practice and credentials you require?
If you do not know how to reach the data source, the database administrator commonly can help you with the required drivers and conneciton details.
How do you connect to database in Qlikview client, establish same rights on server as well.
If you have odbc, update user DSN in ODBC data source Administrator under settings.
If it is OLEDB, if it is not AD, update your Oracle DB TNS in file--->Oracle, Program files, network, TNS.org.