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

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: 2024-04-20
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!