Products

Solutions

Education & Training

Services & Support

Partners

Company

{{search ? 'Close':'Search'}}

Database Automation With CA Automic Workload Automation

Integrate SQL Jobs with enterprise workloads.

Free Trial

Related Videos


Increase agility and reliability for your databases.

Your database team is under pressure. Manual scheduling of SQL jobs threatens deadlines as jobs wait on the detection of file arrivals, alerts and other events. Maintaining SQL jobs and enterprise workloads with multiple tools wastes valuable IT resources while unmonitored, standalone SQL database jobs and scripts can expose enterprise security controls. Moreover, a lack of alignment between DBAs and application managers adds to operational overheads.

CA Automic Workload Automation enables you to execute SQL commands including DDL, DML, stored procedures and DBA functions without having to use an external command line tool. CA Technologies advanced security model simplifies your database administration, making security concerns, unwieldy tools, wrapper scripts and confusing evaluations of the past. Tasks can proceed in a uniform manner within the framework of enterprise workload automation.

Removing unnecessary manual steps and bringing SQL jobs into automation workflows enables IT Operations teams to gain the agility businesses now demand for digital transformation.

Database Automation With CA Automic Workload Automation Features

Job Designer

Uses an interface tailored to support the different types of database jobs

Database Events

A powerful event object that allows the initiation of a job or process flow based on the value of a database query

Broad Database Support

Integration with databases like SQL Server, Oracle, IBM DB2, MySQL, SAP Hana, Sybase, Informix, Ingres

Multi-threading

Executes multiple database jobs in parallel by creating a separate thread for every job

Execution Control

The results of a transaction are made available as a job report; date and time stamps are provided in a uniform format for all databases

Managed File Transfer

Integrated file transfer ensures timely, accurate and secure data transfer

Database Automation With CA Automic Workload Automation Benefits

Simplified Management

Simplifies the management of IT workload across multiple and heterogeneous database instances

Eliminates Errors

Reduces errors and delays by removing reliance on custom scripts

Improved Visibility

Enhances visibility of database jobs and other business application workload, end to end

Stronger Security

Encrypts passwords in login objects for greater security and avoids multiplication of local scripts

Real Companies. Real Results.

Talk to us about Database Automation with CA Automic Workload Automation.

Chat
What would you like to chat about?
Contact
Call us at +1-800-225-5224
Call us at +1-800-225-5224
Contact Us