Utility

This category contains 10 nodes.

IconDB Connection Table Writer (Labs) Sink

Writes the input database table into a new database table.

IconDB Drop Table Manipulator

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

IconDB Query Extractor (Labs) Source

Extracts the SQL query from a database port.

IconDB Query Injector (Labs) Source

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

IconDB SQL Executor Manipulator

The Database Executor allows to execute any custom SQL Statement on the database.

IconDB SQL Executor (Labs) Manipulator

The Database Executor allows to execute any custom SQL Statement on the database.

IconDB Table Creator Source

This node allows a user to create a new database table either manually or based on the data table spec of an input data table.

IconDB Table Creator (Labs) Source

This node allows a user to create a new database table either manually or based on the data table spec of an input data table.

IconDB Table Remover (Labs) Manipulator

Removes a table from the database using the input database connection.

IconDB Type Mapper (Labs) Manipulator

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