Introduction to Enterprise Scheduling and Adapters
IT operations that focus on the automation of business processes involve integrating a wide range of custom and enterprise applications and the infrastructure on which they run, often with complex interdependencies. In such environments, IT typically uses job scheduling tools to control batch and event-driven processing, which are vital to the success of a range of business operations from sales to manufacturing to financial management.
For the past decade, Cisco® Tidal Enterprise Scheduler has been defining standards for job scheduling usability, scalability, and breadth of coverage. The role of the many adapters available for Cisco Tidal Enterprise Scheduler is to make connectivity, control, and visibility of diverse technologies accessible directly through the scheduler user interface. The breadth of coverage these adapters provide simplifies end-to-end scheduling of processes across the enterprise.
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 Tidal Enterprise Scheduler
Built for the needs of database processing, the Cisco Tidal Enterprise Adapter for Java Database Connectivity (JDBC) is the interface between Cisco Tidal Enterprise Scheduler 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 Tidal Enterprise Scheduler 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 Tidal Enterprise Adapter for JDBC Works
Once the adapter has been implemented within the Cisco Tidal Enterprise Scheduler environment, administrators can define, launch, monitor, and control standard database processing such as Structured Query Language (SQL) statements and stored procedures. Cisco Tidal Enterprise Scheduler allows IT staff to quickly resolve job failures, incorporate multiple cross-application dependencies, and use process models, which include JDBC-compliant databases. Cisco Tidal Enterprise Adapter for JDBC can submit predefined SQL processes or stored procedures to the scheduler and monitor the status of each process as it runs. Cisco Tidal Enterprise Scheduler can be used to monitor database events, which can then be used to trigger other scheduling activities such as enterprise resource planning (ERP) execution or data integration tasks. Modifications to the database management system (DBMS) environment are unnecessary because the scheduler uses the vendor's specifically defined JDBC drivers.
Features and Benefits
Cisco Tidal Enterprise Adapter for JDBC and Cisco Tidal Enterprise Scheduler can deliver rapid return on investment (ROI) to organizations investing in database solutions. Working together, these products bring job scheduling in JDBC-compliant environments into an enterprise context and provide greater automation, visibility, control, and reliability. The following capabilities are crucial to delivering the benefits that users can expect from this solution.
Event-driven processing: In addition to time- and date-based job scheduling, the adapter can dynamically execute single jobs and entire workloads when triggered by business events from a wide range of adapters and platform-supported agents. Also, using the adapter, Cisco Tidal Enterprise Scheduler users can define database events that can be used for alerts and for invoking an automated response through email and inserting additional jobs into the schedule.
• Flexible monitoring and alerting: Job status and output are automatically logged and can be viewed using the Cisco Tidal Enterprise Scheduler console. Alerts can be automatically sent to browser-enabled devices for anytime, anywhere status information and can be configured to initiate process recovery steps.
• IT policy alignment: Each JDBC job can contain several process definitions, allowing for granular controls and error recovery procedures. Information Technology Infrastructure Library (ITIL®) processes in the areas of request fulfillment, incident management, and change management can be supported and can include interfaces and integration techniques available for a range of operational environments.
• Comprehensive security and audit capabilities: Security policy and changes to it are tied to enterprise security management tools and processes. The integrated security management features of Cisco Tidal Enterprise Scheduler can be applied to the implementation of JDBC connections, roles, and jobs to help ensure secure management and use of required security credentials.
Although specific planning and sizing is straightforward, actual requirements can vary by enterprise, depending on the environment and type of coverage needed. Specific requirements information is easily obtainable after an initial conversation with a product expert. Cisco Tidal Enterprise Scheduler and its adapters can be installed and deployed by users or by engaging Cisco Services. Related online materials are available through Cisco Knowledge Services.
About Cisco Tidal Enterprise Scheduler
Cisco Tidal Enterprise Scheduler promotes efficiency by centralizing and providing a single view of cross-enterprise job scheduling events. This powerful, yet easy-to-use solution allows organizations to assemble complex batch job and business process schedules that span the enterprise. With the scheduler's ability to closely monitor scheduled jobs, automatically detect problems, and define actions to aid in recovery, business process performance can be greatly enhanced.
With the broad coverage provided by Cisco Tidal Enterprise Scheduler, IT operations teams can effectively schedule processes that touch a wide range of databases, systems, and applications. They can also easily incorporate and manage new applications as they come online, which helps improve the operation of mission-critical business processes as the enterprise expands and evolves.
Companies in a variety of industries rely on Cisco Tidal Enterprise Scheduler to keep their daily operations running smoothly. Cisco's enterprise job scheduling software, combined with Cisco's performance management solutions, can deliver even greater levels of automation and optimization to the data center than conventional scheduling and performance management solutions.