1 ×

Database Connection Table Reader

KNIME Base Nodes version 3.7.1.v201901291053 by KNIME AG, Zurich, Switzerland

Opens a database connection based on the input settings and reads the entire data table from the database into KNIME.

Options

Use database row id
If enabled the KNIME row id is based on the row id returned from the database. An internal counter is used to generate the row id if the option is disabled. If you encounter a duplicate key exception disable this option. This is caused by a faulty implementation of the used jdbc driver.

Input Ports

Database connection to a table

Output Ports

Database read from database

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Base Nodes from the following update site:

KNIME 3.7
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.