Icon

16_​Database_​Structure_​Manipulation

Database Structure Manipulation
Write a local data table into a database, write data manipulated on the database into a new databasetable, and read data from database into KNIME Read data from database into KNIME Write data from KNIME to a database connect toH2 databaseRemove existingtableWrite todatabasedirectlyInsert the dataChange typeString to Local Date TimeGroup bycustomer nameImport back to KNIMECreate a new table and directlyinsert the dataTable to be stored in databaseCreate a newtableBulk load H2 Connector DB Table Remover DB ConnectionTable Writer DB Insert DB Type Mapper DB GroupBy DB Reader DB Writer Table Reader DB Table Creator DB Loader Write a local data table into a database, write data manipulated on the database into a new databasetable, and read data from database into KNIME Read data from database into KNIME Write data from KNIME to a database connect toH2 databaseRemove existingtableWrite todatabasedirectlyInsert the dataChange typeString to Local Date TimeGroup bycustomer nameImport back to KNIMECreate a new table and directlyinsert the dataTable to be stored in databaseCreate a newtableBulk load H2 Connector DB Table Remover DB ConnectionTable Writer DB Insert DB Type Mapper DB GroupBy DB Reader DB Writer Table Reader DB Table Creator DB Loader

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: dewi
Created at: 2019-11-13
On NodePit since: 2020-09-11
Last update: 2026-07-19
Created with KNIME version: v4.5.0
Tags: databaseutilityDBtype mappinginsertloadprimary key

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!