Product Training How to Automate On-Prem SQL Environments
Watch this detailed product demonstration 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.
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 execution of SQL scripts for Oracle, MySQL, PostgreSQL, SQL Server and SAP HANA databases.
During this detailed product demonstration, you will see several use cases in action as you step you 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: 8 min
Note: Additonal information can be found on the Stonebranch Integration Hub.