Read/Write
This category contains 18 nodes.
DB Delete (Filter)
Deletes rows in the database that match the specified filter conditions.
DB Delete (Table) StreamableDeprecated
Deletes rows in the database based on the values of the selected columns from the KNIME input table.
DB Insert StreamableDeprecated
Inserts rows in the database based on the values of the selected columns from the KNIME input table.
DB Loader StreamableModern UI
Loads data from a KNIME data table into a database table.
DB Loader StreamableDeprecated
Loads data from a KNIME data table into a database table.
DB Looper Streamable
This node runs SQL queries in the connected database restricted by the possible values given by the input table.
DB Merge StreamableDeprecated
Merges (insert or updates) rows in the database based on the values of the selected columns from the KNIME input table.
DB Merger StreamableModern UI
Merges (insert or updates) rows in the database based on the values of the selected columns from the KNIME input table.
DB Parameterized 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 Query Reader
Executes an entered SQL query and returns the result as KNIME data table.