Public
This directory contains 400 workflows.
kn_example_db_h2_large_files_split
H2 database split into 1 GB chunks in order to store very large data
kn_example_db_h2_merge
MERGE an existing database and insert new rows with H2 - use the Northwind DB
kn_example_db_h2_primary_key
Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
kn_example_db_h2_update_in_databse
H2 do an UPDATE on the server using a VIEW of the existing and the new data
kn_example_db_loop_multiple_tables
Identify tables in you database(s) and loop over them and store the data in a CSV file
kn_example_db_mysql
create table in MySQL
kn_example_db_mysql_where_clause
create table in MySQL and create a dynamic WHERE clause with integers and strings
kn_example_db_paradox_corel
Load a Borland/Corel Paradox SQL database into KNIME with a JDBC driver
kn_example_db_sqlite_jpg_images
SQLite - store and read JPEG Files in databases - also using Python
kn_example_db_sqlite_python_sql
KNIME, Python and SQL with local SQLite database Some examples how to interact with a (local) SQLite database with SQL commands via Python (Jupyter […]