Database Writer

Sink

Establishes and opens a database access connection to which the entire input table is written to.

If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.

Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver). By default, the sun.jdbc.odbc.JdbcOdbcDriver (Windows and Linux) is only available.

Input Ports

  1. Type: Data Table with data to write into database
  2. Type: Database Connection An optional database connection that should be used instead of providing the connection information in the dialog. (optional)

  1. Database Sampling

    This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also suppor…
    Examples > 01_Data_Access > 02_Databases

  2. Working with databases with the Python Script (DB) node

    This workflow demonstrates the usage of the Python Script (DB) node that allows you to access data from a database direc…
    Examples > 07_Scripting > 03_Python

  3. Database Pivot

    This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your …
    Examples > 01_Data_Access > 02_Databases

  4. Database - Simple IO

    Demonstrates using Database Reader and Database Writer nodes in a simple KNIME worflow.
    Examples > 01_Data_Access > 02_Databases

  5. Model Deployment SQL Recoding

    Deployment File Database SQL Recoding PMML Java Model Prediction
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from database, re…
    Examples > 50_Applications > 27_Deployment_Options

  6. Snowflake meets Tableau

    snowflake data warehouse Hyper Tableau KNIME
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales …
    Examples > 01_Data_Access > 02_Databases

  7. MMP Databased Example with Fingerprint Databasing

    Matched Molecular Pairs MMP MMPA Fingerprint Database
    This is a more complex Matched Molecular Pairs (MMP) example, in which we demonstrate storing fragmentations and transfo…
    Examples > 99_Community > 04_Vernalis

  8. Model Deployment File to Database (Scheduling)

    Deployment File Database Scheduling Model Prediction
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from file, scores…
    Examples > 50_Applications > 27_Deployment_Options

  9. Will they blend? Twitter and PostGreSQL Database

    data blending database PostGreSQL Twitter
    This is a mini-workflow for Data WareHousing, in particular it archiviates daily tweets.History is saved in a PostGreSQL…
    Examples > 08_Other_Analytics_Types > 04_Social_Media

  10. Databases - Advanced Usage

    Shows a KNIME workflow with a number of database nodes that directly work inside a database. Note, this flow uses the sq…
    Examples > 01_Data_Access > 02_Databases

Find here

Database > Read/Write

Make sure to have this extension installed: