Read/Write

This category contains 7 nodes.

DB Delete (Labs) Streamable

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

DB Insert (Labs) Streamable

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

DB Merge (Labs) Streamable

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

DB Query Reader (Labs) 

Executes an entered SQL query and returns the result as KNIME data table.

DB Reader (Labs) Streamable

Executes the input query and retrieves the result into a KNIME data table.

DB Update (Labs) Streamable

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

Parameterized DB Query Reader (Labs) Streamable

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