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
Watch the Video

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

Gartner, Inc. logo blue background

2024 Gartner® Market Guide for Infrastructure Automation and Orchestration (IA&O) Tools

Unlock the insights you need to future-proof your IT infrastructure. This independent report shares insights on the evolving IA&O market trends, tools, and…

Read the blog post: SAP ERP Integration: Unite Automation Across SAP R/3, NetWeaver, HANA, and Beyond

SAP Automation for NetWeaver, HANA, Fiori and Beyond

Tired of the limitations of SAP job schedulers? Stonebranch UAC offers powerful and flexible SAP ERP integrations that allow you to automate, monitor, and…

Read the article: MLOps and Automation for Machine Learning Pipelines

MLOps and Automation for Machine Learning Pipelines

Learn how to implement MLOps and automate machine learning pipelines for deploying ML models to production. Discover the importance and best practices of…

Watch the UAC Product Training: Product Training: How to Collect and Analyze Metrics Data with Grafana

How to Collect and Analyze Metrics Data with Grafana

Learn how to collect metrics data from Universal Automation Center and display it in the Grafana dashboard using Prometheus as a data source.