Icon

01_​DB_​Connect

01 DB Connect Exercise Solution
Missing Values Strategy: 01_DB_ConnectIn this workflow we connect to a database (SQLite) newCensus.sqlite to read table ss13pme(person data) containing data for the US state of Maine Optional: Workflow CredentialsThe node gets user name and passwordfrom the Credentials Configuration nodevariable "nodeMysqlCredentials" newCensus.sqliteselect * from ss13pmeimport all datausing generic DBconnector to connectto SQLiteConfigureList Files/Foldersnode insideCtrl+double clickto look inside SQLite Connector DB Table Selector DB Reader DB Connector Create JDBC URL Component withCredentials Input Missing Values Strategy: 01_DB_ConnectIn this workflow we connect to a database (SQLite) newCensus.sqlite to read table ss13pme(person data) containing data for the US state of Maine Optional: Workflow CredentialsThe node gets user name and passwordfrom the Credentials Configuration nodevariable "nodeMysqlCredentials" newCensus.sqliteselect * from ss13pmeimport all datausing generic DBconnector to connectto SQLiteConfigureList Files/Foldersnode insideCtrl+double clickto look insideSQLite Connector DB Table Selector DB Reader DB Connector Create JDBC URL Component withCredentials Input

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: koetter
Created at: 2015-07-31
On NodePit since: 2020-04-22
Last update: 2024-04-18
Created with KNIME version: v4.3.0
Tags: Big DataEducation

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

Try NodePit Runner!