Introducing the Tidal Automation Adapter for JDBC

The adapter provides automation of database operations as part of cross platform process organization between TA and the enterprise.

The consolidation of scheduling automation is accomplished:

  1. Designed using the same user interface approach as other types of jobs, seamlessly integrating JDBC data management into existing operational processes.

  2. Integrated security management features of the TA can be applied to the implementation of connections using JDBC and associated jobs to ensure secure management and use.

    TA ’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 adapter also provides easy to use access for connectivity setup, job definition, and monitoring.

The 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 TA.

    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 TA for scheduling control.

    Provide job execution control including terminating, holding, and releasing scheduled SQL.

Requirements

For a completed list of hardware and software requirements, see the Tidal Automation User Guide.

The JDBC driver(s) for the target database must be installed on the TA Master server with a reference in the system CLASSPATH. Refer to the documentation for the driver that you are using.

Note: If you change the CLASSPATH environment variable to include a reference to a JDBC library, you will need to restart the master or the master system if the master runs under the Local System account (on Windows).