Connect to a database with the generic DB Connector
Use the generic DB Connector node to connect to any JDBC-compliant database that does not have a dedicated connector node in KNIME.
Before you begin
- Obtain the JDBC driver for your database from the database vendor.
- Register the driver in KNIME Analytics Platform before configuring this node. See Register a JDBC driver.
- Have the database connection details ready: hostname, port, database name, and credentials.
Connect to the database
Configure the DB Connector node to establish the connection.
- Add the DB Connector node to the workflow.
- Click the node once to open its configuration.
- Under Database Settings, set Database type to the type that matches your database. If your database is a PostgreSQL derivative, select Postgres. If you are unsure, select default.
- Set Database dialect to the dialect that controls how SQL statements are generated.
- In Database URL, enter the JDBC connection URL for your database, replacing the placeholders (host, port, database name) with actual values.
- Under Database Driver, keep Use latest driver version available selected to use the newest registered driver, or clear it to select a specific driver version. If no matching driver appears, register it first. See Register a JDBC driver.
- Under Authentication, set Authentication type to match your credentials — username and password, a credential flow variable, or Kerberos for databases that support it (for example, Hive or Impala).
- Optionally, expand Show advanced settings to configure JDBC parameters, type mapping, or other advanced options. See Connector node settings for details.
- Click Apply and Execute to save the configuration and execute the node.
Troubleshooting the connection
If the connection fails, expand Show advanced settings and enable JDBC logger under Additional Settings to log JDBC operations. If your database does not support the default identifier quoting character ("), change or remove Identifier delimiter in the same section.