Icon

02_​Database_​Advanced_​Example

Databases - Advanced Usage

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 entire database is written to a file on the hard disk).



This workflow shows a number of database nodes that directly work inside a database. Read Iris datasetConnect to SQLitedatabase(in-memory)Filter rows(in database)Modify database queryRead filtered and modified data from database (creates KNIME table)Filter columns(in database)Read filtered datafrom database(creates KNIME table)Write Iris datasetto SQLite databaseWrite filtered datato database File Reader SQLite Connector DB Row Filter DB Query DB Reader DB Column Filter DB Reader DB Writer DB Writer This workflow shows a number of database nodes that directly work inside a database. Read Iris datasetConnect to SQLitedatabase(in-memory)Filter rows(in database)Modify database queryRead filtered and modified data from database (creates KNIME table)Filter columns(in database)Read filtered datafrom database(creates KNIME table)Write Iris datasetto SQLite databaseWrite filtered datato database File Reader SQLite Connector DB Row Filter DB Query DB Reader DB Column Filter DB Reader DB Writer DB Writer

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2020-11-03
Last update: 2024-04-17
Created with KNIME version: v4.1.0
Tags: databasesqlite

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

Try NodePit Runner!