There are 47 nodes that can be used as predessesor
for a node with an input port of type DB Data.
Deletes rows in the database based on the values of the selected columns from the KNIME input table.
Inserts rows in the database based on the values of the selected columns from the KNIME input table.
Updates rows in the database based on the values of the selected columns from the KNIME input table.
Updates rows in the database based on the values of the selected columns from the KNIME input table.
Inserts the selected rows in the database based on the selected columns from the input table. Creates a new table if the table does not exist.
Inserts the selected rows in the database based on the selected columns from the input table. Creates a new table if the table does not exist.
Creates a DB Data port from the input DB Connection and a string variable with the SQL query to use.
Enables you to change the database to KNIME type mapping for subsequent nodes.
Writes the input database table into a new database table.
Writes a Spark DataFrame/RDD into a database table