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)

Find here

Database > Read/Write

Make sure to have this extension installed: