Icon

01_​DB_​Connect

01 DB Connect Exercise Solution

Big Data Course DB Exercise #1 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 SQLiteCtrl+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 SQLiteCtrl+double clickto look insideSQLite Connector DB Table Selector DB Reader DB Connector Create JDBC URL Component withCredentials Input

Nodes

Extensions

Links