Руководство Пользователя для Cisco Cisco Workload Automation 6.3
7
Cisco Systems, Inc.
www.cisco.com
1
Introducing the
JDBC Adapter
This chapter provides an overview of the JDBC Adapter and its requirements:
Overview
The Cisco Workload Automation Adapter for JDBC provides automation of database operations as part of cross platform
process organization between CWA and the enterprise. The consolidation of scheduling automation is accomplished as
follows:
process organization between CWA and the enterprise. The consolidation of scheduling automation is accomplished as
follows:
Designed using the same user interface approach as other types of jobs, seamlessly integrating JDBC data
management into existing operational processes.
management into existing operational processes.
Integrated security management features of the CWA can be applied to the implementation of connections using
JDBC and associated jobs to ensure secure management and use.
JDBC and associated jobs to ensure secure management and use.
CWA’s centralized console brings complex scheduling functions to an existing database management system. Users can
define, launch, control, and monitor SQL commands, and stored procedures submitted to a database via JDBC on a
scheduled basis. The JDBC adapter also provides easy to use access for connectivity setup, job definition, and
monitoring.
define, launch, control, and monitor SQL commands, and stored procedures submitted to a database via JDBC on a
scheduled basis. The JDBC adapter also provides easy to use access for connectivity setup, job definition, and
monitoring.
The JDBC adapter includes the following features:
Connection management to monitor system status with a live connection to the database via JDBC.
JDBC job and event management includes the following:
—
Schedule and monitor SQL queries and stored procedures from a centralized work console with CWA
—
Provide dynamic runtime overrides for SQL parameters and values passed to stored procedures
—
Provide output formatting options to control the results, including table, XML, and CSV
—
Associate defined dependencies and events with CWA for scheduling control
—
Provide job execution control including terminating, holding, and releasing scheduled SQL
Requirements
Refer to your Cisco Workload Automation User Guide for a complete list of hardware and software requirements.
The JDBC driver(s) for the target database must be installed on the CWA master server with a reference in the system
CLASSPATH. Refer to the documentation for the driver that you are using.
CLASSPATH. Refer to the documentation for the driver that you are using.