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 Predecessors
- DB Table Creator7 %
- DB SQL Executor6 %
Column Rename4 %- Excel Reader4 %
- Column Filter3 %
- Row Filter3 %
- Joiner3 %
- Microsoft SQL Server Connector3 %
- DB Query Reader3 %
- CSV Reader2 %
- String to Date&Time2 %
- Table Creator2 %
- GroupBy2 %
- DB Connector2 %
- Concatenate2 %
- DB Reader2 %
- PostgreSQL Connector2 %
- Table Manipulator2 %
- String to Number2 %
- String Manipulation2 %
- Duplicate Row Filter2 %
- Column Resorter2 %
- MySQL Connector2 %
- Constant Value Column2 %
- DB Delete (Filter)2 %
- Column Expressions2 %
- Column Renamer1 %
- Rule-based Row Filter1 %
- DB Delete (Table)1 %
- Rule Engine< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- Oracle Connector< 1 %
- Missing Value< 1 %
- Math Formula< 1 %
- DB Update< 1 %
- Cross Joiner< 1 %
- Sorter< 1 %
- Reference Row Filter< 1 %
- Number to String< 1 %
- Microsoft Access Connector< 1 %
- SQLite Connector< 1 %
- Column Appender< 1 %
- File Reader< 1 %
- Row Splitter< 1 %
- Java Snippet< 1 %
- String Manipulation (Multi Column)< 1 %
- Date&Time to String< 1 %
- Chunk Loop Start< 1 %
- Wait...< 1 %
- DB Connection Extractor< 1 %
- Table Reader< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- DB Loader< 1 %
- DB Merge< 1 %
- DB Transaction Start< 1 %
- RowID< 1 %
- Try (Data Ports)< 1 %
Loop End< 1 %- Empty Table Switch< 1 %
- Loop End< 1 %
- Column Auto Type Cast< 1 %
- Excel Writer< 1 %
- Parameterized DB Query Reader< 1 %
- DB Row Manipulator< 1 %
- Column Renamer (Dictionary)< 1 %
- Date&Time-based Row Filter< 1 %
DB Table Creator< 1 %Table Row to Variable< 1 %- Rule-based Row Splitter< 1 %
- IF Switch< 1 %
- Table View (JavaScript)< 1 %
- Reference Column Filter< 1 %
- DB Query< 1 %
- Numeric Scorer< 1 %
- Reference Row Splitter< 1 %
- Math Formula (Multi Column)< 1 %
- Date&Time Shift< 1 %
- Double to Integer< 1 %
Joiner< 1 %- String Replacer< 1 %
- Variable Loop End< 1 %
- Snowflake Connector< 1 %
- Table Editor (JavaScript)< 1 %
- Python Script (legacy)< 1 %
- Row Sampling< 1 %
- Top k Row Filter< 1 %
- Parallel Chunk Start< 1 %
- DB Query Extractor< 1 %
Excel Sheet Appender (XLS)< 1 %- Python Source (legacy)< 1 %
- Data Explorer< 1 %
- Missing Value (Apply)< 1 %
- End IF< 1 %
- Date&Time to legacy Date&Time< 1 %
- Row Splitter (Labs)< 1 %
- CASE Switch Start< 1 %
- Merge Variables< 1 %
- Counter Generation< 1 %
- Date&Time Widget< 1 %
- Partitioning< 1 %
- Round Double< 1 %
- Amazon Redshift Connector< 1 %
- H2 Connector< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Date< 1 %
- Add Empty Rows< 1 %
- CASE Switch End< 1 %
- Parquet Reader< 1 %
- Path to String< 1 %
- Table to JSON< 1 %
- Breakpoint< 1 %
- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Row Filter (Labs)< 1 %
- Hive Connector< 1 %
- DB Table Selector< 1 %
- SAS7BDAT Reader< 1 %
Excel Writer (XLS)< 1 %- Python Edit Variable (legacy)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
- String to Date/Time (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Writer< 1 %- CSV Writer< 1 %
- Recursive Loop Start< 1 %
Recursive Loop Start< 1 %- Timer Info< 1 %
- Parallel Chunk End< 1 %
- Active Branch Inverter< 1 %
- Data Generator< 1 %
- Strings to Binary Objects< 1 %
Database Reader< 1 %- Case Converter< 1 %
Cell Replacer< 1 %- Nominal Value Row Filter< 1 %
- Google BigQuery Connector< 1 %
- Google Sheets Reader< 1 %
- String to JSON< 1 %
Python Script (1⇒1)< 1 %- XPath< 1 %
- Table Column to Variable< 1 %
CSV Reader< 1 %CSV Writer< 1 %Table Reader< 1 %- Column Merger< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Cache< 1 %
- Variable Creator< 1 %
- Cell Splitter< 1 %
- Unpivot< 1 %
- DB Looping< 1 %
Table Row To Variable Loop Start< 1 %File Reader< 1 %- Column Combiner< 1 %
- Column Name Extractor< 1 %
- Create Table Structure< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
- Extract Table Dimension< 1 %
- Spark to Table< 1 %
- DB Connection Table Writer< 1 %
- DB Table Remover< 1 %
- Empty Table Creator< 1 %
Excel Reader (XLS)< 1 %- String Configuration< 1 %
- JSON to Table< 1 %
- Modify Time< 1 %
- Variable to Table Column< 1 %
- Group Loop Start< 1 %
- Recursive Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- DB Transaction End< 1 %
- Java Snippet Row Filter< 1 %
- Tika Parser< 1 %
- Container Output (Table)< 1 %
- Extract Date&Time Fields< 1 %
- Modify Time Zone< 1 %
- Window Loop Start< 1 %
- R to Table< 1 %
- Create Collection Column< 1 %
- Call Workflow Service< 1 %
- DB Table Exists IF Switch< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- Rank< 1 %
- String Manipulation (Variable)< 1 %
Python Script (1⇒2)< 1 %- XGBoost Predictor< 1 %
- Reference Column Splitter< 1 %
- Try (Variable Ports)< 1 %
- Inject Variables (Data)< 1 %
Line Reader< 1 %Counting Loop Start< 1 %Concatenate (Optional in)< 1 %- Column Aggregator< 1 %
CASE Switch Data (Start)< 1 %- Vertica Connector< 1 %
Read Excel Sheet Names (XLS)< 1 %- JSON Path< 1 %
JSON Reader< 1 %- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- PNGs to Binary Objects< 1 %
- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
- Nominal Value Row Splitter< 1 %
- Regex Split< 1 %
CASE Switch Variable (End)< 1 %- List Files/Folders< 1 %
- Java Snippet (simple)< 1 %
- XML To Table< 1 %
- Catch Errors (Var Ports)< 1 %
Database Connection Table Writer< 1 %Table Writer< 1 %Generic Loop Start< 1 %- Column Comparator< 1 %
- Category to Number< 1 %
Column Appender< 1 %Excel Reader (XLS)< 1 %- Date&Time Input (legacy)< 1 %
- Tess4J< 1 %
- Database Table Exists IF Switch (Flow Variable Output) (Legacy)< 1 %
Flow Variable End IF< 1 %Simple File Reader< 1 %- k-Means< 1 %
- Send Email< 1 %
Microsoft SQL Server Connector< 1 %- Transfer Files (Table)< 1 %
- Integer Configuration< 1 %
- JSON Transformer< 1 %
- MongoDB Reader< 1 %
- PMML to Cell< 1 %
- Test Data Generator< 1 %
- Column to XML< 1 %
- String-to-Type< 1 %
- Reference Database Table Exists IF Switch (Legacy)< 1 %
- Type< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Benchmark Start< 1 %
- MolConverter< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Files to Binary Objects< 1 %
- List Remote Files (legacy)< 1 %
Variable to Table Column< 1 %Variable to Table Row< 1 %Variable to Table Row< 1 %Database Delete< 1 %Database SQL Executor< 1 %Database Table Creator< 1 %List Files< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Recursive Loop End< 1 %- MultiLayerPerceptron Predictor< 1 %
- String to Number (PMML)< 1 %
- Reference Column Resorter< 1 %
String Replace (Dictionary)< 1 %- Rule-based Row Filter (Dictionary)< 1 %
CASE Switch Variable (Start)< 1 %CASE Switch Data (End)< 1 %- Extract Table Spec< 1 %
Merge Variables< 1 %- Crosstab< 1 %
- DB Type Mapper< 1 %
- DB Connection Closer< 1 %
DB Loader< 1 %- DB Column Rename< 1 %
- Java IF (Table)< 1 %
- Google Analytics Query (legacy)< 1 %
- Column Filter Configuration< 1 %
- Single Selection Configuration< 1 %
- Parameter Optimization Loop Start< 1 %
- Fail in execution< 1 %
- String to XML< 1 %
- XSLT< 1 %
Date Extractor< 1 %- Date Extractor< 1 %
- Google Address Geocoder< 1 %
- Coordinate to Latitude/Longitude< 1 %
Database IF Switch< 1 %- Run Garbage Collector< 1 %
- Random Numbers Generator< 1 %
- Table to String< 1 %
- Variable to Credentials< 1 %
- ARFF Reader< 1 %
- Line Reader< 1 %
- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %Variable Loop End< 1 %- One to Many< 1 %
- Column Filter (PMML)< 1 %
- Table Difference Finder< 1 %
- Create Temp Dir (legacy)< 1 %
- Create Databricks Environment< 1 %
- SDF Reader< 1 %
- Conditional Label Assigner< 1 %
- Random Label Assigner< 1 %
- PMML Predictor< 1 %
- SharePoint Online List Reader< 1 %
- RegEx Filter< 1 %
- RSS Feed Reader< 1 %
- Bag Of Words Creator< 1 %
- Compress Files/Folder< 1 %
- Transfer Files< 1 %
- String Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Value Selection Widget< 1 %
- JSON Schema Validator< 1 %
- Columns to JSON< 1 %
- JSON to XML< 1 %
- Kafka Consumer< 1 %
Python Script (2⇒1)< 1 %- Salesforce Simple Query< 1 %
- String to Duration< 1 %
- Moving Average< 1 %
- XGBoost Predictor (Regression)< 1 %
XML Reader< 1 %- Fingerprints< 1 %
- Hash Calculator< 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 133 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.