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

Success Story Anglian Water

Anglian Water: Streamlining SAP Scheduling

Success Story: Anglian Water needed a modern alternative to its process automation and scheduling tool, CPS by Redwood. Stonebranch offered a solution that’s…

Watch the Product Update Webinar | What's New in UAC 7.8 + Universal Portal

UAC 7.8 Product Update Webinar: Automation For All

See how UAC 7.8 makes automation accessible to everyone, from business users to citizen developers. With the new Universal Portal, central IT can securely offer…

Read the blog | Automation Trends 2025: Top Takeaways from the Annual Global State of IT Automation Report

Automation Trends 2025: Top Takeaways from the Annual Global State of IT Automation Report

Discover the top five IT automation trends for 2025, including the rise of automation-as-a-service, hybrid IT orchestration, and the growing role of business…

Header Card Analyst Report: 2022 Global State of IT Automation Report

Stonebranch 2025 Global State of IT Automation Report

The results are in! New research reveals 2025's IT automation and orchestration benchmarks for IT Ops, DevOps, CloudOps, and DataOps teams.