Previous Topic: Configure Command Execution: Default Windows Command Execution PropertiesNext Topic: Configure Databases: Default Oracle Properties


About Databases

The Databases category of operators leverages the Java Database Connectivity (JDBC) technology. JDBC technology supports connectivity in a heterogeneous environment between the Java programming language and databases such as Microsoft SQL Server. The Databases category does not support administrative operations such as stopping a database server. The connection information can be supplied with the server, port and the system identifier (SID), or with a TNSNAMES entry in tnsnames.ora. The tnsnames.ora file is the Oracle Service name configuration file.

The Databases category includes settings for the following databases:

To use the Databases category of operators with an RDBMS from a vendor other than the ones that CA Process Automation uses, install the appropriate driver.

Note: See “Install JDBC Drivers for JDBC Connectors” in the Installation Guide for details.

More information:

Enable Windows Integrated Security for the JDBC Module for MSSQL Server