Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner
Partner

Oracle 10g to Qlikview 11 SR5

Hie...

Please help me out to connect Oracle 10g to Qlikview11 SR5....

Give the steps & what to download on my qlikview server...

Thanking You,

Regards,

Mohammad.

1 Solution

Accepted Solutions
mohammadkhatimi
Partner
Partner
Author

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:

TNS Name=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1800))

    )

    (CONNECT_DATA =

      (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

View solution in original post

17 Replies
mohammadkhatimi
Partner
Partner
Author

Guyz its Urgent requriment...

Help Please...!!

amit_saini
Master III
Master III

Hi,

Hope this will help u.

Thanks,
AS

prma7799
Master III
Master III

skusuma1991
Creator
Creator

Hi amit saini,

Creating a system DSN is different from what you are showing in your document?

Regards

Sagar

mohammadkhatimi
Partner
Partner
Author

Guys which are the software that i hv=ave to install in my qlikview server???

ToniKautto
Employee
Employee

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.

mohammadkhatimi
Partner
Partner
Author

I have try to connect with ODBC but it showing an error

Check the error its in attached file

praveenavelagap
Creator III
Creator III

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.

mohammadkhatimi
Partner
Partner
Author

Hi Praveena,

Thanks for reply...

I tried to connect with ODBC but its showing a error check that attached file...