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.
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.Try NodePit Runner!
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 firstname.lastname@example.org, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.