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 Predecessors
- Excel Reader5 %
- Column Filter4 %
Column Rename4 %- Joiner4 %
- Microsoft SQL Server Connector3 %
Row Filter (deprecated)3 %- DB Table Creator3 %
- DB SQL Executor3 %
- Concatenate3 %
- CSV Reader3 %
- GroupBy3 %
- Column Resorter3 %
- Duplicate Row Filter3 %
- String to Date&Time2 %
- DB Query Reader2 %
- String Manipulation2 %
- DB Reader2 %
- DB Connector2 %
- PostgreSQL Connector2 %
- Rule Engine2 %
- Table Creator2 %
- String to Number2 %
- Rule-based Row Filter2 %
- Column Expressions1 %
- Constant Value Column1 %
- SQLite Connector1 %
- DB Writer1 %
- Missing Value1 %
- Column Renamer1 %
- Math Formula1 %
- MySQL Connector1 %
- Table Manipulator1 %
- Sorter< 1 %
- Number to String< 1 %
- File Reader< 1 %
- Cross Joiner< 1 %
- DB Delete (Filter)< 1 %
- Loop End< 1 %
Row Splitter (deprecated)< 1 %- Microsoft Access Connector< 1 %
- Date&Time to String< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Loader< 1 %
- Chunk Loop Start< 1 %
- Reference Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Oracle Connector< 1 %
- Column Auto Type Cast< 1 %
- DB Update< 1 %
- DB Insert< 1 %
- Snowflake Connector< 1 %
- Excel Writer< 1 %
- Modify Time< 1 %
- RowID< 1 %
- DB Table Remover< 1 %
- Date&Time-based Row Filter< 1 %
Variable to Table Column< 1 %- Row Splitter (Labs)< 1 %
- Date&Time Part Extractor< 1 %
- Empty Table Creator< 1 %
- Date&Time Shift< 1 %
- Number Rounder< 1 %
- DB Delete (Table)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Column Renamer (Dictionary)< 1 %
- Nominal Value Row Filter< 1 %
- Pivot< 1 %
- String Replacer< 1 %
- Column Appender< 1 %
- Modify Time Zone< 1 %
- Table Reader< 1 %
- H2 Connector< 1 %
- Empty Table Switch< 1 %
- Top k Row Filter< 1 %
- DB Connection Extractor< 1 %
- Table Editor (JavaScript)< 1 %
- Java Snippet< 1 %
- Statistics< 1 %
- Table Row to Variable< 1 %
- Column Combiner< 1 %
- String Manipulation (Variable)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Wait...< 1 %
File Reader< 1 %- SAS7BDAT Reader< 1 %
- CSV Writer< 1 %
Excel Writer (XLS)< 1 %- Table View (JavaScript)< 1 %
- Python Script (legacy)< 1 %
- Parquet Reader< 1 %
Joiner< 1 %- IF Switch< 1 %
- JSON to Table< 1 %
- Variable to Table Column< 1 %
- Reference Column Filter< 1 %
- Row Sampling< 1 %
- Parallel Chunk Start< 1 %
- Column Merger< 1 %
- Math Formula (Multi Column)< 1 %
- Modify Date< 1 %
- Variable to Table Row< 1 %
- Merge Variables< 1 %
Excel Writer (XLS)< 1 %- Salesforce Simple Query< 1 %
- File Meta Info (legacy)< 1 %
- Scorer< 1 %
- Google Sheets Reader< 1 %
- Python Source (legacy)< 1 %
- File Reader (Complex Format)< 1 %
- Extract Table Spec< 1 %
Variable to Table Column< 1 %Cell Replacer< 1 %- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (End)< 1 %- String Input (legacy)< 1 %
- R Snippet< 1 %
Variable to Table Row< 1 %Variable Condition Loop End< 1 %- Case Converter< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Amazon Redshift Connector< 1 %
- Google BigQuery Connector< 1 %
- String Configuration< 1 %
Python Script (1⇒1)< 1 %- R to Table< 1 %
- Time to String (legacy)< 1 %
- Add Empty Rows< 1 %
- Table Validator< 1 %
- Path to String< 1 %
- DB Data Spec Extractor< 1 %
- Upload (legacy)< 1 %
Database SQL Executor< 1 %- Numeric Scorer< 1 %
- Column Name Extractor< 1 %
- Reference Row Splitter< 1 %
- String to Number (PMML)< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
CASE Switch Data (Start)< 1 %- DB Type Mapper< 1 %
- Parameterized DB Query Reader< 1 %
- DB Table Selector< 1 %
- XPath< 1 %
- Send Email< 1 %
- Column Selection Configuration< 1 %
- Boolean Configuration< 1 %
- Download (legacy)< 1 %
- Strings to Binary Objects< 1 %
Database Delete< 1 %SQL Extract< 1 %Table Reader< 1 %Table Writer< 1 %- Random Forest Predictor< 1 %
Concatenate (Optional in)< 1 %- Numeric Binner< 1 %
- Cell Splitter< 1 %
- Set Operator< 1 %
- Unpivot< 1 %
- End IF< 1 %
- Data Generator< 1 %
- Impala Connector< 1 %
- DB Connection Closer< 1 %
- DB Query Extractor< 1 %
DB Table Creator< 1 %- Scatter Plot (JavaScript)< 1 %
- Create Date&Time Range< 1 %
- Catch Errors (Generic Ports)< 1 %
- Table Column to Variable< 1 %
- Variable Creator< 1 %
- Table Difference Finder< 1 %
- Amazon Athena Connector< 1 %
- SharePoint Online List Reader< 1 %
- Container Input (Table)< 1 %
SAP Reader (Theobald Software)< 1 %- String to XML< 1 %
- Refresh Button Widget< 1 %
- Linear Correlation< 1 %
- PNN Predictor< 1 %
- Call Workflow Service< 1 %
- Anonymization< 1 %
- URL to File Path (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %CSV Reader< 1 %CSV Writer< 1 %Database Reader< 1 %- Fixed Width File Reader< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %- Group Loop Start< 1 %
Recursive Loop End< 1 %- Decision Tree Predictor< 1 %
- Column Aggregator< 1 %
- Create Table Structure< 1 %
- Table Validator (Reference)< 1 %
- Double to Integer< 1 %
- Nominal Value Row Splitter< 1 %
- Number to String (PMML)< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
- Cache< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Dimension< 1 %
- Timer Info< 1 %
- PMML to SQL< 1 %
- Hive Connector< 1 %
- Spark to Table< 1 %
- Vertica Connector< 1 %
- DB Connection Table Writer< 1 %
- DB Merge< 1 %
- DB Query< 1 %
- DB Transaction End< 1 %
- DB Transaction Start< 1 %
- Counter Generation< 1 %
- Variable Expressions< 1 %
Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %- Java Snippet (simple)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Column Filter (legacy)< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
- R Snippet< 1 %
- Date&Time Difference< 1 %
- UNIX Timestamp to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- Remove Empty Rows< 1 %
- Binary Objects to PNGs< 1 %
- PNGs to Binary Objects< 1 %
- Active Branch Inverter< 1 %
Simple File Reader< 1 %Counting Loop Start< 1 %- Variable Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Linear Regression Learner< 1 %
- Filter Apply< 1 %
- Create Databricks Environment< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- List Files/Folders< 1 %
- Transfer Files< 1 %
- JSON Writer< 1 %
- JSON to XML< 1 %
- GET Request< 1 %
- Value Filter (legacy)< 1 %
- JSON Transformer< 1 %
- Recursive Loop End< 1 %
- Generic Loop Start< 1 %
- CASE Switch Start< 1 %
- Create Collection Column< 1 %
- Counting Loop Start< 1 %
- DB Row Manipulator< 1 %
- Row to Column Names< 1 %
- R Source (Table)< 1 %
- Numeric Row Splitter< 1 %
- CASE Switch End< 1 %
- Transfer Files (Table)< 1 %
- Tableau Writer< 1 %
- Moving Aggregator< 1 %
- Table Splitter< 1 %
- Create File Name (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %- k-Means< 1 %
- Missing Value (Apply)< 1 %
- Random Number Assigner (Apache)< 1 %
- PMML Predictor< 1 %
- Date&Time Input (legacy)< 1 %
Extract Date&Time Fields< 1 %IF Switch (Flow Variable Value)< 1 %- Benchmark End< 1 %
- URL Decode< 1 %
Database Table Creator< 1 %Parquet Reader< 1 %- Create Local Big Data Environment< 1 %
- Capture Workflow End< 1 %
- Java IF (Table)< 1 %
Database Connection Table Reader< 1 %- Cluster Assigner< 1 %
- Create Bit Vector< 1 %
- Category to Number< 1 %
Column Appender< 1 %- Denormalizer< 1 %
Merge Variables< 1 %- Column Selection (legacy)< 1 %
- List Box Widget< 1 %
- Fail in execution< 1 %
- Collection to String< 1 %
- Random Numbers Generator< 1 %
Interval Loop Start< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- Random Matcher< 1 %
- Duration to Number< 1 %
- Extract URI Info< 1 %
Database Drop Table< 1 %- Auto-Binner< 1 %
- Rule Engine (Dictionary)< 1 %
- Model to Cell< 1 %
- Dictionary Replacer (File-based)< 1 %
- Date&Time Widget< 1 %
- XML to JSON< 1 %
- Rotation 2D< 1 %
Python Script (1⇒2)< 1 %- Mask Date/Time (legacy)< 1 %
- Twitter Search< 1 %
- Twitter Users< 1 %
- RDKit Descriptor Calculation< 1 %
- Database Table Exists IF Switch (Flow Variable Output) (Legacy)< 1 %
- Reference Database Table Exists IF Switch (Legacy)< 1 %
- X-Aggregator< 1 %
- Hierarchical Clustering< 1 %
- PMML Gradient Boosted Trees Predictor< 1 %
- One to Many< 1 %
- Read Excel Sheet Names< 1 %
- Google Analytics Query (legacy)< 1 %
Regex Extractor< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Generic Run-to-time Loop Start< 1 %
- Run Garbage Collector< 1 %
- Missing to Empty Collection< 1 %
- Trim Table< 1 %
PDB Connector XML Query Builder< 1 %- PDB Downloader< 1 %
- Matlab Snippet< 1 %
- MolConverter< 1 %
- Labeling View< 1 %
- Split Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- Breakpoint< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
- Extract Variables (Database)< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Database Update< 1 %Database Looping< 1 %Line Reader< 1 %Line Reader< 1 %List Files< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %Generic Loop Start< 1 %Variable Loop End< 1 %- Naive Bayes Predictor< 1 %
- DBSCAN< 1 %
- Decision Tree Learner< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Logistic Regression Predictor< 1 %
- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Lag Column< 1 %
- CAIM Binner< 1 %
- String Splitter (Regex)< 1 %
- Rule Engine Variable< 1 %
- Ruleset Predictor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers< 1 %
CASE Switch Variable (Start)< 1 %- Color Manager< 1 %
Parquet Reader< 1 %- Parallel Chunk End< 1 %
DB Loader< 1 %- DB Column Rename< 1 %
- DB Row Filter< 1 %
- DB GroupBy< 1 %
- One Row to Many< 1 %
- Index Query< 1 %
- TF< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- String to Term< 1 %
- Term to String< 1 %
Column Filter Configuration< 1 %- Text Output (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Value Selection Widget< 1 %
Container Input (Variable)< 1 %JSON Reader< 1 %- Parameter Optimization Loop End< 1 %
Python Script (2⇒2)< 1 %- Extract Duration Fields< 1 %
- Date Field Extractor (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
XML Reader< 1 %- Type< 1 %
- Memory Use< 1 %
- Model to Binary Object< 1 %
- String to URI< 1 %
Catch Errors (DB Ports)< 1 %- Extract Variables (Data)< 1 %
- Feature Selection Filter< 1 %
Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
- Expand Bit Vector< 1 %
- Category to Number (Apply)< 1 %
- Extract Missing Value Cause< 1 %
- Renderer to Image< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Model (End)< 1 %- Interactive Table (legacy)< 1 %
- SDF Reader< 1 %
- DB Column Filter< 1 %
- H2O to Table< 1 %
- Excel Cell Updater< 1 %
- Case Converter< 1 %
- Dictionary Replacer< 1 %
- String to Path (Variable)< 1 %
- Nominal Row Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- Columns to JSON< 1 %
Python Script (2⇒1)< 1 %- POST Request< 1 %
- Duration to String< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- XGBoost Predictor< 1 %
- XML Column Combiner< 1 %
- RDKit Calculate Charges< 1 %
- RDKit From Molecule< 1 %
- RDKit To Molecule< 1 %
- Feed Parser< 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 875 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.