Icon

02_​Databases

23 workflows in this folder and its subfolders

Icon
01_​Database_​Simple_​IO_​Example

January 1970 · This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" database (the entire database is written to a file on the hard disk).

Icon
02_​Database_​Advanced_​Example

January 1970 · This workflow shows a KNIME workflow with a number of database nodes that directly work inside a database. It uses the file-based "sqlite" database (the entire database is written to a file on the hard disk).

Icon
03_​Read_​and_​Write_​PNG_​Images_​in_​Databases

March 2015 · Database - Read/Write PNG Images This workflow demonstrates how to read/write PNG images from/to a database. URL: KNIME Database Documentation https://docs.knime.com/latest/db_extension_guide/index.html TAGS: database,sqlite,image handling

Icon
04_​Binning_​in_​Databases

December 2015 · Database Binning This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. An example would be to convert a numerical column, which contains the age in years, into a categorical column with values such as children and adults. T…

Icon
05_​Pivoting_​in_​Databases

December 2015 · This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your data based on a pivot, aggregation and value columns.

Icon
06_​Sampling_​in_​Databases

December 2015 · This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also supports stratified sampling, which is the preferred way to sample from populations with varying subpopulation sizes.

Icon
08_​Database_​Jam_​Session

January 1970 · Database Jam Session This workflow jams together data from not one, not two, but six databases! They are: MySQL, MongoDB, MS SQL Server, MariaDB, Oracle, PostgreSQL. The use case is a Next Best Offer, modeling the likelihood of a customer to buy a second product. This workflow is a variation of the…

Icon
09_​Teradata_​Aster_​meets_​KNIME_​Table

April 2017 · Will They Blend? Teradata Aster - KNIME Table Today's challenge is to blend the data between a Teradata Aster database and a KNIME table in the KNIME Analytics Platform. Why these two? Teradata Aster is a database system in use at many companies around the world, and KNIME tables are an easy way to…

Icon
10_​GoogleBigQuery_​meets_​SQLite

August 2017 · Google Big Query meets SQLite. The business of baseball games. This workflow graphically explores attendance at baseball games together with weather conditions and calendar information using a bar chart and a sunburst chart. Attendance data are stored in a Big Query Database. Weather conditions data…

Icon
11_​Snowflake_​meets_​Tableau

April 2017 · Snowflake meets Tableau This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales orders are read from an Excel file, return orders supplied from our e-commerce platform's API in JSON format are filtered out, all the clean correct orders…