Databases operators support JDBC type 2 drivers to communicate a database. Database operators can perform different database operations such as queries on the database, but they do not support administrative operations such as stopping a database server, back up/recovery, and so on.
The connection string differs based on the server type.
The TNS name and thin driver type combination is supported only in Oracle 12.x versions and up. CA Process Automation does not validate any combination or the server credentials provided at the operator level.
Note: You can use the Databases operators with a different Relational Database Management System (RDBMS) than the one used by the CA Process Automation databases. For example, if CA Process Automation was installed using Microsoft SQL, you can use the Databases operators with Oracle. However, the appropriate database driver file must first be deployed correctly to your CA Process Automation installation. See the Installation Guide for details.
|
Copyright © 2014 CA.
All rights reserved.
|
|