This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementDB ReaderThis 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
Popular Predecessors
Database Table Selector6 %Hive Loader (legacy)4 %Database GroupBy3 %Catch Errors (DB Ports)3 %Database Joiner2 %Database Table Connector2 %MySQL Connector2 %SQLite Connector2 %Database Row Filter2 %Database Apply-Binner2 %Database Pivot2 %Vertica Connector2 %- Benchmark Start2 %
CSV Writer2 %- Excel Writer2 %
- Inject Variables (Database)1 %
Database Column Filter1 %Database Connector1 %Database Drop Table1 %Database Table Creator1 %- Timer Info1 %
Run R Model in Microsoft SQL Server1 %Database Query1 %Database SQL Executor1 %Database Sorter1 %Database Writer1 %Database Column Rename1 %Impala Connector1 %Microsoft SQL Server Connector1 %- DB Row Filter1 %
Database Numeric-Binner< 1 %- Concatenate< 1 %
PostgreSQL Connector< 1 %- Integer Input (legacy)< 1 %
CASE Switch Model (End)< 1 %Database Reader< 1 %Database Auto-Binner< 1 %Impala Loader (legacy)< 1 %- Database Select Table (Interactive) (Legacy)< 1 %
- Java Edit Variable< 1 %
- Decision Tree Learner< 1 %
Python Script (Hive)< 1 %- Microsoft SQL Server Connector< 1 %
- Single Selection (legacy)< 1 %
Database End IF< 1 %- Catch Errors (Var Ports)< 1 %
Database Connection Table Writer< 1 %Database Sampling< 1 %Variable Loop End< 1 %- Cell Splitter By Position< 1 %
- Create Date&Time Range< 1 %
- Database DISTINCT (Legacy)< 1 %
- Create File Name (legacy)< 1 %
Parameterized Database Query< 1 %Recursive Loop Start< 1 %CASE Switch Model (Start)< 1 %- DB Table Selector< 1 %
- Multiple Selections (legacy)< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Connection Table Reader< 1 %Database Update< 1 %SQL Extract< 1 %SQL Inject< 1 %Table Reader< 1 %- String Manipulation (Variable)< 1 %
Hive Connector< 1 %Amazon Athena Connector< 1 %Amazon Redshift Connector< 1 %H2 Connector< 1 %- DB Pivot< 1 %
Python Script (DB)< 1 %Database IF Switch< 1 %- Chunk Loop Start< 1 %
Generic Loop Start< 1 %- Column Filter< 1 %
- Filter Apply< 1 %
Merge Variables< 1 %- DB Column Rename< 1 %
- DB Joiner< 1 %
- DB Row Sampling< 1 %
- DB Sorter< 1 %
- Math Formula (Variable)< 1 %
Excel Writer (XLS)< 1 %- Boolean Input (legacy)< 1 %
- Credentials Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
Python Script (DB)< 1 %Table Column to Variable< 1 %- CSV Writer< 1 %
- Table Creator< 1 %
- Table Row to Variable Loop Start< 1 %
- Missing Value< 1 %
- String to Path (Variable)< 1 %
Views
- This node has no views
Workflows
01_Big_Data_Preprocessing_ExampleKNIME Hub- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Bioactivity_Prediction_Load_Pull_DataKNIME Hub
- Show all 21 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.