KNIME Table Connector

Creates a SQL table for the supplied KNIME data table.

This allows the KNIME data table to be used with SQL via the knime DB nodes.


KNOWN LIMITATIONS
Column names must be compatible with an H2 SQL database. Where the column name contains spaces, this will be handled by converted to underscores for processing in the database. Column names must consist of Alphanumerics and underscores, and must not start with a numeric. Column names containing other characters will most likely fail.


v1.0 2023-07-07 @takbb Brian Bates

Input ports

1. Type: DB Session
   Database Connection
   Database connection. Typically it is intended that an H2 database be used for local data manipulation, as this will work with the index creation scripts. Other db connections may not be compatible with the internal scripts used by this component.
2. Type: Table
   Data Table
   Table containing data to be included in the database table

Output ports

1. Type: Table
   Database table data throughport
   The input table as it appears on the database. The column names on this table represent any changes to column names to make them compliant with SQL column names. Use this as the reference for column names when writing the SQL
2. Type: DB Data
   Database Data
   A database data port onto the idatabase allowing in-database nodes to be connected
3. Type: DB Session
   DB Session
   DB Session through-port for connecting to other table connectors