Icon

1. Database Operations

<p><strong>Database Operations</strong></p><p>This workflow shows how to</p><ul><li><p>connect to a database using the DB-specific <em>SQLite Connector</em> node and the generic <em>DB Connector</em> node,</p></li><li><p>implement SQL queries as free text, or</p></li><li><p>implement SQL queries using the database nodes.</p></li></ul>

Database access

Opens the connection to the database and in some cases builds a first SELECT query. For SQLite DB a dedicated connector is available.

Build SELECT query

  • as free text (DB Query node)

  • through DB nodes (DB Row Filter + DB Column Filter node)

Import data into workflow

Extract and Insert existing SQL queries

Writing into a database

Workflow: Database Operations

This workflow shows how to

  • connect to a database using the DB-specific SQLite Connector node and the generic DB Connector node,

  • implement SQL queries as free text, or

  • implement SQL queries using the database nodes.

Note:

Adjust the Database URL in the node configuration:

jdbc:sqlite://<path to DB>

SELECT queryto exclude column "card"
DB Column Filter
SELECT query toexclude rows with prod_4 &include rows with Germany
DB Row Filter
Original data, no prod_4
DB Reader
Match values in"exclude" column
Parameterized DB Query Reader
Delete records withmatching value in "product" column
DB Reference Row Deleter
Select all datafrom sales table
DB Table Selector
Write data from KNIMEdata table into new DB table
DB Writer
No card, no prod_4from Row Filter andColumn Filter
DB Reader
"include" = prod1, prod2, prod3"exclude" = prod_5
Table Creator
Insert data rowinto sales table
DB SQL Executor
Inject queryinto new DB connection
DB Query Injector
Dedicated connectorto KCBBook.sqlite
SQLite Connector
Write results of SQL query to new DB table
DB Writer (DB Data)
Update other field values in records where "column"matches "exclude"
DB Updater
Extract query fromRow Filter + Column Filter
DB Query Extractor
SELECT queryno card, no prod_4
DB Query Reader
Select all datafrom sales table
DB Table Selector
Original table + new India data
DB Reader
No card, no prod_4
DB Reader
Generic connectorto SQLite DBKCBBookCopy.sqlite
DB Connector
SELECT query toexclude rows with prod_4 &include rows with Germany
DB Query

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: 2026-01-06
Last update: 2026-01-07
Created with KNIME version: v5.9.0
Tags: KNIME Advanced LuckBooksDatabaseDatabase accesstutorial

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

Try NodePit Runner!