Node Connectivity

There are 46 nodes that can be used as predessesor for a node with an input port of type DB Data.

DB Loader StreamableDeprecated

Loads data from a KNIME data table into a database table.

DB Merge StreamableDeprecated

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

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 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 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 Query Injector 

Creates a DB Data port from the input DB Connection and a string variable with the SQL query to use.