Node Connectivity

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

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 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.

DB Transaction End 

Ends a database transaction.

DB Transaction Start 

Starts a database transaction.

DB Query Injector 

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

DB SQL Executor 

Executes custom SQL statement(s) in the database.

DB Table Creator 

This node allows a user to create a new database table either manually or based on the data table specification of a KNIME input data table.