Oracle database connection

[leonjosf]

I am surprised that there is no proper guide on setting up an oracle connection.

[morpheus]

Hi @leonjosf

please read this reference:

KNIME Database Extension Guide

BR

[takbb]

Hi @leonjosf , welcome to the KNIME forum

I can’t tell if you’ve done so but make sure you have installed the Oracle jdbc extension, as described in the latest version of the above guide which is here

That way you get an actual Oracle Connector instead of having to manually configure the jdbc drivers etc.

For the most part, once you have the Oracle extension installed, you can connect oracle by specifying the host address, port, service name, and user credentials. In some cases you may have problems if you have firewalls etc that need to be opened, but if your client machine can connect to the database with Oracle SQL Developer, there should be nothing blocking KNIME from doing so as it uses the same jdbc technology.

If you have specific error messages, please post back.

[alpayzeybek]

I’ve been using KNIME with an Oracle Database connection since 2018, and the KNIME forum has been incredibly helpful in ironing out some issues I’ve encountered along the way. If you have any questions, I’d be happy to help, @leonjosf.