Database Connection Table Reader

This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

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

Icon
Database connection to a table

Output Ports

Icon
Database read from database

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.