Inserts data rows into the selected database table
based on the values from the selected KNIME input table columns.
All selected column names need to exactly match the column names within the database table.
The column order of the KNIME table and the database table do not need to match.
The output table contains two additional columns if the Append insert statuses checkbox is checked.
The first extra column is the number of rows affected by the INSERT statement. A number greater than or
equal to zero -- indicates that the command was processed successfully and is an insert count giving the
number of rows in the database that were affected by the command's execution. A value of -2 -- indicates
that the command was processed successfully but that the number of rows affected is unknown. The second
shows a warning message, if any.
Options
Settings
Output Type Mapping
This tab allows you to define rules to map from KNIME types to database types.
Popular Successors
- DB SQL Executor6 %
- Joiner4 %
- Loop End4 %
- DB Query Reader4 %
- DB Connection Closer4 %
- DB Connection Extractor4 %
- DB Insert3 %
- DB Reader2 %
- DB Update2 %
- DB Writer2 %
- DB Query2 %
- GroupBy2 %
- Merge Variables2 %
- DB Table Creator1 %
- Excel Writer1 %
- Wait...1 %
- DB Table Selector1 %
Row Filter (deprecated)1 %- Timer Info1 %
- DB Connection Table Writer1 %
- End IF1 %
- Variable Loop End1 %
Column Rename1 %- DB Concatenate1 %
- Column Filter< 1 %
- DB Looping< 1 %
- Python Script (legacy)< 1 %
- CSV Writer< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Loader< 1 %
- Value Counter< 1 %
- DB Row Filter< 1 %
- Column Expressions< 1 %
Table Row to Variable< 1 %Loop End< 1 %- Concatenate< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- DB Connector< 1 %
- DB Column Filter< 1 %
- Table Row to Variable< 1 %
DB Loader< 1 %- String to Number< 1 %
- String Manipulation< 1 %
- CASE Switch End< 1 %
- Java Snippet< 1 %
- Column Appender< 1 %
- Send Email< 1 %
- Parallel Chunk End< 1 %
- DB Delete (Filter)< 1 %
- DB Joiner< 1 %
DB Table Creator< 1 %- Transfer Files< 1 %
- Text Output Widget (legacy)< 1 %
Database Writer< 1 %- Column Resorter< 1 %
Joiner< 1 %CASE Switch Variable (End)< 1 %- Create Date&Time Range< 1 %
CSV Writer< 1 %- Column Rename (Regex)< 1 %
- Duplicate Row Filter< 1 %
- Table Manipulator< 1 %
- String Manipulation (Variable)< 1 %
- Extract Table Dimension< 1 %
- DB Merge< 1 %
- DB Row Manipulator< 1 %
- DB GroupBy< 1 %
- DB Partitioning< 1 %
- DB Query Extractor< 1 %
- Excel Reader< 1 %
- Google Sheets Reader< 1 %
- Reference Database Table Exists IF Switch (Legacy)< 1 %
Database Looping< 1 %- Column List Loop Start< 1 %
Concatenate (Optional in)< 1 %- Column Name Extractor< 1 %
- Cross Joiner< 1 %
- Catch Errors (Generic Ports)< 1 %
- Try (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Table Creator< 1 %
- Chunk Loop Start< 1 %
- Variable Condition Loop End< 1 %
Variable Loop End< 1 %- Add Empty Rows< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- Reference Row Filter< 1 %
- Cache< 1 %
- DB Delete (Table)< 1 %
- Parameterized DB Query Reader< 1 %
- DB Column Rename< 1 %
- DB Transaction End< 1 %
- Math Formula< 1 %
- Date&Time Configuration< 1 %
- Credentials Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Data to Report (BIRT)< 1 %
- String to Date&Time< 1 %
- DB DISTINCT< 1 %
Flow Variable End IF< 1 %- Memory Use< 1 %
- Catch Errors (Data Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
- Variable to Table Column< 1 %
- Variable to Table Row< 1 %
- Table Reader< 1 %
- Table Writer< 1 %
Table Writer< 1 %- Variable Creator< 1 %
Loop End (2 ports)< 1 %- Column Comparator< 1 %
- Column Renamer (Dictionary)< 1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- Sorter< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- CASE Switch Start< 1 %
- IF Switch< 1 %
Merge Variables< 1 %- Interactive Table (legacy)< 1 %
- Impala to Spark< 1 %
- MySQL Connector< 1 %
- PostgreSQL Connector< 1 %
- DB Type Mapper< 1 %
- DB Pivot< 1 %
- DB Sorter< 1 %
- Variable Expressions< 1 %
- OSM Map View< 1 %
- Send to Power BI< 1 %
- Java IF (Table)< 1 %
- Delete Files/Folders< 1 %
- Transfer Files (Table)< 1 %
- Container Output (Table)< 1 %
- Message Slack channel< 1 %
Database Update< 1 %- POST Request< 1 %
- Date&Time to String< 1 %
- Breakpoint< 1 %
Database Connector< 1 %- Filter Apply< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Spec< 1 %
Parquet Writer< 1 %- Capture Workflow End< 1 %
- TimeDelay Loop End< 1 %
- Benchmark Start (Flow Variable)< 1 %
Python Snippet< 1 %- String to URI< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Variable to Table Row< 1 %List Files< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %- Cluster Assigner< 1 %
- Case Converter< 1 %
Column Appender< 1 %- Edit Numeric Domain< 1 %
- Filter Apply Row Splitter< 1 %
- Partitioning< 1 %
- Number Rounder< 1 %
- Line Plot (legacy)< 1 %
- Save Workflow< 1 %
- Table to Spark< 1 %
- Parallel Chunk Start< 1 %
- Math Formula (Multi Column)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
- Tableau Writer< 1 %
Transfer Files< 1 %- Column Filter Configuration< 1 %
Extract Date&Time Fields< 1 %Loop End (3 ports)< 1 %- Read Variables< 1 %
- Benchmark End< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- SSH Connection (legacy)< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %Database Delete< 1 %Database Table Creator< 1 %- Java Edit Variable< 1 %
- Loop End (Column Append)< 1 %
Generic Loop Start< 1 %- Group Loop Start< 1 %
- DBSCAN< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Aggregator< 1 %
- Table Validator (Reference)< 1 %
- Double to Integer< 1 %
- Row Filter (Labs)< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Numeric Outliers< 1 %
- Histogram (legacy)< 1 %
MySQL Connector< 1 %- DB Row Sampling< 1 %
- DB Table Remover< 1 %
- Empty Table Creator< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- String to Path (Variable)< 1 %
- Credentials Configuration< 1 %
- CSS Editor< 1 %
- Date&Time Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- String to Duration< 1 %
- Modify Date< 1 %
- XPath< 1 %
- Table to HTML String< 1 %
- BERT Classification Learner< 1 %
- String Similarity< 1 %
- WebDriver Factory< 1 %
Views
- This node has no views
Workflows
01 Practicing with Traditional DatabasesKNIME Forum- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- 01 Practicing with Traditional Databases - SolutionKNIME Hub
- Show all 150 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.