Node Connectivity

There are 68 nodes that can be used as successor for a node with an output port of type DB Session.

DB Merger Streamable

Merges (insert or updates) rows in the database based on the values of the selected columns from the KNIME input table.

DB Query Reader 

Executes an entered SQL query and returns the result as KNIME data table.

DB Reference Row Deleter Streamable

Deletes rows in the database based on the values of the selected columns from the KNIME input table.

DB Row Inserter Streamable

Inserts rows in the database based on the values of the selected columns from the KNIME input table.

DB Row Manipulator Streamable

This node runs SQL commands in the connected database restricted by the possible values given by the input KNIME data table.

DB Update StreamableDeprecated

Updates rows in the database based on the values of the selected columns from the KNIME input table.

DB Updater Streamable

Updates rows in the database based on the values of the selected columns from the KNIME input table.

DB Writer Streamable

Inserts the selected rows in the database based on the selected columns from the input table. Creates a new table if the table does not exist.

DB Writer StreamableDeprecated

Inserts the selected rows in the database based on the selected columns from the input table. Creates a new table if the table does not exist.

DB Transaction End 

Ends a database transaction.