Node Connectivity

There are 3449 nodes that can be used as predessesor for a node with an input port of type Table.

DB Delete (Filter) 

Deletes rows in the database that match the specified filter conditions.

DB Delete (Table) Streamable

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

DB Insert Streamable

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

DB Looping Streamable

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

DB Merge 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 Reader Streamable

Executes the input query in the database and retrieves the result into a KNIME data 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 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.