Apply event-driven automation to database jobs
Set up, monitor and manage jobs in complex processes with less effort.
Manage dependencies
Set up jobs to run according to data readiness.
Automate sequencing
Build business processes around the data you need.
Simplify monitoring
Keep an eye on all database jobs from a single pane of glass.
Advancing database scheduling
The Tidal adapter for JDBC includes the following features:
- Connection management to monitor system status with a live connection to the database via JDBC
- JDBC job and event management:
- Applying dynamic runtime overrides for SQL parameters and values passed to stored procedures
- Associating defined dependencies and events with Tidal for scheduling control
- Providing output formatting options to control the results, including table, XML and CSV
- Scheduling and monitoring SQL queries and stored procedures from a centralized work console
- Terminating, holding and releasing scheduled SQL and more job execution controls
What the adapter enables
With the Tidal adapter for JDBC, you can:
- Design data-heavy workflows using the same user interface approach as other types of jobs, seamlessly integrating JDBC data management into existing operational processes
- Get easy connectivity, job definition and monitoring
- Integrate Tidal security management features to connections using JDBC and associated jobs
How it works
Defining JDBC jobs
After adding one or more database users to Tidal and defining your connections using JDBC, you can start creating and scheduling JDBC jobs.
Create a JDBC job using the context menu within the Jobs pane. You can also edit, copy and delete an existing JDBC job. If you add a JDBC job to a Tidal job group, items common between the job group and the JDBC job are inheritable. However, unless the parent group has a JDBC adapter assigned to it, you must clear the Inherited option and choose an appropriate JDBC connection.
Select the “Add JDBC Job” option from the Tidal Jobs pane displaying the JDBC Job Definition dialog.
There are two types of JDBC adapter jobs that you can define in Tidal:
- SQL: Direct inclusion of SQL statements, with or without dynamic parameter replacement
- Stored procedure: Reference to a stored procedure, including dynamic or static parameter replacement
Working with JDBC events
Using the adapter, you can define events to be used for alerting and invoking an automated response through email and/or inserting additional jobs into the schedule. The Event Definition dialog displays when you add or edit a JDBC event. Tidal can monitor events and then take one or more actions when the event trigger occurs.
You must configure a calendar for the event from the Schedule tab to schedule when the event is enabled (when monitoring will occur). If necessary, you can configure the monitor to operate only during certain time periods or leave the monitor in operation at all times.
Expand your vision
What else can your organization do with workload automation?
Tidal and JDBC integration FAQs
-
What is JDBC used for?
Java Database Connectivity (JDBC) is an API that enables Java applications to connect to and interact with relational databases. It allows developers to execute SQL queries, retrieve and update data and manage database connections directly from Java code.
-
What is the difference between SQL and JDBC?
Structured Query Language (SQL) is a standardized language used to manage and manipulate relational databases. JDBC, on the other hand, is a Java-based API that enables Java applications to send SQL commands to a database. In short, SQL is the language, and JDBC is the Java tool used to run SQL within an application.
-
What are the 7 steps of JDBC?
The typical 7 steps of using JDBC in a Java application are:
1. Import JDBC packages: Include the necessary Java SQL classes.
2. Load and register the JDBC driver: Initialize the database driver class.
3. Establish a database connection: Use DriverManager.getConnection() to connect to the database.
4. Create a statement: Prepare an SQL statement using Statement or PreparedStatement.
5. Execute the query: Run the SQL query using methods like executeQuery() or executeUpdate().
6. Process the results: Use a ResultSet object to read the data returned from the query.
7. Close the connection: Properly close the ResultSet, Statement and Connection to free resources.