Node Connectivity

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

DB Writer StreamableDeprecated

Inserts the selected rows in the database based on the selected columns from the input table. Creates a new table if the table does not exist.

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.