Node Connectivity

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

DB Reference Row Deleter StreamableModern UI

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

DB Row Inserter StreamableModern UI

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 StreamableModern UI

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

DB Writer StreamableModern UI

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 Modern UI

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

DB Type Mapper StreamableModern UI

Enables you to change the database to KNIME type mapping for subsequent nodes.

DB Writer (DB Data) StreamableModern UI

Writes the input database table into a new database table.

Spark to DB 

Writes a Spark DataFrame/RDD into a database table