Read/Write

This category contains 12 nodes.

Database Connection Table Reader 

Reads the entire data from the input database connection.

Database Connection Table Writer 

Writes the input database table into a new database table.

Database Delete 

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

Database Looping 

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

Database Reader 

Establishes and opens a database access connection to read a table from.

Database Table Connector 

Creates a database connection to the specified database.

Database Table Selector 

Selects a table from a database using the input database JDBC connection.

Database Update 

Updates the selected rows in the database with the data values from the input tables.

Database Writer Streamable

Establishes and opens a database access connection to which the entire input table is written to.

Hive Loader 

Loads data from KNIME into Hive