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. Connect 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 databaseRead Iris dataset SQLite Connector DB Row Filter DB Query DB Reader DB Column Filter DB Reader DB Writer DB Writer File Reader This workflow shows a number of database nodes that directly work inside a database. Connect 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 databaseRead Iris datasetSQLite Connector DB Row Filter DB Query DB Reader DB Column Filter DB Reader DB Writer DB Writer File Reader

Nodes

Extensions

Links