Connection Settings

Basic settings

Here is where you may specify connection settings and properties.

Some properties are required, others are optional.

List of standard settings:

JDBC URL Database URL. This field is editable only if the database driver doesn't have sample URL. Otherwise its value will be automatically changed whene you change other connection settings.
Host Database host name
Port Database port number. Usually this field is optional. If left blank then the default database port will be used.
Database/Schema Name of remote database/schema.
Server Name of remote server.
User name/password User credentials. May be left blank for some drivers (e.g. for embedded databases)

Advanced settings

The database driver may support additional connection settings. Users may view a list of all available properties on the "Advanced" tab. All properties are editable.

Some drivers support additional properties but don't provide a list of them. In this case you may find a list of available properties in driver's documentation. After reviewing the driver's documentation you may specify any number of properties under the "User Properties" element. Right click on it and choose the "Add new property" menu item.