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.
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.
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.
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.
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
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.
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.
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.
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
Microsoft SQL: SSIS Package Execution
SQL Server Integration Services is a platform for building data integrations and data transformation solutions. This integration interactively allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. Further, it can trigger the SSIS package execution in the Microsoft SQL server and monitor the SSIS Package execution, and fetch SSIS logs to the universal controller once the SSIS package execution is completed.
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 FeaturesSupport 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
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.
ServiceNow: Create Tickets and Change Requests
This integration allows users to create incident tickets, problem tickets, and change requests in ServiceNow, all from the Stonebranch Universal Automation Center (UAC). Additionally, it can combine with the event- or time-based automation capabilities of the UAC, e.g., automatically create an incident ticket if a task execution fails. Key Features: This task enables customers to create an incident ticket in ServiceNow and optionally attach the output of preceding tasks to the ticket. Create problem tickets in ServiceNow. Create change requests in ServiceNow. This task combines with the event- or time-based automation capabilities of the Stonebranch Universal Controller to automate the IT service management process.
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:ActionsCreate a ServiceNow Incident.AuthenticationAuthentication using ServiceNow Credentials.Input/OutputCapability to send the output of any task instance as incident attachment.
SQL: Execute Scripts and Functions
This integration allows users to execute SQL scripts and functions against a MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and SAP HANA database. It uses an agentless connection via ODBC towards SQL Server, MySQL, and PostgreSQL, and the Oracle basic instant client to connect to an Oracle database. Key Features: Supports execution of SQL scripts for Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and SAP HANA: For SQL Server, MySQL, and PostgreSQL: all connections are agentless via ODBC.For SQL Server: Windows Authentication and SQL Server Authentication is supported. For SAP HANA: database connections are performed agentless using the SAP HANA client for Python. For Oracle: the execution of SQL scripts and Oracle PLSQL blocks are supported. Oracle connections are performed agentless using the Oracle basic instant client. Supports Universal Agent for both Linux/Unix and Windows. Select different log-levels, e.g., info and debug. Decide if the SQL-output is provided in the standard out or not. All passwords are encrypted using Stonebranch Universal Controller credentials.
Tableau: Refresh Data Source
This integration allows users to perform an instant refresh to the Tableau data sources, worksheets and schedule refresh tasks in sync with the source systems to provide real-time analytics. Tableau is a powerful data visualization tool for business intelligence platforms. Key Features: Run extract refresh task. Get refresh task. List data sources. Refresh data source. Refresh workbook. Tableau projects , data sources, and workbook can be selected dynamically. Tableau iob execution cancellation can be performed using the dynamic command. Connection to Tableau is through the REST API and is done via the Python requests module. Supports Windows and Linux agents in order to connect to the Tableau REST API.
UAC Utility: File Compression
File compression is a way to reduce overall file size without losing any of the primary data to make large files more manageable. This integration provides the capability to compress and decompress a file, with or without password encryption.Key Features:This Universal Extension provides the following main features: ActionsCompress file or directories.Decompress zip files with files or directories.OtherSupport for AES-256 password encryption for files.Support for 7-Zip (Windows/Linux) and p7zip (Linux)Support for Embedded (Linux)What's New V1.2.0New Embedded Archiver Tool permits users to zip/unzip not only files but whole directories. It is using Python Standard Library and not a 3rd party executable like 7Zip is needed. It is very useful for cases that the Agent is installed in container (and thus having access to a very small set of binaries) and the user of the platform does not need to use complex features like encryption.
UAC Utility: Remote Controller
Universal Task to launch, monitor, and return results from a task defined in a remote Universal Controller.For customers who would like to manage tasks in one Universal Controller from another Universal Controller. Simply supply the target Universal Controller URL, valid credentials, and the name of a task defined to the target Universal Controller. Using the web service API's, the Universal Task launches the requested task by name, captures the new instance sysid, and uses this to track the status of the task. After completion, the output is retrieved if the task type supports this, and the Universal Task complete with the same exit code as the launched task.
UAC Utility: Run a Command/Script on a Remote SSH Server
This integration allows users to run a command or Stonebranch Universal Controller (UC) data script on a remote SSH server. It enables the execution of commands and scripts from the UC script library on a remote Unix/Linux or Windows SSH server. Key Features: Ends with the exit code from the remote command/script. Both 'stdout' and 'stderr' from the remote task are returned to the integration 'stdout'. The 'stderr' is used for messages from the integration itself. Tested with the Universal Agent bundled Python distribution.Set different log-levels for the integration, providing you amounts of information to suit your needs. Supports both Linux/Unix and Windows. Additional Information: Users should note that this integration is unable to provide the following functionalities that are typically available for tasks that execute on a Universal Agent: No agent visibility, status, or alerting. The remote command or script cannot be cancelled from the controller interface. Canceling the SSH task will only cancel the integration Python script that initiates the SSH session. No fault-tolerant functionality. No clustering, load balancing, or broadcast functionality.
UAC Utility: Universal Data Mover Gateway
This integration is for users of WLA / Job Scheduling with the UDM Gateway File Transfer solution. Universal Controller customers can implement the provided Universal Task. The Universal Task can automate the following UDM Gateway functions: PGP Encrypt PGP Decrypt Run a UDM Gateway Trigger SFTP File Upload SFTP File Download Trading Partner File Upload Trading Partner File Download Trading Partner File Upload using a Regex or Generic Filename Pattern Trading Partner File Download using a Regex or Generic Filename Pattern
VMware: vSphere Integration
This integration helps end-users to orchestrate VMware vCenter Server operations from the Universal Controller. It encourages collaboration by enabling automated deployment and management of Virtual machines on the EXSi hosts connected to the vCenter Server. The VMware vSphere is the virtualization platform that helps with transforming datacenters into aggregated computing infrastructure. The main components of vSphere includes ESXi and vCenter server. With this integration, the users can perform operations like list, create, delete, start, stop, suspend, resume Virtual machines, and list, create, and delete Hosts and Datacenters. Key Features: UAC communicates with VMware vCenter through the vSphere Python SDK libraries. Helps with automated deployment and management of virtual machine lifecycle. Helps with automated management of Datacenters in the vCenter server. Helps with automated management of Hosts in the vCenter server.
Web Service Integration (7.1 and above)
A Web service is a method of communication between two electronic devices over a network.This integration provides the capability to call endpoints of foreign APIs. It is beneficial for Stonebranch SaaS customers accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their datacenter. As the integration is triggered from the Universal Agent, no additional firewall port for the Universal Agent needs to be opened. Key Features: Support for communicating with APIs using the HTTP(S)/REST protocol Support for Authorization towards the foreign API using Basic Authentication or OAuth2 token Support for HTTP Methods GET, POST, PUT, DELETE, PATCH Support for SSL Protocol Ability to use proxy between Universal Agent and target web service Ability for configuration of custom exit codes based on the web service response payload (Supported for JSON payloads) What's New in V 1.2.0The Extension Output is enhanced to include a new JSON attribute body_json. This attribute is populated with the Web Service response body as a JSON object when the Web Service response body is of type JSON.