This node creates a connection to an Oracle server via an Oracle JDBC driver. Due to license restrictions the Oracle JDBC driver is not part of the KNIME Analytics Platform and needs to be downloaded and registered separately. For more details on where to download and how to register the Oracle driver see the database documentation .
You need to provide the server's hostname (or IP address), the port, and a database name. Login credentials can either be provided directly in the configuration or via credential variables.
This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.