Node Connectivity

There are 105 nodes that can be used as successor for a node with an output port of type Database Query.

Impala Loader (legacy) Deprecated

Loads data from KNIME into Impala

Model Writer Deprecated

Writes generic port objects to a file.

Parameterized Database Query Deprecated

This node runs SQL queries in the connected database restricted by the possible values given by the input table.

Python Script (Hive) Deprecated

Allows execution of a Python script in a local Python installation.

Run R Model in Microsoft SQL Server Deprecated

Run R code with a pre-trained R model on a Microsoft SQL Server in a database.

SQL Extract Deprecated

Extracts the SQL query from a database port.

SQL Inject Deprecated

Creates a database port from a database connection and a SQL query.

Database DISTINCT (Legacy) 

This node performs a 'DISTINCT' operation on the selected column(s)

Database Extract Table Dimension (Legacy) 

This node extracts the table dimension from a Database Query Connection

Database Insert Column Header (Legacy) 

This node renames the output columns of a database connection based on the values in a reference table. The underlying database is not affected