Product Training How to Automate On-Prem SQL Environments

Watch this detailed product training and learn how to use Universal Automation Center to orchestrate SQL scripts and functions against any on-premises MySQL, PostgreSQL, SQL server, Oracle, and SAP HANA database.

Learn how to automate on-prem SQL environments

The Universal Task for SQL enables Stonebranch cloud SaaS customers to securely manage their on-premises SQL environments without exposing inbound communications through their firewalls from the cloud to their data center. The Universal Task supports the execution of SQL scripts for Oracle, MySQL, PostgreSQL, SQL server, and SAP HANA databases.

During this detailed product training, you'll see several use cases in action as you step through the Universal Automation Center's SQL orchestration capabilities.

Key points covered in the demo include:

  • Overview – SQL task (architecture and how it works)
  • Oracle – execute PL/SQL block
  • SQL Server – create and run stored procedures
  • SAP HANA – run SQL workflow

Demo Length: 9 min

Note: Additional information can be found on the Stonebranch Integration Hub.

Further Reading

Read the blog post: IT Process Automation Made Simple

IT Process Automation Made Simple

Business today happens a lot faster than human beings can process it. Read this article to learn how we help businesses manage their IT Process Automation…

Read the blog post: Job Orchestration Made Simple: Streamline Your IT Operations

Job Orchestration Made Simple: Streamline Your IT Operations

Why does IT have to be so complicated? Job orchestration helps you streamline automated tasks and end-to-end processes across the enterprise.

Top 5 Reasons to Replace Tidal Workload Automation

Tidal Workload Automation (WLA) has become stagnant and its future is uncertain. Read this article and learn how to save money and stress with Universal…

Watch the Research Results Webinar: 2024 Stonebranch Global State of IT Automation

2024 Stonebranch Global State of IT Automation Research Results Webinar

In this expert discussion, Peter Baljet and Scott Davis review the key insights and trends identified in the 2024 report, discuss the implications for the IT…