This category is currently not available in KNIME v5.9 — instead we’re showing this page for KNIME v3.7. You can use the version menu in the title bar to permanently switch your preferred version. This will also show the link to the update site.

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.