Adapter for Microsoft SQL

Automate your mission-critical SQL Server processes to serve the needs of the enterprise.
Announcement icon

Tidal Named Enterprise Viewpoint Top 20 SAP Solution Provider

Read the Article

Bring the Performance, Reliability and Flexibility of Tidal Automation to SQL Server Processes

Adapter Overview

Adding SQL Server Processes into Tidal Automation Workflows

The adapter enables integration of new or existing SQL Server database jobs or job steps into enterprise-wide business processes.  Database dependencies that affect workflows can now be managed within end-to-end business processes. As a result, application and database automation and management can be consolidated in one solution, reducing staff effort and expense while increasing productivity.

More About This Adapter

How the Tidal Automation Adapter for SQL Server Works

The adapter offers advanced scheduling and monitoring capabilities without scripting, manual intervention, or changes to SQL Server configuration parameters. Once the adapter is configured, SQL Server jobs are defined and maintained through the Tidal Automation user interface. The Tidal platform provides detailed control of SQL Server jobs through extensive alerts about job abnormalities, resource availability, load balancing and machine functions. It also provides real-time status information from a single console and gives IT operations staff the ability to interact with current and future jobs.

Features and Benefits

The adapter allows SQL Server jobs to be handled through the Tidal Automation user interface. Users can access SQL Server job information and build workflows through a visual interface that allows them to define dependencies among SQL Server jobs alone or SQL Server jobs and jobs running on other systems and applications

Important scheduling capabilities for SQL Server users include:

  • Database Job Definition and Scheduling – The adapter enables three types of SQL Server jobs to be defined in Tidal Automation:
    • Direct SQL Jobs – Makes SQL Server calls using T-SQL statements
    • Database Jobs – Includes one or more steps of various database task types, including the following:
      • ActiveX
      • Operating system command
      • Replication distributor, merge, queue reader, snapshot, and transaction log reader
      • SQL Server analysis services command and analysis services query
    • Existing Database Jobs – Adds, imports, or links to jobs already defined to run under the SQL Server agent
  • Detailed Job Monitoring and Controls – Once database jobs are defined and scheduled, the solution provides real- time status information and gives IT staff the ability to interact with current and future jobs. Users can access detailed job step controls — hold job instances, abort, delete, re-run and make ad hoc changes to a job instance before it has run. In addition, IT staff has constant communication with SQL Server workflows through the use of extensive alert capabilities which can be defined to send detailed messages regarding job abnormalities, resource availability, load balancing and machine functions. In addition, Tidal Automation offers different options for displaying job output, including aligned columns, CSV, raw and XML. Users can also re-direct the output to a local file or log it to a database table.
  • Defining and Running SQL Server Events – Our adapter for SQL Server simplifies processing database events and does not require scripting or managing database triggers. The adapter gives users the ability to capture and respond to database activities, such as table modification, index creation or database row activity. Tidal provides views of all run time database events, which users can then leverage to create event-based job dependencies quickly and efficiently.

The adapter can easily pass variables from Tidal Automation to any SQL Server database job, pass job information across the entire batch job scheduling environment, and pass completed SQL Server jobs to other downstream workflow operations, such as extract, transform, and load (ETL) report creation. In addition, specific events — the arrival of a file from a trading partner, for example — can be used to initiate a new SQL Server action or job step automatically. Users can also assign alert actions to an event, making it possible for administrators to know when that event has been triggered. Users can assign alerts to the database user who triggered an event, the database object that triggered it and the output of the event selected.

Features Summary
  • Links SQL Server with other RDMBS and business applications and consolidates the automation of those jobs through a single console
  • Provides management functions that eliminate scripting, thereby allowing unlimited dependencies, integrated workflows and scalability
  • Creates, schedules and runs T-SQL queries and SQL Server jobs and monitors events without requiring database triggers
  • Defines SQL Server jobs or imports existing jobs and runs them across multiple SQL Server instances
  • Supports jobs that include steps in various database tasks, including ActiveX scripts, OS commands and direct inclusion of T-SQL statements
  • Monitors Table Create, Modify and Delete; Index Create, Modify and Delete; Row Add, Modify and Delete
  • Creates a pre-processor step for any SQL Server job that supports passing parameter values, such as SQL selection criteria, to a job before running it
  • Launches SQL Server jobs based on external events, such as the arrival of a file
  • Generates output of T-SQL queries in XML and other formats without additional coding
  • Provides Tidal calendaring features with more extensive options than those offered by Microsoft tools
Benefits Summary
  • Leverages an investment in SQL Server database to create a comprehensive business automation solution
  • Supports greater efficiency and productivity through a single enterprise-wide scheduling automation environment
  • Reduces the margin for error and enables better resource utilization through fewer steps
  • Enables SLAs to be met faster, by providing access to pre-tested steps
  • Eliminates expensive script generation and ongoing script management by supporting extensive calls
  • Reduces manual intervention through alert and even trigger automation
  • Saves time with automated out-of-the-box processing steps
  • Creates an enterprise-wide workflow solution through upstream and downstream job handoffs
  • Helps administrators correct errors quickly and resolve job step bottlenecks via historic logs
  • Aligns workflows to user demands without expensive manual calendar manipulations

The Tidal Automation Adapter for Microsoft SQL Server helps IT staff deliver maximum database job throughput, rock-solid reliability and comprehensive coordination of database activities as part of an enterprise- wide business process. This powerful solution accomplishes these objectives by providing a single integrated enterprise job scheduler that balances the service requirements of batch or on-demand workloads, whether they were created from within SQL Server or exist in support of other applications and technologies across the enterprise.

Where We Run

The Cloud

Tidal’s enterprise-wide automation platform transcends the inherent limitations associated with standalone point products or native cloud schedulers. We can automate and orchestrate cross-application workloads and enterprise-wide business processes that traverse multiple clouds and hybrid environments – all from a single-pane-of-glass view.

On-Premises

Tidal helps you optimize the value and performance of your legacy infrastructure while opening new opportunities to leverage next-gen applications and workflows. From pure on-prem to hybrid on-prem and cloud engagements – the answer is Tidal.

  • CentOS
  • Linux Kernel 2.6.18 & above
  • Linux PPC
  • Microsoft Windows
  • Microsoft Windows Server
  • Open VMS
  • Oracle Cloud
  • Oracle Enterprise Linux
  • Red Hat Enterprise Server
  • Suse Enterprise
  • Tandem NSK
  • Ubuntu
  • UNIX
  • HPUX (PA-RISC, Itanium)
  • Solaris (Sparc, X86)
  • AIX
  • OS/400 iSeries
  • z/Linux
  • z/OS