Inserts data rows into the database based on the selected columns from the input table.
If the database table does not exist it will be created by the node prior inserting the values. The new table will have a column for each input KNIME column. The database column name will be the same as the name of the input KNIME column. The database type is derived from the given KNIME type based on the output type mapping rules specified in the "Output Type Mapping" tab. All database columns will allow missing values (NULL). Please use the DB Table Creator node if you want to control the properties of the created database table.
If the table already exists in the database all selected column names need to exactly match the column names within the database table.
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 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 Executor5 %
- DB Writer4 %
- DB Query Reader4 %
- Variable Loop End4 %
- DB Reader4 %
- DB Connection Closer3 %
- DB Update3 %
- DB Joiner3 %
- DB Query3 %
- GroupBy3 %
- DB Connection Extractor3 %
- Joiner2 %
- Loop End2 %
- Save Workflow2 %
- Excel Writer2 %
- CSV Writer2 %
- Column Filter2 %
- DB Insert1 %
- Microsoft SQL Server Connector1 %
- Merge Variables1 %
Row Filter (deprecated)1 %- DB GroupBy1 %
- Timer Info1 %
- DB Loader1 %
- End IF< 1 %
- DB Row Filter< 1 %
- Send Email< 1 %
Flow Variable End IF< 1 %- Rule-based Row Filter< 1 %
- Transfer Files< 1 %
Column Rename< 1 %- DB Connection Table Writer< 1 %
- DB Connector< 1 %
- List Files/Folders< 1 %
- DB Table Selector< 1 %
- Recursive Loop End< 1 %
- Wait...< 1 %
- String Manipulation< 1 %
- Python Source (legacy)< 1 %
- CASE Switch End< 1 %
- Missing Value< 1 %
- Column Expressions< 1 %
- Value Counter< 1 %
- Variable to Table Row< 1 %
- Concatenate< 1 %
- DB Merge< 1 %
- Table Row to Variable< 1 %
- Capture Workflow End< 1 %
- Parameterized DB Query Reader< 1 %
Loop End (2 ports)< 1 %- Excel Cell Updater< 1 %
- Create Date&Time Range< 1 %
- Duplicate Row Filter< 1 %
- Rule Engine< 1 %
Database Writer< 1 %- DB Delete (Table)< 1 %
- Table View (JavaScript)< 1 %
Loop End< 1 %- Text Output Widget (legacy)< 1 %
CASE Switch Data (End)< 1 %- DB Type Mapper< 1 %
- Load Text Files< 1 %
Row Splitter (deprecated)< 1 %- DB Sorter< 1 %
- Catch Errors (Var Ports)< 1 %
- Cell Splitter< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- String Manipulation (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
- Table Manipulator< 1 %
- Parquet Writer< 1 %
- DB Column Filter< 1 %
- Binary Objects to PNGs< 1 %
- Copy/Move Files (legacy)< 1 %
- Loop End (Column Append)< 1 %
- Column Combiner< 1 %
- Row Sampling< 1 %
- Interactive Table (legacy)< 1 %
- DB Column Rename< 1 %
- DB Concatenate< 1 %
Table to HTML< 1 %Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Excel Reader< 1 %
- R Snippet< 1 %
- String to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- KNIME Server Connector< 1 %
Table Writer< 1 %- Variable Creator< 1 %
Variable Condition Loop End< 1 %- Group Loop Start< 1 %
Variable Loop End< 1 %- String to Number< 1 %
- Nominal Value Row Filter< 1 %
- Row Filter (Labs)< 1 %
Joiner< 1 %- String Manipulation (Multi Column)< 1 %
- Data Explorer< 1 %
- DB to Spark< 1 %
- Oracle Connector< 1 %
DB Loader< 1 %- DB Row Sampling< 1 %
- DB Transaction End< 1 %
Microsoft Authenticator (Deprecated)< 1 %Excel Reader (XLS)< 1 %- Send to Power BI< 1 %
Tableau Writer (Hyper)< 1 %- Send to Tableau Server< 1 %
- JSON Path< 1 %
- Data to Report (BIRT)< 1 %
- File Meta Info (legacy)< 1 %
- Extract Variables (Data)< 1 %
- Table Column to Variable< 1 %
Database Table Creator< 1 %- Table Writer< 1 %
- Chunk Loop Start< 1 %
- Column Appender< 1 %
- Pivot< 1 %
- RowID< 1 %
- Box Plot< 1 %
- Table View< 1 %
- PostgreSQL Connector< 1 %
- DB Looping< 1 %
- DB Auto-Binner< 1 %
- DB Pivot< 1 %
DB Table Creator< 1 %- DB Table Creator< 1 %
- Math Formula (Multi Column)< 1 %
Excel Reader (XLS)< 1 %- Date&Time Configuration< 1 %
- Python Script (legacy)< 1 %
- Call Workflow Service< 1 %
- RDKit From Molecule< 1 %
- Message Slack channel< 1 %
- Breakpoint< 1 %
CSV Writer< 1 %Database SQL Executor< 1 %Database Update< 1 %- CSV Reader< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
- Variable Condition Loop End< 1 %
- k-Means< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Linear Correlation< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply< 1 %
- Reference Row Filter< 1 %
- Sorter< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- CASE Switch Start< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
Merge Variables< 1 %- Color Manager< 1 %
- Parallel Chunk End< 1 %
MySQL Connector< 1 %- MySQL Connector< 1 %
- DB Numeric-Binner< 1 %
- DB Table Remover< 1 %
- DB Query Extractor< 1 %
- Counter Generation< 1 %
- Empty Table Creator< 1 %
- Variable Expressions< 1 %
- Table to HTML (legacy)< 1 %
- Table to H2O< 1 %
- Math Formula< 1 %
- Tableau Writer< 1 %
- Punctuation Erasure< 1 %
- Delete Files/Folders (Table)< 1 %
- String to Path< 1 %
- File Upload Widget< 1 %
- Container Output (Table)< 1 %
- Date&Time Part Extractor< 1 %
- Extract Duration Fields< 1 %
- Date&Time-based Row Filter< 1 %
- Workflow Service Output< 1 %
- String to URI< 1 %
Variable to Table Row< 1 %Database Delete< 1 %- Column Splitter< 1 %
- Rule Engine Variable< 1 %
CASE Switch Model (End)< 1 %- Destroy Spark Context< 1 %
Excel Sheet Appender (XLS)< 1 %Transfer Files< 1 %JSON Writer< 1 %IF Switch (Flow Variable Value)< 1 %Table Column to Variable< 1 %- X-Aggregator< 1 %
- Hierarchical Clustering< 1 %
- Random Forest Learner< 1 %
- Reference Column Filter< 1 %
- Number Rounder< 1 %
CASE Switch Variable (Start)< 1 %- DB Column Rename (Regex)< 1 %
Excel Writer (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Date&Time Input (legacy)< 1 %
- Memory Use< 1 %
- Catch Errors (Generic Ports)< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Table Row to Variable< 1 %Database Reader< 1 %Database Table Selector< 1 %- Java Edit Variable< 1 %
- SOTA Learner< 1 %
- Numeric Binner< 1 %
- Number to String< 1 %
- Column Aggregator< 1 %
- Ungroup< 1 %
- Histogram (legacy)< 1 %
- PMML to SQL< 1 %
- DB Apply-Binner< 1 %
- DB Partitioning< 1 %
XLS Writer< 1 %Send to Power BI< 1 %- Delete Files/Folders< 1 %
- Column Selection (legacy)< 1 %
- Boolean Widget< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Modify Time Zone< 1 %
- Message Slack User< 1 %
Flow Variable IF Switch< 1 %Loop End (Upto 4 ports)< 1 %- Read Variables< 1 %
- Benchmark End (Flow Variable)< 1 %
- Benchmark End< 1 %
- Delete Files (legacy)< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Database Looping< 1 %Database Connector< 1 %- File Reader< 1 %
- Model Writer< 1 %
File Reader< 1 %List Files< 1 %- Generic Loop Start< 1 %
Recursive Loop End< 1 %- Naive Bayes Learner< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Add Empty Rows< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- String to SVG< 1 %
Column Appender< 1 %- Lag Column< 1 %
- Partitioning< 1 %
- Table Transposer< 1 %
- Renderer to Image< 1 %
- Rule Engine (Dictionary)< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Enrichment Plotter (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
Parquet Reader< 1 %- Table to Spark< 1 %
- Parallel Chunk Start< 1 %
- H2 Connector< 1 %
- Microsoft Access Connector< 1 %
- SQLite Connector< 1 %
- DB Transaction Start< 1 %
- External Tool< 1 %
- Snowflake H2O MOJO Predictor (Classification)< 1 %
- Table Indexer< 1 %
- OSM Map View< 1 %
- Java Snippet (simple)< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Connector< 1 %
- Google Sheets Reader< 1 %
- String Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON Row Combiner< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- R Source (Table)< 1 %
- Table to R< 1 %
- POST Request< 1 %
- Legacy Date&Time to Date&Time< 1 %
Views
- This node has no views
Workflows
00_Setup_SQLite_DBKNIME Hub- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- Show all 874 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.