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.
Creates a database connection to the specified database. Note, this
node does only open the connection to read the meta information, but
does not read any data at this point.
Make sure you have your vendor-specific database driver registered in
the KNIME preference page (section Database Driver).
Options
Popular Predecessors
- String Manipulation (Variable)10 %
- Java Edit Variable8 %
Merge Variables6 %Table Column to Variable6 %Database Connection Table Writer4 %- Integer Input (legacy)3 %
- Wait...3 %
Database Reader2 %- Reference Row Filter2 %
Excel Writer (XLS)2 %Database Table Connector2 %- Rule Engine Variable2 %
- Extract Variables (Data)2 %
Database Connection Table Reader2 %File Reader2 %Table Writer2 %PostgreSQL Connector2 %- Try (Variable Ports)1 %
Database Connector1 %- Group Loop Start1 %
- Credentials Input (legacy)1 %
Container Input (Variable)1 %- Variable to Credentials1 %
Table Row to Variable1 %Loop End1 %- Double to Integer1 %
- Column Filter1 %
- URL to File Path (Variable)1 %
- GroupBy1 %
Amazon Redshift Connector1 %Python Script (1⇒1)1 %Variable Loop End< 1 %Row Filter (deprecated)< 1 %- Sorter< 1 %
- Java Edit Variable (simple)< 1 %
Date Input (legacy)< 1 %- Slider Input (legacy)< 1 %
- Parameter Optimization Loop Start< 1 %
- String to Date/Time (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
Table Row to Variable< 1 %Joiner< 1 %Microsoft SQL Server Connector< 1 %- Boolean Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Double Input (legacy)< 1 %
Table Row To Variable Loop Start< 1 %Database SQL Executor< 1 %Database Writer< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %- Column Resorter< 1 %
- String Manipulation< 1 %
- Ungroup< 1 %
- Parallel Chunk Start< 1 %
MySQL Connector< 1 %Excel Reader (XLS)< 1 %- String Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Delete Files (legacy)< 1 %
- SSH Connection (legacy)< 1 %
List Files< 1 %- Java Snippet< 1 %
- Chunk Loop Start< 1 %
SQLite Connector< 1 %- Microsoft SQL Server Connector< 1 %
- SQLite Connector< 1 %
- DB Table Selector< 1 %
- Generic Web Service Client< 1 %
- Java Snippet (simple)< 1 %
- Credentials Configuration< 1 %
Integer Input (legacy)< 1 %- Legacy Date&Time to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Table Creator< 1 %
- Table Row to Variable Loop Start< 1 %
- DB SQL Executor< 1 %
- Date&Time Configuration< 1 %
Views
- This node has no views
Workflows
Links
- No links available
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.