Node Connectivity

There are 5201 nodes that can be used as predessesor for a node with an input port of type Generic Port.

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.

Parameterized DB Query Reader Streamable

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

DB Transaction End 

Ends a database transaction.

DB Transaction Start 

Starts a database transaction.

Amazon Redshift Cluster Launcher 

Creates an Amazon Redshift Cluster.

DB Connection Table Writer 

Writes the input database table into a new database table.

DB Data Spec Extractor 

Extracts the data specification from the input DB Data port.

DB Query Extractor 

Extracts the SQL query from the input DB Data port.

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.