Cisco Cisco Tidal Enterprise Adapter for zLinux Data Sheet
©2016
Cisco
and/or
its
affiliates.
All
rights
reserved.
This
document
is
Cisco
Public.
10. Cisco Workload Automation Adapter for Java
Database Connectivity (JDBC)
Adapter Overview
Integrating Database Connectivity for Enterprise-Wide Job Scheduling
To improve their competitive advantage, businesses are investing in applications, databases, and data
warehouse appliances that increase operational efficiency. These solutions manage critical data and logic from
various functional areas including financials, inventory, procurement, and order fulfillment.
Processing the right data at the right time, managing dependency logic, and automating job sequencing are
critical to the smooth operation of the enterprise. To achieve these goals, two conditions are necessary:
•
Broad enterprise-wide visibility of the entire application, storage, and database landscape
•
The ability to automate a wide range of functions, from dependency mapping, to application and
database job steps, to event and alerts management
End-to-End Workload Automation with Cisco Workload Automation
Built for the needs of database processing, the Cisco Workload Automation Adapter for Java Database
Connectivity (JDBC) is the interface between Cisco Workload Automation and JDBC-compliant database
management systems. Together, they provide IT organizations with comprehensive cross-platform, cross-
application job scheduling functionality, real-time interaction, and centralized control. With the adapter for JDBC,
IT organizations can add the workload automation, manageability, and reliability of Cisco Workload Automation
to JDBC- compliant databases. Users can manage all workload processes from a central console and integrate
database processes into the wider enterprise job-processing environment to reduce errors and increase
resource efficiency.
How Cisco Workload Automation Adapter for JDBC Works
Once the adapter has been implemented within the Cisco Workload Automation environment, administrators
can define, launch, monitor, and control standard database processing such as Structured Query Language
(SQL) statements and stored procedures. Cisco Workload Automation allows IT staff to quickly resolve job
failures, incorporate multiple cross-application dependencies, and use process models, which include JDBC-
compliant databases. Cisco Workload Automation Adapter for JDBC can submit predefined SQL processes or
stored procedures to Cisco Workload Automation and monitor the status of each process as it runs. Cisco
Workload Automation can be used to monitor database events, which can then be used to trigger other