Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help needed to connect to Oracle server?

I'm new to QV, cn some provide step by step approach to connect to Oracle db,

Instance name: oxxl

tried using the drivers built in QV, no success

~Eric

1 Solution

Accepted Solutions
swarup_malli
Not applicable

Help needed to connect to Oracle server?


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 (http://www.oracle.com/technetwork/topics/winsoft-085727.html) 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

1 Reply
swarup_malli
Not applicable

Help needed to connect to Oracle server?


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 (http://www.oracle.com/technetwork/topics/winsoft-085727.html) 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