Read/Write (legacy)

This category contains 12 nodes.

Database Connection Table Reader (legacy) 

Reads the entire data from the input database connection.

Database Connection Table Writer (legacy) 

Writes the input database table into a new database table.

Database Delete (legacy) 

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

Database Looping (legacy) 

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

Database Reader (legacy) 

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

Database Table Connector (legacy) 

Creates a database connection to the specified database.

Database Table Selector (legacy) 

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

Database Update (legacy) 

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

Database Writer (legacy) Streamable

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

Hive Loader (legacy) Deprecated

Loads data from KNIME into Hive