JDBC Driver Connection Details

The following sections define the connection information required when defining a new JDBC driver for a database connection profile.

For complete information, refer to the documentation accompanying a specific driver.

SQL Server

Field Description
Database The name of the database that you want to connect to.
Host The IP address or host name where the database is located.
Port number The port used to access the database.
Use integrated authentication Whether the database uses Windows authentication or SQL Server authentication.

If this checkbox is selected the User name, Password and Save password fields are disabled.
User name The SQL Server login used by the connection.
Password The password for the SQL Server login used by the connection.
Save password Whether the password is saved. If not, the password must be entered on every connection attempt.
Connection URL The connection URL. This is built up automatically from the connection information entered in the other fields.

Oracle

Field Description
SID The SID of the database that you want to connect to.
Host The IP address or host name where the database is located.
Port number The port used to access the database.
User name The Oracle user name used by the connection.
Password The password for the Oracle user name used by the connection.
Save password Whether the password is saved. If not, the password must be entered on every connection attempt.
Connection URL The connection URL. This is built up automatically from the connection information entered in the other fields.
Catalog The name of the catalog containing the database that you want to connect to.

DB2

Field Description
Database The name of the database that you want to connect to.
Host The IP address or host name where the database is located.
Port number The port used to access the database.
Use client authentication Whether the database uses client authentication or server authentication.

If this checkbox is selected the User name, Password and Save password fields are disabled.
User name The DB2 user name used by the connection.
Password The password for the DB2 user name used by the connection.
Save password Whether the password is saved. If not, the password must be entered on every connection attempt.
Connection URL The connection URL. This is built up automatically from the connection information entered in the other fields.