Data Access | KNIME

Skip to main content

KNIME

Quicklinks

Download

Hub
Blog
Forum
Events
Careers
Contact

Main navigation

Software
Solutions
Learning
Partners
Community
About

Home
Learning
NODE GUIDE
Data Access

Main navigation

Getting Started
FAQ
Learning Hub
E-Learning Course
KNIME Cheat Sheets
Documentation
Events and Courses
Developers
White Papers
KNIME Press
KNIME TV
Changelogs

Data Generation
WebLog Files
Audio Files
Git
ZIP and Remote Files
Common Type Files
Structured Data
REST Web Services
Databases

Subscribe to Data Access

Software
Solutions
Learning
Partners
Community
About

Solutions
Innovation Notes
Customer Intelligence
Social Media
Finance
Manufacturing
Pharma / Health Care
Retail
Cross Industry
Government

Innovation Notes
Anomaly Detection
Competitive Pricing Decisions
Inventory Optimization
Pharma Patents
Recommendation Engine for Retailers
Understanding Customer Satisfaction

Customer Intelligence
Churn Analysis
Churn Prediction

Social Media
Social Media Sentiment Analysis
Social Media Leader/Follower Analysis

Finance
Credit Scoring

Manufacturing
Energy Usage Prediction

Pharma / Health Care
Chemical Library Enumeration
Virtual High Throughput Screening
Outlier Detection in Medical Claims

Retail
Social Media Music Recommendation
Market Basket Analysis

Cross Industry
Combining Text and Network Mining
Address Deduplication

Government
Forest Fire Prediction
Network Traffic Reporting
Actuarial Tables

Learning
Getting Started
FAQ
Learning Hub
E-Learning Course
KNIME Cheat Sheets
Documentation
Events and Courses
Developers
White Papers
KNIME Press
KNIME TV
Changelogs

Getting Started
Download
Install
Build a workflow
Example Workflows
Install Extensions

Data Access
Big Data
Community
Scripting
Other Analytics Types
Partners
Visualization
Analytics
Strange but Educational
Applications
ETL Data Manipulation
Enterprise
Innovation Notes
Control Structures
Reporting

Data Access
Data Generation
WebLog Files
Audio Files
Git
ZIP and Remote Files
Common Type Files
Structured Data
REST Web Services
Databases

Data Generation
Splitting data and rejoining for manipulating only subpart
Generating data sets containing association rules
Generation of data set with more complex cluster structure
Random combination of two sets of data
Parallel Generation of a Data Set containing Clusters
Advantages of Quasi Random Sequence Generation
Data generation model example
Generating clusters with Gaussian distribution
Generating random missing values in an existing data set
Generating a Shopping Market Data Set

WebLog Files
Example for Apache Logfile Analysis

Audio Files
Example Speech-to-Text
Feature Extraction from Audio Files

Git
Visualizing Git Statistics for Guided Analytics
Tagging from Multiple Git Repositories
Calculating Git Statistics

ZIP and Remote Files
AmazonS3-MSBlobStorage Census Data
SAS SPSS MATLAB meet S3
Amazon S3 Remote File Example
ZIP Local vs remoteHTTP
Azure Blob Store Remote File Example

Common Type Files
Data Loading Example
Table Reader
Multiple Sheet in one Excel File
Google Sheet-meets-Excel
Reading Excel Files
Read a CSV file
Read an XLS file
Read all sheets from an XLS file in a loop
Use the File Reader

Structured Data
Basic XML processing with XPath
XML processing (Bush books) XPath
XML meets JSON

REST Web Services
Translate Using Google API
Access YouTube REST API
Private Google Sheet-meets-Excel
SugarCRM meets Salesforce
Public Google Sheet-meets-Excel
IBM Watson News-Google News
Data API Using REST Nodes

Databases
GoogleBigQuery meets SQLite
Snowflake meets Tableau
Database Jam Session
Teradata Aster meets KNIME Table
MSAccess meets H2
Binning in Databases
Database Advanced Example
Pivoting in Databases
Read and Write PNG Images in Databases
Sampling in Databases
Database Simple IO Example

Big Data
Big Data Connectors
Spark Executor

Big Data Connectors
Big Data Preprocessing Example
HDFS and File Handling Example

Spark Executor
SparkSQL meets HiveQL
Parameter Optimization in Spark
Recommendation Engine w Spark Collaborative Filtering
Spark MLlib Decision Tree
Hive to Spark to Hive
PMML to Spark Comprehensive Mode Learning Mass Prediction
Big Data Irish Meter on Spark only
Mass Learning Event Prediction MLlib to PMML
Learning Asociation Rule for Next Restaurant Prediction
Modularized Spark Scripting

Community
HCS Tools
RDKit
Image Processing
Vernalis

HCS Tools
Visualization of screening data
Dose Response
Quality Control
Normalization of screening data
Visualization of screening data 2
Metadata utilities for screening data

RDKit
Find Scaffolds And Sidechains
RDKit with Java Snippet Example
Working In 3D
Clustering
Template Enumeration
Chemical Topic Modeling
Chemical Transformations
Reaction Enumeration

Vernalis
SMARTSViewer
PDB Query Download and Save Locally
Databased MMP Example
Simple MMP Example
Speedy SMILES ChEMBL Preprocessing Benchmarking

Scripting
R
Java
Python

R
Example of R Snippet

Java
Example of Java Snippet

Python
embedding documents with jupyter
Using Python Script in Databases
Fetch ChEMBL Target Data
Using Jupyter from KNIME to embed documents

Other Analytics Types
Network Mining
Semantic Web
Text Processing
Social Media
Chemistry and Life Sciences

Network Mining
DrugBank Network analysis
Schools Wiki Partition Analysis
Filtering in Networks
Schools Wiki Network Analysis
Networks and Prediction
Looping in Networks
Create Network from Edge Table
Clustering Networks based on Distance Matrix
Pubmed Author Network Analysis

Semantic Web
SPARQL INSERT Query from table
SPARQL INSERT from file
Using Semantic Web to generate Simpsons TagCloud
SPARQL Executor
Doing a large Query on a public endpoint
SPARQL SELECT Query from different endpoints
SPARQL UPDATE Query
Read and write triples from and to file
SPARQL Queries and named graphs
Semantic Web Analysis Accessing DBpedia
SPARQL DELETE Query

Text Processing
Blend Languages in Tag Cloud
Document clustering
DocumentVector Hashing
Document Classification
Sentiment Classification with NGrams
Analyzing Twitter Posts with Custom Tagging
epub JPEG Romeo Juliet
Topic Detection LDA
Sentiment Analysis Lexicon Based Approach
NER Tagger Model Training
RSS Feed Reader
Topicriver Red-Riding-Hood
DocumentVector FeatureSpaceAdaption
Lemmatizer Preprocessing
Word Embedding Distance
Fuzzy String Matching
TopicExtraction with the ElbowMethod
Dictionary based Tagging
NY Times RSS Feed Tag Cloud
Named Entity Tag Cloud
Discover Secret Ingredient
Hierarchical Clustering Visualization
Streaming Sentiment Classification
Sentiment Classification
Tika Parsing
Analyse and Visualize Job Postings

Social Media
NetworkAnalytics meets TextProcessing
Twitter meets PostgreSQL

Chemistry and Life Sciences
Fetch And Transform PubChem Data
Example for using MoSS
Fun with Tags

Partners
Microsoft
Amazon

Microsoft
Predict DepartureDelays with MicrosoftR
HDI Hive KNIME
SQL Server InDB Processing(Azure)
HDI Hive Spark
SQLServer BlobStorage andKNIMEModels

Amazon
Model Deployment as REST API

Visualization
JavaScript
Geolocation

JavaScript
Interactive Webportal Visualisation of Neighbor Network
Using the Sunburst Chart for Titanic
Example for JS Line Plot Advanced
Bivariate Visual Exploration with Scatter Plot
Disease Genes
Example for JS Box Plot
Example for JS Parallel Coordinates
Example for JS Scatter Plot
Example for JS Line Plot Basic
Example for JS Bar Chart
Univariate Visual Exploration with Data Explorer
DataVisualization AirlineDataset

Geolocation
Static geolocation of IP addresses
GeoIP Visualization using Open Street Map (OSM)
Visualizing Routes and Tracks with OSM
FIFA World Cup
Dynamic geolocation of IP addresses
Choropleth World Map
Google Geocode API-OSM-text file
Visualization of the World Cities using Open Street Map (OSM)

Analytics
Classification and Predictive Modelling
Regressions
Clustering
Scoring
Optimization
XGBoost
Deep Learning
Active Learning
Time Series
Statistics
H2O Machine Learning
Preprocessing
PMML
Meta Learning

Classification and Predictive Modelling
Decision Tree
Example for Learning a Naive Bayes Model
Exporting a Decision Tree as Image
Gradient Boosted Trees
Example for Learning a Neural Network
Logistic Regression
Example for Learning a Decision Tree

Regressions
Learning a Simple Regression Tree

Clustering
Performing a k-Medoids Clustering
Performing a k-Means Clustering

Scoring
Evaluating Classification Model Performance

Optimization
Optimizing Subset Selection
Parameter Optimization two examples
Cross Validation with SVM
Cross Validation with SVM and Parameter Optimization
Model Optimization and Selection
Parameter Optimization
Score Erosion for Multi Objective Optimization
Meassuring Variable Importance

XGBoost
Housing Value Regression with XGBoost
Classify Forest Covertypes with XGBoost

Deep Learning
Read And Execute a SavedModel on MNIST
Train MNIST classifier
Training Tensorflow MLP
Edit MNIST SavedModel
Translating From Keras to TensorFlow
Training
Deployment
Preprocess image data
Fine-tune VGG16 Python
Train simple CNN
Fine-tune VGG16
Deployment
Training
Deployment
Training
Classify images using InceptionV3
Neural Machine Translation
Classify images using ResNet50
Semantic Segmentation
Wide and Deep Learning on Census Dataset
Sentiment Analysis with Deep Learning
Train MNIST classifier
Sentiment Analysis with Deep Learning KNIME nodes
Using DeepLearning4J to classify MNIST Digits
Sentiment Classification Using Word Vectors
Network Example Of A MLP For Images
Housing Value Prediction Using Regression
Celebrity Detection Using Alex Net
Simple Regression Of Simple Functions
Calculate Document Distance Using Word Vectors
Network Example Of A Simple Convolutional Net
Font Detection Using A Convolutional Net
Basic Learner View Tutorial
Basic Concepts Of Deeplearning4J Integration
Simple Anomaly Detection Using A Convolutional Net
Simple Document Classification Using Word Vectors
Network Example Of A Simple MLP

Active Learning
Active Learning PBCA modular Score
Active Learning Uncertainty Sampling
Active Learning PBCA default

Time Series
Example of Time Series Functionality
Example for Predicting Time Series

Statistics
Calculating the Cronbach Alpha
Independent groups t-test
Performing a Linear Discriminant Analysis
Kolmogorov-Smirnov Matrix
Example for Statistical Tests
Simple Example with Statistics

H2O Machine Learning
H2O Data import and export
H2O Crossvalidation
H2O GBM Classification Model
H2O Scoring
H2O GBM parameter optimization
H2O GLM Regression Model
Customer prediction with H2O

Preprocessing
Perform Feature Selection
Feature Elimination with Naive Bayes
Techniques for Dimensionality Reduction

PMML
Example for Using PMML for Transformation and Prediction

Meta Learning
Cross-Platform Ensemble Model
Learning a Random Forest
Combining Classifiers using Prediction Fusion
Learning a Tree Ensemble Model

Strange but Educational
Strange Loops

Strange Loops
Feature Elimination Done Manually

Swiss Actuarial Example
Swiss Actuarial Example

Reproducibility
Validating KNIME Workflows

Churn Prediction
Training a Churn Predictor
Deploying the Churn Predictor

TwitterAnalysis
Visualizing Twitter Network with a Chord Diagram
Analyzing Twitter Data
Collecting data from Twitter

Forest Fire Prediction
Forest Fire Prediction

Customer Segmentation Use Case
Customer Segmentation Use Case
Basic Customer Segmentation Use Case

BlackJack
BlackJack

Credit Scoring
CreditScoring

Inventory Optimization
Data Preparation
Guided Analytics

Price Benchmarking
Guided Analytics

Credit Risk Assessment
Scoring Deployment
Scoring Training

Hitlist Processing
Select Followup Compounds
Hitlist Filter

Forum Analysis of the KNIME Forum
Simple Statistics on KNIME Forum
Text Classification from Forum Posts
Parsing the KNIME Forum
Applying Text and Network Analysis Techniques to Forums

Deployment Options
Model Deployment with report and email
Model Deployment file to database scheduling
Model Deployment dashboard WebPortal
Model Deployment as REST API
Model Deployment SQL Java recoding

Churn Analysis
ChurnAnalysis

RESTful ChEMBL
ChEMBL Structure Search
ChEMBL Bioactivity Search
ChEMBL REST Services

Predicting Departure Delays
Analytics
OpenSourceVizAndModeling
Scaling Analytics w BigData

Recomendation Engine for Retailers
Data Preparation
Guided Analytics

NYC Taxi Visualization
Visualization
Preparation

AnomalyDetection
Creating a ControlChart of a Time Series
Email to start checkup
Preprocessing Time Alignment and Visualization
Time Series AR Deployment
Time Series AR Training
Time Series AR Testing
Time Series AR Training dataviz

Social Media clustering
Clustering the Social Community

BLAST from the PAST
from the PAST

Energy Usage
Energy Usage Time Series Prediction

Fraud Detection
Detection Model Training
Detection Deployment

Histopathology Blog Post
Download Dataset
Preprocessing
WebPortal Predictions
Read Images and Train VGG

Anomaly Detection
Preprocessing Time Alignment and Visualization
Time Series AR Deployment
Time Series AR Training

LastFM Recommendations
LastFM Recommendations

Guided Analytics for ML Automation
Guided Analytics for ML Automation

GDPR examples
Anonymize personal data
GDPR Examples Overview
Consolidate workflow documentation
Basic Data Preparation
Identify PII and Special Category Data
Explain Model

DataCleaning WebPortal
WebPortal

Customer Experience and Sentiment Analysis
Data Preparation
Rest API Sentiment Prediction
Guided Analytics
Model Building

RESTDemo
Call a Workflow on a Server
Call Local Workflow

Address Deduplication
Deduplication of Address Data
01 Deduplication of Address data

Patent Network Analysis
Tarceva neighbor network from SureChEMBL
neighbor network - From SureChEMBL

Network Traffic Reporting
Network Traffic Reporting

Model Selection and Management
Model Selection Sampled

MarketBasketAnalysis
Apply Association Rules for MarketBasketAnalysis
Build Association Rules for MarketBasketAnalysis

Medical Claims
Interactive Outlier Detection

Emil the TeacherBot
AL First Try Assign Classes via Distance
Emil the TeacherBot
AL Extend Expert Classes with kNN
Initial Model Training
AL Labelling
AL Re-label Uncertain Classes
AL Training Subset Uncertain Classes

Customer Intelligence
B2B Customer Analytics

Image Recognition for Retail
Guided Analytics
Data Preparation and CNN Training

Sentiment Prediction via REST
Rest API Sentiment Prediction
Link to web application

Model Process Management
Evaluate Price RMSD
Tables Locally
Init ModelName
Log Tables
Transform andTimeDiff
Load productData
Evaluate price Trend
Learn Trend
Score Trend
Load for Cities
Init for Cities
Model Factory
PricePred 05 Training
PricePred 03 ET
PricePred 04 Evaluation
PricePred 01 Init
PricePred 02 Load
rentAppPred 03 ET
rentAppPred 04 Evaluation
rentAppPred 05 Training
rentAppPred 01 Init
rentAppPred 02 Load
CheckState
SeeAll
SetThresholdsToMedian
Update Type Change
Update
Factory

ETL Data Manipulation
Date and Time Manipulation
Filtering
Aggregations
Transformation
Joining and Concatenating
Indexing Searching
Basic Examples

Date and Time Manipulation
Generate Fixed Time Intervalls
Customers Trx Money vs Loyalty
Filter TimeSeries Data Using FlowVariables
ETL Energy autocorr stats

Filtering
Techniques Outlier Detection
Column Filter
Advanced Row Filters
More Row Filter Examples
More Column Filter Examples
Validating Datatables
Row Filtering

Aggregations
Working with Collection Supported Nodes
Working with Collection Supported Types
Working with Collection Creation and Conversion
Calculating Rank Correlations
Examples for Using the Pivoting Node
More GroupBy Examples
Advanced Usage of the GroupBy node
Generating a Ranking value
Basic Examples for Using the GroupBy Node

Transformation
StringManipulation MathFormula RuleEngine
Handling Missing Values

Joining and Concatenating
Joiner
Concatenate
JoinConcatenate Examples

Indexing Searching
Advanced Queries
Example for Fuzzy Address Matching
Document Queries

Basic Examples
Visual Analysis of Sales Data
Example for Standard Preprocessing
ETL Basics

Enterprise
Server
WebPortal

Server
Create basic service
Create basic service2
Write files into the Server Repository
Generate a Report and Save the File

WebPortal
Quickforms to table
Example for a Data Mining WebPortal
Select most recent date and time cells
Read file send as EMail
Visualize Scatterplot on file
Guided Analytics
Showing an autogenerated time series line plot
Extract System and Environment Variables (Linux only)
DataVisualization AirlineDataset

Innovation Notes
Customer Intelligence
Sentiment Prediction via REST
Inventory Optimization
Price Benchmarking
Anomaly Detection
Image Recognition for Retail
Customer Experience and Sentiment Analysis
Recomendation Engine for Retailers

Customer Intelligence
B2B Customer Analytics

Sentiment Prediction via REST
Rest API Sentiment Prediction
Link to web application

Inventory Optimization
Data Preparation
Guided Analytics

Price Benchmarking
Guided Analytics

Anomaly Detection
Preprocessing Time Alignment and Visualization
Time Series AR Deployment
Time Series AR Training

Image Recognition for Retail
Guided Analytics
Data Preparation and CNN Training

Customer Experience and Sentiment Analysis
Data Preparation
Rest API Sentiment Prediction
Guided Analytics
Model Building

Recomendation Engine for Retailers
Data Preparation
Guided Analytics

Control Structures
Workflow Orchestration
Meta Nodes and Wrapped Nodes
Loops
Quickforms
Flow Variables
External Applications
Switches

Workflow Orchestration
call server workflow (JSON)
call local workflow (JSON)
call server workflow (REST)
call server workflow (Table)
call workflow (Table)
call workflow parallel (Table)
Fault Tolerant Workflow Orchestration

Meta Nodes and Wrapped Nodes
Simple Streaming and Wrapped Nodes

Loops
Example for Recursive Replacement of Strings
Looping a fixed number
Looping over all columns and manipulation of each
Usage of Generic Loop Start
Loop over a set of parameter for k means
Example for Reading a List of Files
Looping over defined Intervals
Writing a data table column wise to multiple csv files
Collecting Variables in Loop
Write each row in one file
Recover from Breakpoint in Loop
Looping for Multiple Target Prediction
Using TableRows as FlowVariables in Loop
Usage of Breakpoint in Loops
Looping over Chunks of the Data
Example for Recursive Looping
Looping over Groups of the Data
Collecting Columns in Loop

Quickforms
Quickforms and Metanodes

Flow Variables
Extract Data for Highest Sale Country
Create and Consume Flow Vars
Using Flow Variables to control Execution Order
Using Flow Variables for the Time Range

External Applications
Example for the external tool (Linux or Mac only)

Switches
Using a If Switch
Using JAVA for If Switch
Switch on Empty Tables
Case Switch

Reporting
Tableau
BIRT

Tableau
Tableau Integration Example
Tableau BIRT JS

BIRT
Report for Soccer Data with R
Example for a Chemical Report
Report with Radarplot and R
BIRT Example Basic
Example for Reporting
Simple Example for Reporting
Using KNIME Colors in BIRT Report
BIRT Example Advanced

Events and Courses
Courses
Past Events
KNIME Summits

Developers
Developer Guide
FAQ
JavaDoc API
Example Implementation
Noding Guidelines
Nightly Build

Developer Guide
Overview Plugin Concept
New Node Wizard
NodeFactory
NodeDialog
Default Dialog Components
NodeModel
NodeView
Test Your Node
Export And Deploy Your Node as a Plugin

NodeDialog
loadSettingsFrom
saveSettingsTo

Default Dialog Components
Available Default Dialog Components
Disabling Components
Example NodeModel
Example Code Dialog
SettingsModelListener
DialogComponents and NodeDialogPane
DefaultDialogComponents Troubleshooting

NodeModel
configure
execute
loadInternals
loadValidatedSettingsFrom
notifyViews
reset
saveInternals
saveSettingsTo
setWarningMessage
validateSettings

NodeView
modelChanged
onClose
onOpen
setNODATALabel
updatePaintModel

Example Implementation
First Steps
NodeModel
NodeDialog
NodeView
Save and Load Your Internal Representation
HiLiting
Save And Load an External Model
Adapt Your Node Description
Sample Code

NodeModel
ValidateSettings
load/saveSettings
configure Method
Execute Method

KNIME Press
KNIME Beginner's Luck
KNIME Advanced Luck
From Words to Wisdom
Practicing Data Science

Partners
Find a Partner
Become a Partner
Partner Program
Partner Award Program
Partner Plan and Commissions
Frequently Asked Questions
Lead Registration

Community
Forum
Workflow Hub
KNIME Labs
Community Contributions
Community Developers
Free Partner Extensions

KNIME Labs
Installation
Indexing and Searching
Neighborgrams
Network Mining
Pipeline Pilot Connector
Perl Scripting Node
Python Scripting
SAS7BDAT Node
Text Processing
TIBCO Spotfire
Web Analytics
Web Service Client
File Handling
Optimization
Active Learning
Deeplearning4J
Deep Learning

Indexing and Searching
Examples

Neighborgrams
Contained Nodes

Network Mining
Supported Network Types
Network Features
Network Visualization
Examples

Text Processing
Documentation
Examples
Forum

Documentation
IO
Enrichment
Preprocessing
Frequencies
Transformation
Custom Tag Sets (for developers)
Custom Tagger (for developers)

Examples
Dictionary based Tagging
Document Classification
Document Clustering
Tag Cloud
Term Coocurrence Heatmap
Named Entity Recognizer and Tag Cloud

Deeplearning4J
Deeplearning4J - Image Processing
Deeplearning4J - Text Processing

Deep Learning
Keras Integration
TensorFlow Integration

Vernalis
CDK
Chemical Identifier Resolver

HCS Tools
de.NBI/CIBI Contributions

Continental Nodes for KNIME
Palladian
Scripting Integrations
Digital Signal Processing Nodes

Continental Nodes for KNIME
Continental Nodes for KNIME — XLS Formatter Nodes
Utility Nodes

Free Partner Extensions
Free Marvin Chemistry Extensions
Free Actian DataFlow Extensions
Free Databiz Extensions

About
News
Blog
Team
Careers
Contact Us
Travel Information
KNIME Open Source Story
Open for Innovation