Configuration Tab › Mapping for Configuration Browser Tabs › Modules › Databases

Databases

The Databases operator category configuration specifies default property settings for Databases operators of the following database types:

• Oracle
• MSSQL (Microsoft SQL Server)
• MySQL
• Sybase.

Note: For details about configuring default property settings, see "Configure Databases" in the Content Administrator Guide. For operator-level details, see the Content Designer Reference.

Default Oracle Properties

Specifies the database properties when an instance of an Oracle database server hosts one or more CA Process Automation databases.

Driver Type

Specifies the default type of Oracle JDBC driver.

Note: Use a JDBC version that matches the version of the Java Development Kit.

Values: This property can have one of the following values:

• thin - The Thin Driver type is for use on the client-side with no Oracle installation. The Thin driver connects to the Oracle database with Java sockets.
• oci - The OCI Driver type is for use on the client-side with Oracle installed. OCI drivers use the Oracle Call Interface (OCI) for interactions with the Oracle database.
• kprb - The KPRB driver is used for writing Java database stored procedures and triggers.

Default: thin

Driver

Specifies the value oracle.jdbc.OracleDriver as the default driver.

Server Host

Specifies the host where the Oracle database is running.

Server Port

Specifies the default port for the Oracle database.

UserName

Specifies the default user name for the Oracle database user.

Password

Specifies the password that is associated with the specified Default UserName.

ServiceID

Specifies the Oracle Service ID.

TNS Name

Specifies the source of the contents of tnsnames.ora in the Oracle directory. The Oracle TNS Names file translates a local database alias to information that enables connectivity to the database. This information includes information such as the IP address, the port, and the database Service ID.

Maximum Rows

Specifies the default maximum rows to retrieve.

Values: This value can be one of the following:

10 to 512

Default: 10

Client Encryption

Specifies one of the data encryption methods that Oracle supports, where RCA_128 and RCA_256 are for domestic editions only.

Values: This property can have one of the following values:

• RC4_40
• RC4_56
• RC4_128
• RC4_256
• DES40C
• DES56C
• 3DES112
• 3DES168
• SSL
• AES128
• AES256
• AES192

Client Checksum

Specifies checksums that Oracle supports. See your Oracle documentation.

Default: MD5

Default MSSQL Server Properties

Specifies the database properties when an instance of Microsoft SQL Server hosts one or more CA Process Automation databases.

Driver

Specifies com.microsoft.sqlserver.jdbc.SQLServerDriver as the default driver for MSSQL Server.

Server Host

Specifies the host where the MSSQL Server is running.

Server Port

Specifies the default MSSQL Server port, typically 1433.

UserName

Specifies the default user name for the MSSQL Server database user.

Password

Specifies the password that is associated with the specified Default UserName.

Maximum Rows

Specifies the default maximum rows to retrieve.

Values: This property can have one of the following values:

10 to 512

Default: 10

Database Name

Specifies the MSSQL database name.

Instance Name

Specifies the MSSQL instance name.

Default MySQL Properties

Specifies the database properties when an instance of a MySQL database server hosts one or more CA Process Automation databases.

Driver

Specifies com.mysql.jdbc.Driver as the default driver for MySQL.

Server Host

Specifies the host where the MySQL database is running.

Server Port

Specifies the default MySQL database port.

UserName

Specifies the default user name for the MySQL database user.

Password

Specifies the password that is associated with the specified Default UserName.

Maximum Rows

Specifies the default maximum rows to retrieve.

Values: This property can have one of the following values:

10 to 512

Default: 10

Database Name

Specifies the MySQL database name.

Default Sybase Properties

Specifies the database properties when an instance of a Sybase database server hosts one or more CA Process Automation databases.

Server Type

Specifies the default Sybase relational database system.

Values: This property can have one of the following values:

• Adaptive Sever Anywhere (ASA)
• Adaptive Server Enterprise (ASE)

Connection Protocol

Specifies the default connection protocol.

Default: TDS

Driver

Specifies the default driver.

Default: com.sybase.jdbc2.jdbc.SybDriver

Server Host

Specifies the host where the Sybase database is running.

Server Port

Specifies the default port for the Sybase database.

UserName

Specifies the default user name for the Sybase database user.

Password

Specifies the password that is associated with the specified Default UserName.

Maximum Rows

Specifies the default maximum rows to retrieve.

Values: This property can have one of the following values:

10 to 512

Default: 10

Cache Buffer Size

Specifies the amount of memory that the driver uses to cache insensitive result set data.

Values: This property can have one of the following values:

• -1 - All data is cached.
• 0 - Up to 2 GB of data is cached.
• X - Specifies the buffer size in KB, where the value is a power of 2 (an even number). When the specified limit is reached, the data is cached.

Default: -1

Batch Performance Workaround

Specifies the default batch performance work-around.

Values: This property can have one of the following values:

• Selected - The JDBC v3.0 compliant mechanism
• Cleared - The native batch mechanism.