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 WriterThis 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.
Establishes and opens a database access connection to which the entire input table is written to.
If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.
Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver).
Options
Settings
SQL Types
Advanced
Popular Successors
- Delete Files (legacy)6 %
- Java Snippet6 %
CASE Switch Variable (End)4 %- Text Output (legacy)4 %
- Save Workflow4 %
- Time Generator (legacy)2 %
- File Reader2 %
- Copy/Move Files (legacy)2 %
Database Column Rename2 %Database Drop Table2 %SQLite Connector2 %Variable Condition Loop End1 %- Benchmark End1 %
Database SQL Executor1 %Database Writer1 %- POST Request1 %
- Active Branch Inverter1 %
Database Reader1 %- Rule-based Row Filter1 %
- File Reader (Complex Format)1 %
- Loop End1 %
- Concatenate1 %
Catch Errors (DB Ports)< 1 %Variable Loop End< 1 %- Date&Time Shift< 1 %
Table Row To Variable Loop Start< 1 %- DB SQL Executor< 1 %
- Generic Web Service Client< 1 %
- Latitude/Longitude to Coordinate< 1 %
- String to URI< 1 %
- Catch Errors (Data Ports)< 1 %
Database Query< 1 %Parameterized Database Query< 1 %Loop End< 1 %- Reference Row Filter< 1 %
- DB Insert< 1 %
Flow Variable End IF< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Catch Errors (Var Ports)< 1 %
Database Delete< 1 %SQL Inject< 1 %- Constant Value Column< 1 %
- GroupBy< 1 %
- Timer Info< 1 %
- Wait...< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
CSV Reader< 1 %Database Joiner< 1 %File Reader< 1 %- Loop End (Column Append)< 1 %
- Rule-based Row Splitter< 1 %
- External Tool< 1 %
Excel Reader (XLS)< 1 %- Tableau Writer< 1 %
- String Input (legacy)< 1 %
- R Source (Workspace)< 1 %
- String to Date&Time< 1 %
CSV Writer< 1 %Database Connection Table Reader< 1 %Database Table Selector< 1 %Database Connector< 1 %- Table Creator< 1 %
Loop End (2 ports)< 1 %- Variable Loop End< 1 %
Cell Splitter< 1 %- Cross Joiner< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- Pivot< 1 %
- String Replacer< 1 %
- Send Email< 1 %
- Microsoft SQL Server Connector< 1 %
Python Edit Variable< 1 %- Create Date&Time Range< 1 %
Table Row to Variable< 1 %Table Writer< 1 %Interval Loop Start< 1 %Recursive Loop End< 1 %- String Manipulation (Variable)< 1 %
CASE Switch Variable (Start)< 1 %- DB Table Selector< 1 %
- TimeDelay Loop End< 1 %
Excel Sheet Appender (XLS)< 1 %- Database Connection Closer< 1 %
- CSV Reader< 1 %
List Files< 1 %- Java Edit Variable< 1 %
- Group Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %- Column Auto Type Cast< 1 %
- Row Sampling< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
Parquet Writer< 1 %Amazon Redshift Connector< 1 %- DB Query Reader< 1 %
- Date&Time Input (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- Timed Loop End (1 port)< 1 %
- Variable Timed Loop End< 1 %
- Download (legacy)< 1 %
- Upload (legacy)< 1 %
Variable to Table Row< 1 %Database Update< 1 %SQL Extract< 1 %Loop End (Column Append)< 1 %- Table Row to Variable Loop Start< 1 %
- Column Renamer (Dictionary)< 1 %
Column Rename< 1 %- Sorter< 1 %
- String Manipulation< 1 %
- Rule Engine< 1 %
- Rule Engine Variable< 1 %
CASE Switch Data (End)< 1 %Merge Variables< 1 %- SQLite Connector< 1 %
- Counter Generation< 1 %
- Empty Table Creator< 1 %
XLS Reader< 1 %- Java Edit Variable (simple)< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Message Slack channel< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Read Variables< 1 %
- Zip Files (legacy)< 1 %
- Catch Errors (Generic Ports)< 1 %
- Try (Variable Ports)< 1 %
- Create File Name (legacy)< 1 %
- Inject Variables (Database)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %- Variable to Table Row< 1 %
Database Column Filter< 1 %Database Connection Table Writer< 1 %Database Table Connector< 1 %Database Looping< 1 %Database GroupBy< 1 %Counting Loop Start< 1 %- Generic Loop Start< 1 %
Generic Loop Start< 1 %- Add Empty Rows< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- Create Temp Dir (legacy)< 1 %
- Merge Variables< 1 %
- Interactive Table (legacy)< 1 %
- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
MySQL Connector< 1 %PostgreSQL Connector< 1 %Microsoft SQL Server Connector< 1 %- MySQL Connector< 1 %
- DB Connector< 1 %
- DB Reader< 1 %
- Variable Expressions (legacy)< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Excel Writer< 1 %
- Java Snippet (simple)< 1 %
- External Tool (Labs)< 1 %
Google Analytics Connector (deprecated)< 1 %- Container Input (Table)< 1 %
- Container Output (Table)< 1 %
- Container Output (JSON)< 1 %
Python Script (1⇒1)< 1 %- GET Request< 1 %
- Date&Time Difference< 1 %
- String to Date/Time (legacy)< 1 %
Views
- This node has no views
Workflows
01_AnalyticsKNIME Hub- 01_AnalyticsKNIME Hub
- 01_Collecting_data_from_TwitterKNIME Hub
- 01_Model_Deployment_file_to_database_schedulingKNIME Hub
- 01-MaCProQCKNIME Hub
- Show all 17 workflows
Links
- How to speed-up the Spark to Datebase nodeby mlauber71 on 2019-01-26forum.knime.com/p/53524
- Is there a node in Knime for INSERT SQL Statement?by izaychik63 on 2018-09-18forum.knime.com/p/47823
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.