Database Connector

Options

Connection settings

Database Driver

Enter the database driver here; it is a Java class (including the package path). Additional driver can be registered via KNIME's preference page (Database Driver).

Database URL

Enter the database name here, for example jdbc:mysql://host:port/database_name

Workflow Credentials

If checked, the credentials (user and password) are used as defined on the workflow. The credential name links to the specified user and password. Those can be replaced or edit using the 'Workflow Credentials' menu available in the workflow context menu.

User Name

Your log-in user name for the database.

Password

Your log-in password for the database. Note, the password is de- and encrypted before handling it internally.

TimeZone

Select the TimeZone to convert the date, time or timestamp field into. The current implementation can't represent time zones. In order to support persisting those fields into a database, the time values can be changed according to the selected time zone, which is used as the offset (including the daylight saving time) for the original values: No Correction (use UTC) is used for workflows (created before 2.8) and doesn't apply any correction, Use local TimeZone uses the local time zone offset to correct the date field before reading or writing, and TimeZone: allows selecting the time zone to covert the date values into.

Allow spaces in column names

Check this option if the database can handle spaces in column names. Otherwise KNIME will replaces them by underscores.

Validate connection on close

Check this option if you want to validate the connection when closing the dialog.

Retrieve metadata in configure

This option controls subsequent nodes. Usually when a database node is configured it retrieves the metadata of the current table or query from the database for usage in subsequent nodes. If metadata retrieval takes quite some time it will slow down workflow configuration and execution noticeably, especially since metadata is retrieved in both configure and execute. In such cases it's better to switch this option off and only retrieve metadata during execute.

Advanced

Database Type

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.

Views

This node has no views

Workflows

• 01-FIRST_projectKNIME Hub
• 01-MaCProQCKNIME Hub
• 03_crea_persona_buscaKNIME Hub
• 09_Teradata_Aster_meets_KNIME_TableKNIME Hub
• Base GeneralKNIME Hub
• Show all 16 workflows

Links

• Driver.class in MarkLogic driver is only recognised by legacy connectorby JanDuo on 2020-09-08

  forum.knime.com/p/102196
• Database query node: problem with “create” commandby mlauber71 on 2019-06-21

  forum.knime.com/p/62685

Developers