DB Connection Comparator

This node provides options to test database connection ports for equality

Options

Both ports of same type: Are both ports of the same type? (The node accepts both database port types)
Compare Drivers: Check whether the same drivers are being used
Compare URL: Check the database connection URLs are the same
Compare Username: Check the same usernames are being used
Compare Database Type: Check the database types (e.g. Postgres, Oracle etc) are the same
Compare SQL: Check the SQL is the same. Only applicable to DatabasePortObjects (the brown DB ports!)
Ignore comments in SQL: An attempt will be made to ignore comments in the SQL when performing SQL comparison. Only available when SQL comparison is being performed
Compare Table Specs: Check the table specs of the port the same. Only applicable to DatabasePortObjects (the brown DB ports!)

This node has no output ports

This node has no views

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

To use this node in KNIME, install the extension Vernalis KNIME Nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: Vernalis Research, UK

Plugin version: 1.36.7.v202405281205

On NodePit since: 2024-07-11

Last update: 2024-11-21

KNIME versions: v5.3, v5.2, v5.1, v4.7, v4.6, v4.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.