oracle connection

KNIME Analytics Platform
2

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