KNIME Documentation

Connect to a database using a dedicated connector node ​

Use a dedicated connector node when KNIME provides one for your database. Dedicated connectors include the correct JDBC driver and a configuration tailored to that database.

Before you begin ​

Supported databases with dedicated connector nodes ​

The following databases have dedicated connector nodes:

If your database is not in this list, use the generic DB Connector node instead. See Connect to a database with the generic DB Connector.

Connect to the database ​

Configure the dedicated connector node to establish the connection. If your database is file-based (H2, SQLite, or Microsoft Access), see Connect to a file-based database instead — its connection parameters differ from server-based databases.

  1. Add the connector node for your database (for example, MySQL Connector) to the workflow.
  2. Click the node once to open its configuration.
  3. Under Location, enter the connection parameters for your database. Available fields vary by database, but typically include the hostname, port, and database name.
  4. Under Authentication, select an authentication type and provide credentials. Enter a username and password directly, or use a credential flow variable.
  5. Optionally, expand Show advanced settings to configure JDBC parameters or other advanced options. See Connector node settings for details.
  6. Click Apply and Execute to save the configuration and execute the node.

Driver version

Select Use latest driver version available to have the node automatically use the highest available driver version. This avoids manual updates after driver upgrades, though driver behavior changes between versions may affect type mapping in rare cases.

Next steps ​