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.
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.
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: 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.
Microsoft SQL: Schedule SSIS Packages
This integration allows users to execute a Microsoft SSIS Package using the 'dtexec' utility, which comes with the Microsoft SQL Server installation. In addition, it's also possible to execute an SSIS package via a SQL job, which is executed by a procedure task stored by Stonebranch Universal Controller.
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.
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.
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.
VMware: vSphere Integration
This integration helps the 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 which 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 also list, create, 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.