This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
This node creates a connection to an arbitrary JDBC database. You need to select an appropriate driver (if not available, add your vendor-specific driver under File > Preferences > KNIME > Database Driver) and the JDBC URL of the database (which is database specific). Login credentials can either be provided directly in the configuration or via credentials set on the workflow.
This option allows you to explicitly define the type of database the node connects to. Depending on the database type the sql dialect, the supported data types and functions such as insert, update and delete as well as the aggregation functions might differ.
The standard option is '<based on database URL>' where the database type is determined automatically based on the first part of the database URL. However some databases such as Hive and Impala share the same url schema but have different SQL dialects as well as offer different functionality e.g. different sets of aggregation functions. For these databases you have to manually select the appropriate type from the list of supported databases.
If your database type is not listed either select the '<based on database URL>' option or the 'default' option, which uses standard sql syntax and basic aggregation functions. The 'default' type is also used if the url is unknown.
You can always verify the database type via the 'Connection' tab of the nodes database out port.
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 KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:
A zipped version of the software site can be downloaded here.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to email@example.com, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.