2. Write to a Database

Workflow: Write to a Database

This workflow shows how to write a data table into a database. In particular, we use the SQLite database here because it is file-based and does not require additional installation.

This workflow also shows how to performs different kinds of string manipulations and type conversions. To do so, we use the Expression node which allows performing various string, logic, and math operations

Note. This workflow has to be executed BEFORE executing the workflow "3. My first Data Exploration".

Type Conversion

String replacement

Joining strings

Write data to SQLite Database

Use the SQLite Connector node to connect to the SQLite database. Note that SQLite is a file-based database. The SQLite Connector node thus requires the path of the database file. It also supports the knime:// protocol. The SQLite driver is already included in the SQLite Connector node. Drivers of most popular databases are included in database connector nodes for databases' most recent versions.

Then, connect a DB Writer node to the SQLite Connector node to actually write the data into a new table.

String splitting