Node Connectivity

There are 38 nodes that can be used as predessesor for a node with an input port of type Database Query.

Database Sorter Deprecated

The Database Sorter allows to sort rows from a database table.

Database Table Connector Deprecated

Creates a database connection to the specified database.

Database Table Selector Deprecated

Selects a table from a database using the input database JDBC connection.

Hive Loader (legacy) Deprecated

Loads data from KNIME into Hive

Impala Loader (legacy) Deprecated

Loads data from KNIME into Impala

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 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 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