Free
Ansible: Execute and Manage Playbooks
This Ansible integration allows users to execute Ansible playbooks and run other Ansible modules or commands directly from the Stonebranch Universal Automation Center (UAC).
Key Features:
Manage Ansible task execution through the intuitive Universal Controller user interface.
Ansible playbooks can either be centrally stored and maintained in the Universal Controller script library, or Universal Controller can call the relevant playbook residing in the Ansible host.
This integration also enables the execution of other Ansible commands.
Free
AWS EC2: Create Instances
This integration allows users to create an AWS EC2 instance with parameters, either in task form or by simply creating an EC2 instance from the existing AWS launch template. This task also offers the option to install a Linux/Unix Universal Agent in the newly provisioned EC2 instance.
Key Features:
The task interacts with the AWS platform via a Python Boto3 module.
All AWS credentials remain encrypted.
Users can also install/configure a Linux Universal Agent for each EC2 instance, enabling the Universal Controller to communicate with the newly created instance instantly.
This task also lets users create multiple EC2 instances with the same configuration. New instances can also be tagged.
It allows customers to create a new key pair or use an existing one for the new EC2 instance.
This task also enables options for additional EBS volume and encryption, as well as detailed monitoring. Additional Info:Only Linux Universal Agent is supported at the moment.
Free
AWS EC2: Start, Stop, and Terminate Instances
This integration allows users to spin up, terminate, and manage AWS EC2 instances on demand simply by providing one or more instance IDs as input.
Key Features:
This task uses Python Boto3 to interact with the AWS platform using the credentials supplied within the task.
It supports multiple EC2 instances at once.
This task goes to the success state in Universal Controller until the EC2 instance is completely spun up or terminated.
Scheduling this task using Universal Controller workflow spins up and tears down EC2 instances based on the business needs, complete with the correct setup and dependencies.
It dynamically manages EC2 operations, offering the potential to reduce EC2 operations costs in the cloud.
Free
AWS ECS
Amazon Elastic Container Service (AWS ECS) is a fully managed container orchestration service that simplifies the deployment, management, and scaling of containerized applications. ECS allows you to run and scale Docker containers on AWS infrastructure without needing to manage the underlying hardware or software, making it easier to build, deploy, and operate containerized applications. It integrates seamlessly with other AWS services, supports both serverless (AWS Fargate) and server-based (EC2) compute options, and provides robust security, networking, and monitoring capabilities.In Amazon Elastic Container Service (AWS ECS), an ECS task is a running instance of a task definition. Tasks use case is ideal for one-time or short-lived jobs. For example:Batch Jobs: Suitable for batch processing, data transformations, and other workloads that complete after a certain period. Task Scheduling: Useful for scheduled tasks, such as cron jobs, where you need to run a task at specific intervals.Manual Execution: Good for tasks that you want to run on-demand or manually trigger through an event or user action. This integration provides the capability to run ECS Tasks allowing the above use-cases to be fulfilled through UAC, where UAC has the role of an orchestrator.
Key FeaturesRun AWS ECS Tasks.Stop AWS ECS Tasks.Capability to run and stop tasks with custom configurations and environment variables.Capability to run with proxies.
Free
Azure Virtual Machines: Start, Stop, and Terminate Instances
This integration allows users to utilize Azure Virtual Machine (VM) name, resource group, subscription ID, and access token as inputs to a start, stop, terminate, list, and check the status of Azure VMs.
Key Features:
Uses a Python request module to interact with the Azure cloud platform.
Expands user ability to start/stop/terminate/check/list Azure VMs that belong to a subscription and resource group.
In the Stonebranch Universal Controller (UC), this task reaches and stays in the success state until the Azure instance is completely started, stopped, or terminated.
Scheduling this task in UC with the right dependencies set up would start and stop EC2 instances based on business needs using a UC workflow.
This task helps to dynamically manage VM operations. It could potentially reduce the Azure VM running cost in the cloud.
Important:
This integration uses Azure Oauth 2.0 access token for Azure API authentication. Users may need to use the UC web services task to refresh the access token periodically.
Free
Video
DBT: Core CLI
DBT (Data Build Tool) Core is an open-source tool and it is designed to help data engineers and analysts manage and transform data in a reliable and scalable manner. Some key features of DBT Core include version control integration, automated testing, documentation generation, and dependency management. These features enable teams to collaborate effectively, ensure the quality of their data transformations, and maintain documentation for their data pipelines. DBT Core simplifies the process of transforming data in a data warehouse environment, providing a structured and scalable approach that helps teams manage their data transformation workflows effectively.This integration provides an interface to call the DBT Core CLI and enables users to execute DBT Core CLI tasks in Universal Controller. This is particularly useful when UC acts as a data pipeline orchestrator and DBT is a step within a data pipeline Universal Controller workflow.
Key Features:
Show DBT version and DBT environment variables information as Task Instance STDOUT. Enables users to retrieve Information on the dbt core installation.
Execute a given DBT command. DBT output is displayed as task instance STDOUT
Artifacts can be collected, and related information can be published within Universal Controller for subsequent workflow tasks to use.Ability to safely store and pass UC Credentials as DBT environment variables.
What's New in V1.0.1:Include integration icon on Universal Template.
Free
Video
Fivetran
Fivetran is a cloud-based data integration platform that helps businesses automate the process of extracting data from various sources, transforming it, and loading it into a data warehouse for analysis. It offers a wide range of pre-built connectors to popular data sources such as databases, marketing platforms, CRMs, and more. Fivetran's connectors are designed to be easy to set up and use, allowing businesses to focus on data analysis rather than data integration. The platform also offers features such as data transformation, scheduling, monitoring, and access control to help organizations manage their data pipelines more efficiently. Fivetran supports a variety of data warehouses, including Amazon Redshift, Google BigQuery, Snowflake, and Microsoft Azure.
This integration allows to create and execute Fivetran Tasks in Universal Controller.
Key Features:
Trigger a Sync action on a Connector. Optionally, wait until Sync is completed.
Trigger a Re-sync (Historical Sync) action on a Connector. Optionally, wait until Re-sync is completed.
What's New in V1.0.1:A fix is provided to execute the integration with a Python installation, other than the one that is bundled with the Universal Agent.
Free
Git
Git is a free and open-source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. This Universal Extension provides the capability to securely automate the synchronization of your local repositories with the cloud or internal repository servers.
The Universal Extension for Git allows to securely sync a branch from a remote repository to a local one.
Key Features:
Cloning a repository locally if it does not exist. If the local repository exists, then a pull request is issued to get the latest changes from the remote repository branch
Authentication:
HTTP/ HTTPS Basic Authentication
HTTP/ HTTPS Access Token
SSH
Free
GitHub: Automated Import/Export
This integration empowers developers to use GitHub as their version control system. Users will automate the transfer of any workload object — such as tasks, calendars, scripts, and triggers — to and from GitHub. Often, this integration is used to support the development process, inclusive of propagating changes to the next environment, such as QA and Development. Support the automation of the DevOps process by integrating the Stonebranch Universal Automation Center (UAC) with GitHub.
Key Features:
Import any Universal Controller (UC) object from GitHub into UC. For example: import a new template from the GitHub Marketplace into UC.
Import any UC object from a script file into UC. For example: support for no internet connection from UC to GitHub.
Export any UC object to GitHub from UC. For example: export a developed Universal Template to a GitHub repository.
Export any UC object to a script object. The content of the script later can be used to import it on a Controller without needing the UAC import functionality.
Support UC customers, whether SaaS or on-premises.
Additional Information:
Objects integrated with GitHub include Linux/Unix, Windows, and web service tasks.
File operations are performed using the PyGithub module.
This task supports Universal Agents for both Linux and Windows operating systems.
Users can select different log-levels, e.g., info or debug.
All passwords are encrypted using UC credentials.
What's new in V 1.1.25With this release minor bugs are fixed.
Free
HashiCorp: Terraform
Terraform is an infrastructure as code tool that lets you define cloud and on-prem resources in human-readable configuration files that you can version, reuse, and share. You can then use a consistent workflow to provision and manage your infrastructure throughout its lifecycle.
This integration allows users to create tasks that execute terraform commands. Typically, it can be used for Use Cases where UAC acts as an orchestrator for resource provisioning, and Terraform needs to be used to provide those resources.
Key Features:
This Universal Extension provides the following key features:
Init Terraform (Supports upgrade option)
Plan Terraform (Supports Refresh-only planning mode)
Apply Terraform
Destroy Terraform
What's New v 1.0.1
This new release gives the capability to pass UAC credentials from the template into the terraform variable file and to be used in the terraform execution.
Free
Jenkins: Start and Trigger Workflows
This integration improves the functionality of Jenkins when orchestrated from the Stonebranch Universal Automation Center. It encourages collaboration by enabling the well-controlled and automated deployment of applications over to the operations side.
Key Features:
UAC communicates with Jenkins through the Python Jenkins module.
Jenkins can make REST API calls to the Stonebranch Universal Controller (UC) to trigger any task or workflow.
This task can trigger or start an existing build job in Jenkins. The UC will monitor the build execution in Jenkins until completion, then send the build results to the UC. With this task, users can create a building job in Jenkins from the UC. Any Jenkins build job definitions in XML will be stored centrally in the UC.
It offers the functionality to fetch the Jenkins job build information and list running build info in Jenkins from UC.
Enable/disable Jenkins jobs and nodes and delete/copy/rename Jenkins jobs from UC.
When users list the installed plugins in Jenkins, a plugin install can be triggered from the UC.
Set the next build info for Jenkins to build jobs.
Free
Jira Service Management: Cloud (Jira Service Desk)
This Integration allows customers to create requests, create new customers, add customers to a service desk project, and remove customers from a service project in the Jira Service Desk straight from the Universal Controller.
A typical Use Case is creating a request in the Jira Service Desk in the event of a Task failure within the Universal Controller and managing users in the Jira Service Desk.
Key Features:
This Universal Extension provides the following key features:
Actions:
Create a Jira Service Desk Request.
Create Customer.
Add a Customer to Jira Service Desk Project.
Remove a Customer from a Jira Service Desk Project.
Authentication:
Authentication using Jira Service Desk Credentials.
Free
Microsoft SQL: Schedule SSRS
This integration can complete various administrative tasks, including publishing reports and moving reports from one server to another server. It's based on the SQL Server Reporting Services 'rs.exe' command-line utility, which can perform many scripted operations related to SQL Server Reporting Services (SSRS). The rs.exe utility requires an input file to tell rs.exe what to do.The list of actual tasks that can be performed includes among others:
Deploying / Publishing reports
Moving reports
Exporting reports to a file
Adjust security
Cancel a running job
Configure SSRS system properties
Free
Microsoft SQL: Server Agent Jobs
SQL Server Agent jobs help to schedule and execute tasks within the SQL Server environment for example to trigger the nightly backups, SSIS package executions, and Database applications and administration activities.This extension simplifies interacting with SQL Server Agent jobs. It allows users to: Browse and Select Jobs - Easily list and choose the desired SQL Server Agent job and its specific steps. Automated Execution - Trigger the selected job on the Microsoft SQL Server. Monitoring and Logging - Monitor the job's execution status and retrieve logs upon completion, providing insights into the process. The dependencies of the SQL server agent jobs with other platforms or applications can also be managed easily via UAC workflows. Key Features This Universal Extension provides the following main features: Dynamic Choice field to list the Database(select msdb), SQL server Agent job, and SQL Server Agent Job step name Trigger a MSSQL Server agent job Trigger and Wait until the SQL server agent Job Reaches the status "Success" or "Failed" Read the status of an existing Batch Job Restart the job from a specific if failed
Free
Microsoft SQL: SSIS Package Execution
SQL Server Integration Services (SSIS) is a platform for building data integrations and data transformation solutions.This Universal Extension task interactively allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. Furthermore, it can trigger the SSIS package execution in the Microsoft SQL server, monitor the SSIS Package execution, and fetch SSIS logs to Universal Controller when the SSIS package execution has been completed.
Key Features:
This Universal Extension provides the following key features:Dynamic Choice Fields to select the SSIS Folder/Project/Package/Environment Reference ID.Launch SSIS Package execution.
Monitor SSIS Package execution.Fetch SSIS Package execution logs.SSIS Execution ID and Execution status captured for every execution in the Task Instance.Connection to MS SQL Server is done via the Python PYMSSQL module.Supports Windows and Linux Universal Agents in order to connect to the MSSQL server.
What's in V1.0.4This new release involves a minor bug fix.
Free
Microsoft Visual Studio: Code Extension
The Microsoft Visual Studio Code Extension for the Universal Integration Platform (UIP) enhances the development experience of creating and working with Universal Extensions. This extension allows users to develop their own Universal Extensions within Visual Studio.
To access this extension, download it directly from the Visual Studio Marketplace.
Download Now
Key Features:
Provides an IDE wrapper for the uip-cli command line utility
Quickly prototype Extensions using starter Extension Templates
Build and upload Extensions and/or Universal Templates
Pull the latest Universal Template source files from the Controller
Download the full Universal Template package
Debug Extensions locally without the need of Agent and Controller
Note: End user often pair this extension with version control systems like Git or GitHub. In addition, if you prefer coding automated jobs and workflows, take a look at the jobs-as-code extension.
Free
Oauth2: Get token
The OAuth 2.0 authorization framework enables a third-party application to obtain limited access to an HTTP service, either:
On behalf of a resource owner by orchestrating an approval interaction between the resource owner and the HTTP service.By allowing the third-party application to obtain access on its own behalf. With Universal Automation Center, you can obtain Oauth2 access tokens that can be used to authorize UAC tasks.
Key Features:Support to obtain Oauth2 access token for "Resource Owner Password Credentials" (aka "Password Credentials") or "Client Credentials" grant types
Support for authorization scopes
Support to use the Client Credentials in the request Body or as Basic Authorization Header
Free
Oracle: EBS Request
This Universal Task provides the capabilities for submitting Oracle EBS Concurrent Requests by using CONCSUB CLI Command with additional capabilities like fetching the logs and output files, validating successful execution, and running the EBS environment script before running the concurrent request.The CONCSUB command is an operating system utility used to submit concurrent requests in Oracle E-Business Suite. It allows users to submit requests without having to log in to the Oracle E-Business Suite application.
Key Features:The Universal Task provides the following key features:
Submit Concurrent RequestFetch LogsExecute Environment ScriptResult validation based on output messages
Free
PagerDuty: Manage Alerts
This integration allows users to notify the PagerDuty incident management platform of any event in the Stonebranch Universal Automation Center, including job failure, long run, or early finish. Furthermore, PagerDuty can help aggregate alerts and group them to provide reliable notifications, automatic escalations, and on-call scheduling that can help fix support issues quickly.
Key Features:
With this integration, users can orchestrate the following PagerDuty functionalities:
PagerDuty incident:
Create incident.
List incidents.
Update incident notes.
PagerDuty event:
Create PagerDuty event.
PagerDuty user management:
Create a user in PagerDuty.
Delete a user in PagerDuty.
Free
ServiceNow: Event
ServiceNow is a cloud-based platform that provides a suite of IT service management (ITSM) and business process automation (BPA) tools. ServiceNow Events refer to the event management functionality within the broader ServiceNow platform. This feature is designed to help organizations detect, analyze, and respond to various events in real-time.
This integration provides the capability to generate (register) an Event in ServiceNow Platform.Key Features:Capability to create/register events on ServiceNowCapability to authenticate using Basic Authentication or OAuth2 AuthenticationWhat's New in V1.1.0Enhancements: Added support for all ServiceNow Event fields.Changes: This integration is no longer importable on Universal Controller 7.2 or runnable on Agent version 7.2.
Free
ServiceNow: Incident
ServiceNow aims to deliver digital workflows that create great experiences and unlock productivity for enterprise operations. The company's core business revolves around the management of "incident, problem, and change".This Integration allows customers to create incident tickets in ServiceNow straight from the Universal Controller. A typical Use Case is the creation of a ticket in ServiceNow in the event of a Task failure within the Universal Controller.Key Features:
This Universal Extension provides the following key features:
Actions
Create a ServiceNow Incident.
Authentication
Authentication using ServiceNow Credentials.
Input/Output
Capability to send the output of any task instance as incident attachment.
Capability to include some of the available instance fields as part of the incident attachment.
What's New in (V2.3.2)Fixed table name when creating attachments.
New
Free
Video
SQL: ODBC Task
This Universal Extension provides the capability to integrate with ODBC compliant database, by running single or multiple SQL commands and retrieving the resulting data. While it is designed to work with any ODBC-compliant database, it is thoroughly tested against MySQL, MSSQL Server PostgreSQL, and Oracle databases. As opposed to the native UAC SQL Task, which runs on the Controller, this integration allows the user to run an SQL Task from the Agent.Key FeaturesFlexibility in database connection definition supporting DSN, FILE DNS and Connection String.Rich metadata information.Capability to store SQL results in files (CSV or JSON format).Rich Observability capabilitiesWhat's New in V3.1.0Added the option to retrieve SQL script to be executed via local path.Resolved issue which would cause the extension to crash when a path containing a '.' was specified in the Output File Path field.Breaking Changes:Version 3.0 is compatible from Universal Controller & Universal Agent 7.4 onwards. Dependent Python Libraries (pyodbc) are now bundled within the integration archive and do not have to be installed manually.
Stonebranch is an SAP partner. Universal Automation Center (UAC) is certified by SAP for SAP S/4HANA and RISE with SAP S/4HANA® Cloud.
Free
UAC Utility: Email
This task replaces the SMTP portion of the features from E-Mail: SMTP and IMAP Integration. See Also: UAC Utility: Email Monitor
This integration enables sending emails through SMTP and Microsoft Graph API, offering configurable options for recipients, message content, and file attachments.
Key Features
Send emails using SMTP with an app password or Microsoft Graph API with app-only authentication.
Supports multiple recipients.
Allows attachments to be included in emails.
Supports both plain text and HTML body formats.
What's New v1.1.0
Enhancements
Added: Enhanced the From field logic to be possible to send mail from an email address different from the address of the Sender Account.
Free
UAC Utility: System Monitor
This integration provides a powerful tool for users to track system metrics, such as CPU usage, memory consumption, disk activity, and network performance from both Linux and Windows hosts. By leveraging OpenTelemetry, these metrics can be seamlessly published to observability platforms, enabling real-time infrastructure monitoring.
This integration facilitates the detection of performance bottlenecks and potential system failures and allows for proactive resource management. Making infrastructure metrics observable enhances the ability to correlate system behavior with application performance, leading to better overall visibility and system reliability.
Key Features
Observe and Publish Metrics from Linux and Windows Hosts
Configuration options including activation of specific metrics and filtering of metrics based on attributes.