Hub

16 results

Filter
Filter by tag
DB
Databases
Community Nodes Vernalis
  1. Node / Manipulator
    DB DISTINCT
    Community Nodes Vernalis Databases
    +1
    This node performs a 'DISTINCT' operation on the selected column(s), such that only 'distinct' combinations of column values are …
    0
    vernalis
  2. Node / Other
    DB Extract Table Dimension
    Community Nodes Vernalis Databases
    +1
    This node extracts the table dimension from a Database Query Connection. Row count is obtained during node execution by running a…
    0
    vernalis
  3. Node / Manipulator
    DB Insert Column Header
    Community Nodes Vernalis Databases
    +1
    This node renames the output columns of a database connection based on the values in a reference table. The underlying database i…
    0
    vernalis
  4. Node / Manipulator
    DB List Catalogues
    Community Nodes Vernalis Databases
    +2
    This node lists any catalogues for the selected database This node was developed by Vernalis Research . For feedback and more inf…
    0
    vernalis
  5. Node / Manipulator
    DB List Foreign Keys
    Community Nodes Vernalis Databases
    +2
    This node lists any foreign key columns for the selected database table This node was developed by Vernalis Research . For feedba…
    0
    vernalis
  6. Node / Manipulator
    DB List Primary Keys
    Community Nodes Vernalis Databases
    +2
    This node lists any primary key columns for the selected database table This node was developed by Vernalis Research . For feedba…
    0
    vernalis
  7. Node / Manipulator
    DB List Schemas
    Community Nodes Vernalis Databases
    +2
    This node lists any schemas for the selected database This node was developed by Vernalis Research . For feedback and more inform…
    0
    vernalis
  8. Node / Manipulator
    DB List Table Types
    Community Nodes Vernalis Databases
    +2
    This node lists any available Table Types for the selected database This node was developed by Vernalis Research . For feedback a…
    0
    vernalis
  9. Node / Manipulator
    DB List Tables
    Community Nodes Vernalis Databases
    +2
    This node lists any available tables for the selected database This node was developed by Vernalis Research . For feedback and mo…
    0
    vernalis
  10. Node / Manipulator
    DB Numeric Range
    Community Nodes Vernalis Databases
    +1
    This nodeperforms MIN() and MAX() operations on the selected numeric column(s). This node was developed by Vernalis Research . Fo…
    0
    vernalis
  11. Node / Source
    DB Remove SQL From connection
    Community Nodes Vernalis Databases
    +1
    The node strips the empbedded SQL statement(s) out of a database connection, leaving only the authenticated database connection T…
    0
    vernalis
  12. Node / Manipulator
    DB Select Table (Interactive)
    Community Nodes Vernalis Databases
    +1
    The user can select the table type, schema name and table name. The dropdowns are re-populated dynamically on changing a selectio…
    0
    vernalis
  13. Node / Source
    DB Table Exists IF Switch
    Community Nodes Vernalis Databases
    +1
    IF Switch node with active branch based on whether the database connection contains the specified table This node was developed b…
    0
    vernalis
  14. Node / Manipulator
    DB To Empty Table
    Community Nodes Vernalis Databases
    +2
    This node generates an empty KNIME table with the columns in a database query connection. The database itself is not accessed to …
    0
    vernalis
  15. Node / Other
    DB To Variable
    Community Nodes Vernalis Databases
    +1
    This node converts a database connection listing the driver, database type, user name, JDBC URL if present This node was develope…
    0
    vernalis
  16. Node / Source
    Reference DB Table Exists IF Switch
    Community Nodes Vernalis Databases
    +1
    IF Switch node with active branch based on whether the database connection contains the specified table. The output is switched b…
    0
    vernalis