Introduction to database operations in KNIME

Data Manipulation in KNIME

Philipp Kowalski

Certified KNIME Trainer

Benefits of working directly in a database

  icons for bandwidth speed and data load

Data Manipulation in KNIME

Benefits of working directly in a database

  icons for bandwidth speed and data load

  icon showing how a database workflow filters data into KNIME

Data Manipulation in KNIME

Connecting to databases

3 KNIME nodes for connect, select, and read

Data Manipulation in KNIME

Connecting to databases

3 KNIME nodes for connect, select, and read, connect highlighted

Data Manipulation in KNIME

Connecting to databases

3 KNIME nodes for connect, select, and read, select highlighted

Data Manipulation in KNIME

Connecting to databases

3 KNIME nodes for connect, select, and read, read highlighted

Data Manipulation in KNIME

Filtering databases

an enhanced KNIME database workflow highlighting the DB Row Filter node

Data Manipulation in KNIME

Filtering databases

part of a KNIME database workflow with the DB Row Filter node highlighted

Data Manipulation in KNIME

Filtering databases

part of a KNIME database workflow with the DB Row Filter node highlighted

screenshot of the DB Row Filter node's configuration

Data Manipulation in KNIME

Merging database tables

KNIME database workflow with the DB Joiner node highlighted

Data Manipulation in KNIME

Merging database tables

KNIME database workflow showcasing DB Join operations

Data Manipulation in KNIME

Merging database tables

KNIME database workflow showcasing DB Join operations

Data Manipulation in KNIME

Updating databases

complete KNIME DB workflow highlighting the DB Writer node

Data Manipulation in KNIME

Updating databases

  icons showing the benefits of using database operations in KNIME

Data Manipulation in KNIME

Updating databases

  icons showing the benefits of using a database for distributed user groups

Data Manipulation in KNIME

Let's practice!

Data Manipulation in KNIME

Preparing Video For Download...