JDBC Drivers

Some databases — OracleDB, for example — are not shipped with a JDBC driver by KNIME. To connect to these databases from a Runner workflow, you need to register a vendor-provided driver in your environment.

1. Download the JDBC driver from your database vendor (typically a .jar file, e.g. ojdbc8.jar). Register it in your local KNIME Analytics Platform following the KNIME Database Extension Guide and confirm that your workflow connects successfully before continuing.

2. Once the local connection works, export your KNIME preferences via File → Export Preferences…. The exported .epf file contains the driver registration entries you will need.

3. Open the environment and go to Additional Files. Upload the driver .jar file. Runner makes it available inside the container at /nodepit/<filename> — for example, /nodepit/ojdbc8.jar.

4. Under Preference Entries (or Preference File if you prefer to use the exported .epf), add an entry that points to the driver file in /nodepit. Check your exported preferences for the correct key. For a driver named OracleDB, the entry looks like this:

   Key	Value
   /instance/org.knime.database/drivers/OracleDB/paths/0	/nodepit/ojdbc8.jar

   The key structure varies by database and driver name — use the exported preferences as your reference.

5. Save the environment and run your schedule.

See Environments for the full list of available settings.