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 | Stonebranch UAC 7.8 Release Offers Automation for All

Stonebranch UAC 7.8 Release Offers Automation for All

Stonebranch UAC 7.8 introduces the Universal Portal for self-service automation, plus additional enhancements: re-certified SAP agent, OpenShift deployment,…

Read the blog | What is Human-in-the-Loop Automation?

What is Human-in-the-Loop Automation?

Learn how human-in-the-loop (HITL) automation combines human approvals with IT automation. Discover key use cases throughout the organization —and how a SOAP…

Self Service Automation: Best Practices for Organizational Efficiency

Self Service Automation: How to Empower Your Business

Self service automation can help break down organizational silos to boost employee efficiency. Check out these best practices to help your help desk reduce the…

Read the blog | The Future of Workload Automation: Three Strategic Priorities for IT Leaders

The Future of Workload Automation: Three Strategic Priorities for IT Leaders

Orchestration, AI, and cloud automation are transforming the world of workload automation. Stay ahead with strategic insights to future-proof your operations.