Database Reader

Source

Establishes and opens a database access connection to read data from.

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: Database Connection An optional database connection that should be used instead of providing the connection information in the dialog. (optional)

Output Ports

  1. Type: Data Table with data read from the database

Find here

Database > Read/Write

Make sure to have this extension installed: