JDBC Adapter

Pre-built big data Java Database Connectivity adapters from Tidal
Announcement icon

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:

End-to-End Workload Automation with Tidal Workload Automation

Built for the needs of database processing, the Tidal Workload Automation Adapter for Java Database Connectivity (JDBC) is the interface between Tidal 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 Tidal 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 Tidal Workload Automation Adapter for JDBC Works

Once the adapter has been implemented within the Tidal Workload Automation environment, administrators can define, launch, monitor, and control standard database processing such as Structured Query Language (SQL) statements and stored procedures. Tidal Workload Automation allows IT staff to quickly resolve job failures, incorporate multiple cross-application dependencies, and use process models, which include JDBC- compliant databases. Tidal Workload Automation Adapter for JDBC can submit predefined SQL processes or stored procedures to Tidal Workload Automation and monitor the status of each process as it runs. Tidal Workload Automation 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 Tidal Workload Automation uses the vendor’s specifically defined JDBC drivers.

Features and Benefits

Tidal Workload Automation Adapter for JDBC and Tidal Workload Automation 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, Tidal Workload Automation 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 Tidal Workload Automation 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 Tidal Workload Automation can be applied to the implementation of JDBC connections, roles, and jobs to help ensure secure management and use of required security credentials.