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
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:Capability to compress and decompress a file with zip deflate method. Capability for AES-256 password encryption. Support for 7-Zip (Windows/Linux) or p7zip (Linux)
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
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)