Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • DB Insert
NodeNode / Sink

DB Insert

DB Read/Write Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Data to insert into the database
    KNIME data table with the data rows to be inserted into the database.
  2. Type: DB Session
    DB Connection
    DB Connection to the database.
Output ports
  1. Type: Table
    Input Data with Insert Status
    Input KNIME data table with additional columns providing the number of affected rows in the database and warnings, if checked in the dialog.
  2. Type: DB Data
    DB Data
    DB Data referencing the selected database table.

Extension

The DB Insert node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    POSICAO CARTEIRA_2
    gabrieleneves86 > Public > POSICAO CARTEIRA_2
  2. Go to item
    Working with JSON columns in PostgreSQL
    JSON Db PostgreSQL
    +1
    This workflow demos how to write and read PostgreSQL JSON columns from within the KNIME A…
    tobias.koetter > Public > DB > PostgreSQL > PostgresJSON
  3. Go to item
    demo_db_migration
    mraraman > Public > demo_db_migration
  4. Go to item
    demo_db_migration
    mraraman > VSR Workflows > adhocs > demo_db_migration
  5. Go to item
    01 Practicing with Traditional Databases - Solution
    Big data Database
    Solution to an L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipul…
    knime > Education > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 01 Practicing with Traditional Databases - Solution
  6. Go to item
    10 - Billing - CargaInicial
    josecarlosmagno > Public > 10 - Billing - CargaInicial
  7. Go to item
    Conditional insert into database table
    Life Science Cheminformatics Database
    +1
    This workflow demonstrates how to do update an existing database table with new entries (…
    alice_krebs > Public > Conditional insert into a database table
  8. Go to item
    01 Practicing with Traditional Databases - Solution
    Big data Database
    Solution to an L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipul…
    tqthanh168 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 01 Practicing with Traditional Databases - Solution
  9. Go to item
    01 Practicing with Traditional Databases - Solution
    Big data Database
    Solution to an L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipul…
    halverdog > Public > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 01 Practicing with Traditional Databases - Solution
  10. Go to item
    01 Practicing with Traditional Databases - Solution
    Big data Database
    Solution to an L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipul…
    manuel1972 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Solutions > 01 Practicing with Traditional Databases - Solution
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits