02_Databases
This directory contains 24 workflows.
01_Database_Simple_IO_Example
This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" database (the entire […]
02_Database_Advanced_Example
This workflow shows a KNIME workflow with a number of database nodes that directly work inside a database. It uses the file-based "sqlite" database (the […]
03_Read_and_Write_PNG_Images_in_Databases
Database - Read/Write PNG Images This workflow demonstrates how to read/write PNG images from/to a database. URL: KNIME Database […]
04_Binning_in_Databases
Database Binning This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. […]
05_Pivoting_in_Databases
This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your data based on a pivot, aggregation […]
06_Sampling_in_Databases
This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also supports stratified sampling, which is the […]
07_MSAccess_meets_H2
This workflow blends data between two common relational database systems, i.e. MS Access and H2. For more information see the workflow metadata. Find it […]
08_Database_Jam_Session
Database Jam Session This workflow jams together data from not one, not two, but six databases! They are: MySQL, MongoDB, MS SQL Server, MariaDB, Oracle, […]
09_Teradata_Aster_meets_KNIME_Table
Will They Blend? Teradata Aster - KNIME Table Today's challenge is to blend the data between a Teradata Aster database and a KNIME table in the KNIME […]
10_GoogleBigQuery_meets_SQLite
Google Big Query meets SQLite. The business of baseball games. This workflow graphically explores attendance at baseball games together with weather […]