Node Connectivity

There are 47 nodes that can be used as predessesor for a node with an input port of type DB Data.

DB Query Injector Modern UI

Creates a DB Data port from the input DB Connection and a string variable with the SQL query to use.

DB Type Mapper StreamableModern UI

Enables you to change the database to KNIME type mapping for subsequent nodes.

DB Writer (DB Data) StreamableModern UI

Writes the input database table into a new database table.

Spark to DB 

Writes a Spark DataFrame/RDD into a database table

Spark to Hive 

Writes an incoming Spark DataFrame/RDD into a Hive table.

Spark to Impala 

Writes an incoming Spark DataFrame/RDD into a Impala table.

Run R Model in Microsoft SQL Server 

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