oracle connection

I'm trying to connect to an oracle db with credentials i currently use on TOAD. I found the TNSNAMES file that has all the information about the connection.

I downloaded ojdbc5_g,ojdbc5,ojdbc6_g,ojdbc6 and added them to drivers in Preferences under Oracle Thin Driver and I have the  following issues:

1. I can't select the oracle driver in the Database Reader node... it simply doesn't apear in the list

2. I don't really know what  information from the TNSNAMES file I should use in order to connect

I don't have much tehnical background and I'm the first to attempt this connection in my compnay, so there's no tehnical support for me here...

 

Can you please help?

Lucian

 

 

 

 

Hi lucian.cristian,

In order to connect to an Oracle DB, please follow the steps below:

  1. register the oracle jdbc driver via the KNIME preferences
  2. Add the Database Connector to your KNIME workflow
  3. In the dialog of the Database Connector
    1. select "oracle.jdbc.driver.OracleDriver" as database driver
    2. Enter the valid jdbc url into the Database URL field e.g. jdbc:oracle:thin:@[HOST][:PORT]:SID or jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
    3. Enter your username and password into the provided fields
  4. Use the Database Table Selector node to select the table to work on or any other database node

Hope that helps,

Best,

Vincenzo

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.