Database Type

Determines one of the following database types to use in the connection profile:

• Oracle
• MSSQL
• DB2
• Sybase
• PostgreSQL

Database Version

Determines the version of the database.

SSL

Determines whether SSL is used to encrypt the connection to a MSSQL database.

You must import the SSL certificate to be able to use SSL.

Host Name

Defines the hostname of the specified database.

Port Number

Defines the port number of the web services server.

use Port

Defines the port number of the database. This option is disabled by default (MSSQL only).

Database Name

Defines the name of the specified database.

MSSQL Authentication

Determines one of the following options as your authentication type:

• SQL Server Authentication: Authenticates the user to the database through an SQL server. This field is only relevant for MSSQL.
• Windows Authentication: Authenticates the user to the database through Windows. This field is only relevant for MSSQL.
• NTLM2 Windows Authentication: Authenticates the user to the database through NTLM2 Windows. This field is only relevant for MSSQL.

Connection Type

Determines one of the following options as your connection type:

• Service Name: Enables you to connect to an Oracle Database with a single service name. To connect to Oracle RAC, you can define the SCAN name in the Host/SCAN Name field to connect all hosts of the RAC to a single address
• SID: Enables you to connect to an Oracle Database by the SID identifier.
• Connection String: Enables you to enter a connection string containing text which exists in your tnsname.ora file that can include multiple host addresses and special attributes.

This field is only relevant for Oracle.

User Name

Define the user name of the specified database.

Password

Defines the password of the specified database.

Confirm Password

Confirms the password of the specified database.

Maximum Concurrent Connections

Determines the maximum number of connections between 1-512 that the database can process at the same time

Connection Retries

Determines the number of connection attempts between 1-24 after a connection failure

Connection retry time out

Determines the time in seconds (1-300) between each connection attempt

Connection idle time

Determines one of the following:

• Disconnect after: Determines the number of seconds that the database connection profile remains idle before disconnecting
• Disconnect immediately if no pending request: Defines the database connection profile to disconnect when idle