Integrations
Available Integrations
The following table identifies the Integrations that are available for Universal Controller.
The Name of each Integration is a link to a separate page containing detailed information about that Integration.
Name | Description | Latest Version | Release Date | What's New |
---|---|---|---|---|
Amazon S3: Cloud Storage Bucket File Transfer | Securely transfers files from, to and between AWS S3 cloud storage buckets and folders. | 1.6.1 | 25/01/28 | Fix: Support for Match Pattern in the S3 Key when using a Prefix |
Amazon SQS: Message | Send an AWS SQS message towards an existing queue. | 1.1.1 | 23/08/09 | Fixed: Field 'Proxy Type' raised a data validation error on Controller 7.3.0.0 and later. |
Amazon SQS:: Monitor | Monitor AWS SQS messages from an existing queue and run job(s) and/or workflows accordingly. | 1.1.1 | 23/07/28 | Fixes: - Fixed: Field 'Proxy Type' raised a data validation error on Controller 7.3.0.0 and later. |
Manage Ansible task execution through the Universal Controller user interface. | 1.1.2 | |||
Apache Airflow | Integrate with Apache Airflow and use it as part of your end-to-end Universal Controller workflow, allowing high-level visibility and orchestration of data-oriented jobs or pipelines. | 2.0.0 | 23/02/04 | Enhancements: - Added support for Google Cloud Composer Airflow Deprecations and Breaking Changes: - Breaking Change: Stop supporting Universal Agent/Controller 7.0.0.0. Support Universal Agent/Controller 7.1.0 or higher |
Apache Kafka: Event Monitor | Monitor events (messages) from topics in Kafka. | 1.1.0 | 23/05/10 | Enhancements: - Added support for Client authentication over SSL Fixes: - Improve robustness of application |
Apache Kafka: Publish Event | Publish events (messages) to topics in Kafka. | 1.2.0 | 23/04/28 | - Added: Support for SSL Security Protocol and Client authentication over SSL. - Added: Extension Output result upon successful task instance execution. |
AWS Batch | Submit new AWS Batch Jobs as well as read the status for an existing AWS Batch Job. | 1.3.1 | 24/02/01 | Fixed: Revert `certifi` as requirement. |
AWS CLI | Start running commands that implement functionality equivalent to that provided by the browser-based AWS Management Console from the command prompt in your terminal program. | 1.0.0 | 24/04/10 | Initial Version |
Create an EC2 instance with parameters, either in task form, or by simply creating an EC2 instance from the existing AWS launch template. | ||||
AWS EC2: Start, Stop, and Terminate Instances | Start, stop, terminate, and manage AWS EC2 instances on demand, simply by providing one or more instance IDs as input. | |||
AWS ECS | 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:
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. | 1.0.0 | 24/08/14 | Initial Version |
AWS EMR | This integration provides the ability the start and optionally monitor (by polling at specified intervals) notebook executions as supported by AWS EMR. Additionally the user can optionally specify various configuration options relating to the notebook execution. | 1.0.0 | 24/06/06 | Initial Version |
AWS Glue | Provides the capability to submit a new AWS Glue Job. | 2.1.0 | 24/08/29 | - Added new field - Endpoint URL. - Proxy Type field has been removed (hidden) as it no longer needs to be filled by users on task definition. |
AWS Lambda | Extends other AWS services with custom logic or creates your own back-end services that operate at AWS scale, performance, and security. | 1.2.0 | 24/01/04 | Provide the capability to use a custom Lambda service endpoint. |
AWS Mainframe Modernization | Allows migrating and modernizing on-premises mainframe workloads to a managed runtime environment on AWS. | 1.4.0 | 23/02/14 | Enhancements: - JCL Files can be selected dynamically from UI. |
AWS Step Functions | Execute AWS Step Functions from Universal Controller | 2.0.0 | 23/09/01 | - Breaking Change: This version supports Universal Agent and Universal Controller from version 7.2 onwards. Customers that used older versions of this integration on Universal Controller and Universal Agent of versions <= 7.2 are required to upgrade to use the new functionality introduced by 2.0.0. |
Azure AZ CLI | The Azure command-line interface (Azure CLI) is a set of commands used to create and manage Azure resources. | 1.0.0 | 23/02/10 | Initial Version |
Azure Batch | Provides the capability to add Azure Jobs, add Azure Batch Tasks to existing Azure Jobs, and optionally monitor Azure Task execution for completion (successful or failed). | 1.0.0 | 23/03/20 | Initial Version |
Azure Blob: Manage File Transfers | Securely transfers files from, to and between Azure Blob Storage container and folders. | 1.0.0 | Initial Version | |
Azure Data Factory: Schedule, Trigger, and Monitor | Schedule, trigger, and monitor the Azure Data Factory pipeline process directly from Universal Controller. | |||
Azure Logic Apps: Schedule, Trigger, and Monitor Workflows | Trigger and monitor the execution of Azure Logic workflows and retrieve the execution of Azure Logic workflow output. | |||
Run, monitor, and re-start Azure Synapse Pipelines from the Universal Automation Center. | 1.2.0 | 24/05/29 | Enhancement: Json Output is provided for further processing of the output in, e.g. Workflows | |
Azure Virtual Machines: Start, Stop, and Terminate Instances | Utilize Azure Virtual Machine (VM) name, resource group, subscription ID, and access token as inputs for the start, stop, terminate, list, and check status of Azure VMs. | |||
Databricks: Automate Jobs and Clusters | Perform end-to-end Orchestration and Automation of Jobs & Clusters in Databricks environment, either in AWS or Azure. | 1.3.3 | 23/04/28 | Fixed: Retry Interval and Max Retry parsing secured. It was failing for actions that don't use these values. |
Manage and transform data in a reliable and scalable manner. | 1.0.1 | 23/10/18 | Fixed: Include integration icon on Universal Template | |
Docker Compose: Support to Build, Up, Down, Start, Stop Docker Compose Functions | Universal Task for Docker Compose Functions, Build, Up, Down, Start, Stop Functions. | 1.0.1 | ||
Docker Container: Support for Create, Start, Stop, Remove Containers and Run a Command in a Running Container | Universal Task to manage Docker Containers, Run, Create, Start, Stop and Remove Functions. | |||
Docker Image: Support to Build, Remove, Pull, Push and Tag Image Functions | Universal Task to manage Docker Images, Build, Remove, Pull, Push, and Tag Functions. | |||
E-Mail: SMTP and IMAP Integration | Send and retrieve E-Mails and E-Mail attachments, as well as download mail attachments to a mail folder. | |||
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. | 1.0.1 | 23/10/18 | Fixed: Execute the integration with a Python installation, other than the Agent-bundled one |
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. | 1.1.0 | ||
GitHub: Automated Import/Export | Perform server operations, such as importing/exporting Universal Automation Center objects and integrating with GitHub, as well as allowing the import/export of Universal Automation Center objects using the Universal Controller script library. | 1.1.25 | 23/04/06 | |
Google BigQuery: Schedule, Trigger, Monitor, and Orchestrate Operations | Schedule, trigger, monitor, and orchestrate the Google BigQuery process directly from Universal Controller. | 1.1.4 | 24/08/08 | Fixed: Usage for the Double quotes for the _scriptPath |
HashiCorp: Terraform | An infrastructure as code tool that lets you define both 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 all of your infrastructure throughout its lifecycle. | 1.0.1 | 22/07/19 | Fixed: Credentials can now be passed from Credential field to the variable script. |
Hitachi Vantara: Pentaho Data Integration | Provides powerful ETL (Extract, Transform and Load) capabilities. Universal Controller is integrated to orchestrate the jobs and transformations within Pentaho Data Integration platform via Carte webservice calls. | |||
Allows users to schedule, trigger, monitor, and orchestrate the InfoSphere DataStage jobs directly from Universal Controller via the InfoSphere DataStage Command-line Interface (CLI). It also helps to set up dependencies between DataStage jobs and other applications or platforms using UAC workflows and trigger DataStage Jobs from UAC either time-based or event-based. | 1.0.0 | 23/07/28 | Initial Version | |
Informatica Cloud: Schedule, Control, and Manage | Schedule any Data Integration Task or Linear Taskflow in the Informatica Cloud. | 1.3.0 | 24/08/22 | Enhancements: - Resume a suspended taskflow instance from a faulted step - Skip a faulted step and resume a suspended taskflow instance from the next step. |
Informatica PowerCenter: Schedule, Control, and Manage | Schedule Informatica PowerCenter Workflows and Tasks, including retrieval of the workflow and session log. | |||
Inter-Cloud Data Monitor | Monitor files/directories from across different cloud storages, as well as local or distributed file systems. Additionally and upon successful monitor, this extension publishes Local Universal Events. | 1.0.1 | 24/08/14 | - Fixed: Events were not published with the action Monitor On Create when Trigger on Existence was enabled. |
Inter-Cloud Data Transfer | Provides the capability to manage and synchronize files from across different cloud storages, as well as local or distributed file systems. | 4.1.0 | 25/01/28 | Enhancements: - Introduced the ability to authenticate on remotes of type OneDrive using Client Credentials - Added the option to toggle SSL Certificate Verification when attempting to Update Credentials on UC. - Capability to Print Impacted Object List on task completion for human readability (STDOUT) and machine processing (EXTENSION). - Credentials Update on UC will be performed only when there is new information to Update. Fixes: - Running the task with any local user is now supported with Agent versions where issue D-13034 is resolved. Extension Output Improvements - Action List Objects crashed with "Index out of range" error. - Tasks failed when Windows paths with whitespaces is used. - Synchronize and Copy From URL does not Update Credentials even if the field is enabled. - Credentials field Key Location is not retaining its value when Update Credentials was enabled. |
Jenkins: Start and Trigger Workflows | Improves the functionality of Jenkins when orchestrated from Universal Controller. | |||
Jira Service Management - Cloud (Jira Service Desk) | Create requests, create new customers, add customers to a service desk project and remover customers form a service project in Jira Service Desk straight from the Universal Controller. | 1.0.0 | 24/02/28 | Initial Release: Basic Functionality for Jira Service Management Cloud |
JScape: Managed File Transfer | Manage and integrate JSCAPE Managed File Transfer Server processes within UAC automation processes and workflows. | |||
Kubernetes: Automate Container Operations | Kubernetes List (Get), Create, Delete and Replace Functions. | 1.0.1 | ||
Microsoft Power BI | Allows users to connect to and combine data from multiple data sources through a secure interface, creating Power BI datasets. Additionally, users may combine and transform collections of tables into a data pipeline, creating Power BI dataflows. Provides the capability to perform refresh actions on Microsoft PowerBI Datasets and Dataflows. | 1.0.0 | 24/08/14 | Initial Version |
Microsoft SQL: Schedule SSRS | Call a script to deploy a report on the Reporting Services Webserver. | |||
Microsoft SQL Server Agent Jobs | Schedule and execute tasks within the SQL Server environment. | 1.0.0 | 24/07/03 | Initial Version |
Microsoft SQL: SSIS Package Execution | Allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. It also 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 completed. | 1.0.4 | 23/05/17 | Fixed: Environment Reference ID is optional and when there is no value, the extension fails. |
Microsoft Teams: Monitor Channel | Monitor a Microsoft Teams channel for uploaded files and run job(s) and/or workflows accordingly. | 1.0.3 | 24/03/07 | Added support for Python 3.11 |
Microsoft Teams: Send and Receive Notifications | Send messages to an existing channel of Microsoft Teams, allowing you to integrate this solution in UAC to notify users for UAC result or send approval notifications on Microsoft teams. | 1.2.3 | ||
Microsoft Teams: Send Message with Attachment | Post messages with attachments on a Microsoft Teams channel. | |||
NTT Data: UniKix | Provides the capabilities for submitting JCL Requests to UniKix Batch Processing Environment by using BPESUB CLI Command with additional capabilities like fetching the logs and output files, validating successful execution and running a profile environment script before running the command. | 1.0.0 | 24/03/04 | Initial Version |
Oauth2: Get Token | Enables a third-party application to obtain limited access to an HTTP service. | |||
Oracle EBS Request | 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 EBS environment script before running the concurrent request. | 1.0.6 | 24/01/10 | |
Oracle Job Scheduler | Directly schedule, trigger, monitor, and orchestrate jobs and job chains within the Oracle Scheduler through the Python module cx_Oracle in Universal Controller. | 1.0.0 | 24/08/08 | Initial Version |
PagerDuty: Manage Alerts | Notify PagerDuty (Incident management platform) in the event of job Failure or long run of a job or early finish of a job or any other event in Universal Controller. | |||
Prefect Cloud | Prefect is an open-source workflow management system designed to orchestrate data pipelines in Python. This integration provides the capability to trigger from UAC a Prefect Flow Run and monitor its execution providing useful metadata. | 1.0.1 | 25/01/23 | Enhanced log messages for API calls and added SSL configuration analysis messages. |
Qlik Sense | A Business Intelligence (BI) Tool that lets users connect and combine data from hundreds of data sources by defining data pipelines as applications. Data can then be visualized via custom dashboards on a Qlik Sense Cloud instance (Business or Enterprise edition) or by using a Desktop application (Enterprise Windows edition). | 1.1.0 | 22/09/29 | Introduced a new Wait for success or failure functionality, where the user gets the reload app status after reloading the app. |
Red Hat: OpenShift CLI | Run any OpenShift command from the Universal Agent. OpenShift CLI (oc) is bundled within this integration and does not require separate installation | 1.0.0 | 24/05/16 | Initial Version |
Acts as an interface to OpenShift CLI (oc) enabling users to trigger the execution of OpenShift Jobs from the Universal Controller. OpenShift CLI (oc) is bundled within this integration and does not require separate installation. | 1.2.0 | 24/08/29 | Added ability to retrieve container logs after running a job. | |
Salesforce: Create Contact and Lead Object | Create contact and lead objects in Salesforce, as well as execute Salesforce Object Query Language (SOQL) queries. | |||
SAP: Batch Input Map | Schedule and execute batch input sessions in SAP. | |||
SAP: Business Object Data Services | Execute an SAP Data Services “ETL” Job using the “AL_RWJobLauncher.exe”. | 1.1.11 | 22/04/25 | Added: Search pattern by pattern |
SAP: Business Objects Scheduling Web Intelligence Documents and Crystal Reports | Schedule Crystal Reports and Webi reports, supporting multiple prompts and different output formats such as PDF, EXCEL, and Webi. | |||
SAP: Calendar Import | Import the SAP Factory Calendar and the related Holiday Calendar into the Universal Controller. | 1.3.0 | 25/01/28 | Enhancements - Added: Support Variables for all Credentials and SAP Connection - Added: Support for Universal Controller SAP connection - Added: Keep manually created Custom Days when re-importing the calendar from SAP |
SAP Cloud Data Service (CPI DS) | Schedule, trigger, monitor, and orchestrate the SAP CPI DS (Cloud Data Services) Tasks directly from Universal Controller | 1.0.0 | 24/08/08 | Initial Version |
SAP: Event History Monitor | Queries the SAP Event history table for a selected SAP Event & Parameter. If the Event is found, it gets confirmed | 2.2.0 | 24/12/05 | Enhancements |
SAP: Extract Job Definition | Export SAP Job definitions from SAP into one flat file for each Job selected for extraction. | |||
SAP HANA XSA | Provides the capability to schedule SAP HANA extended application services Jobs (SAP HANA XSA Jobs) from the Universal Automation Center. | 1.0.2 | 23/12/21 | Support for copying Input Parameters from an existing Job Schedule definition |
SAP Integrated Business Planning (IBP) | Helps to integrate SAP Integrated Business Application (IBP) application and orchestrate the schedule and launch of SAP IBP jobs from UAC. The dependencies of the IBP jobs with other platforms or applications can also be managed via UAC workflows. | 1.0.1 | 23/08/24 | Bugfix: Issue during import due to incompatibility of the extension name |
ServiceNow: Event | Detect, analyze, and respond to various events in real-time in the ServiceNow Platform. | 1.1.0 | 24/08/01 | Enhancements: Changes: |
ServiceNow: Incident | Allow customers to create incident tickets in ServiceNow straight from the Universal Controller. | 2.3.2 | 24/11/07 | - Fixed table name when creating attachments. |
Slack Bot | Provides Slack Commands that let a user gain information about reports, agents and task instances, or even alter the latter. | 1.0.2 | 22/12/15 | Bugfix: Extension is available for 7.1 and 7.2 UC versions |
Slack: Send and Receive Notifications and Approvals | Sends job status notifications to a Slack channel and enables users to send interactive messages in Slack for Universal Controller manual task approvals. | 1.2.0 | 23/04/24 | Enhancements - Introduced a new field name called Message (large textbox) for sending additional messages to slack channels as notifications |
Snowflake: Schedule, Trigger, Monitor, and Orchestrate Operations | Orchestrate, schedule, trigger, and monitor the Snowflake load and unload process from different data sources (cloud storage or local VM’s) directly from Universal Controller. | 1.2.0 | 24/08/08 | Addition of key pair Authentication |
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, Oracle, and SAP HANA databases. | 3.0.1 | 24/11/14 | Enhancements: - Refined database message handling | |
Tableau: Refresh Data Source | Perform instant refresh to the Tableau Data sources worksheet and schedule refresh tasks in sync with the source systems to provide real time analytics. | 1.0.3 | 23/04/24 | Minor bug fixes |
Talend Cloud | Provides the capabilities for running API commands of Talend Cloud related to executing and managing various tasks and plans within your Talend environment, with additional functionalities like monitoring execution statuses and handling dependencies. | 1.0.4 | 24/06/21 | |
Monitoring of the triggered COB (Close of Business) process from UAC by COB execution stages with an intuitive interface providing the centralized Dashboard and reporting features and notify in case of COB failures or any SLA violations in the course of COB execution. | 1.1.4 | 23/05/05 | ||
Allows UAC to Schedule, trigger & Monitor the Daily Close of Business (COB) process in the T24 System automatically and it also helps to build your own COB workflow including the COB Pre and post-COB conditions which might be critical for the COB execution process. | 1.0.0 | 23/05/05 | Initial Version | |
Twilio | Universal Extension allows sending SMS/WhatsApp/Voice message to a list of recipients. | 1.0.0 | 22/11/22 | Initial Version |
UAC Solution Pack: Dynamic Container File Monitoring and File Transfer | Dynamic File Monitoring and File Transfer solution for containerized applications running in any container management solution. | 1.0.0 | Initial Version | |
UAC Utility: Command Execution | This Universal Task enables command execution on Windows and on Linux as if it is invoked directly from a user's shell. | 1.0.0 | 24/10/31 | Initial Version |
UAC Utility: CSV Tool | Process input data in Comma-Separated Value (CSV), Delimited Separated Value (DSV), or Tab Separated Value (TSV) formats | 1.0.0 | 23/08/04 | Initial Version |
UAC Utility: Email | Send emails through SMTP and Microsoft Graph API, offering configurable options for recipients, message content, and file attachments. | 1.0.0 | 24/12/19 | Initial Version |
UAC Utility: File Compression | Compress and decompress a file, with or without password encryption. | 1.3.0 | 24/07/19 | Enhancements: Fixes: |
UAC Utility: For-Each-Input Loop | Automate the processing of input data by reading it from a flat file in Windows/Linux or a UAC script data repository. | 1.1.0 | 25/01/16 | Enhancements |
UAC Utility: GnuPG | GnuPG (GPG) is a command line tool implementing the OpenPGP standard. GPG allows for encryption, decryption and signing of data and communications. This integration provides the capability to perform file encryption and decryption, based on GnuPG. | 1.1.0 | 24/11/07 | Enhancements: |
UAC Utility: HTTP Download | Download content from an HTTP server and store it on the Universal Agent's File System for later processing. Downloading content from an HTTP server is a common operation in various scenarios, including File Transfer, Data Synchronization, Web Scraping, Data Analysis, and more. | 1.0.0 | 24/06/06 | Initial Version |
UAC Utility: Jobs As Code (JaC) | Regardless of whether you create your Universal Automation Center (UAC) job definitions using the drag-and-drop designer or as code in a development environment, the UAC jobs-as-code solution provides guidance and tools to integrate those definitions with a Git repository. | 2.1.0 | 25/01/03 | -Added: New choice Definition Name (Wildcard) for Selection Method. This option can significantly improve performance in cases where the queried UC resources natively support wildcard filtering. |
UAC Utility: JSON Tool | Handle input data in JSON format from different sources. This tool is utilized for reading, filtering and applying light transformations on JSON data. | 1.0.0 | 24/04/11 | Initial Version |
UAC Utility: Powershell | Universal Task to Run Powershell Scripts. | 1.0.1 | ||
UAC Utility: Remote Controller | Run Task or Workflow on a Remote Universal Controller. | 1.0.1 | ||
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 | 1.0.2 | 24/04/25 | Fixes: - Fixed: Invalid file format when copied to a different OS - Fixed: incorrect version name printed from within the script was corrected | |
UAC Utility: System Monitor | 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. | 1.0.0 | 24/12/19 | Initial Version |
UAC Utility: UC Report | Run a Universal Controller report and deliver output to a specified server and file location. | 1.0.1 | ||
UAC Utility: UDMG File Transfer | Provides the capability to perform file transfer where UDMG is the client and upload or download files to remote partners. | 1.4.1 | 24/07/25 | Maintenance Changes: Fixes: |
UAC Utility: UDMG OpenPGP | Securely manage File transfers with external business partners (i.e. Customers or Suppliers) and between any endpoint in today’s Hybrid-IT infrastructure, on-premises, or in the cloud (public and or private). It also comes up with a keystore for PGP public and private keys. | 2.0.1 | 24/05/02 | Fixes: - Resolved compatibility issues with Linux systems utilizing glibc version 2.17. - Error Code 101 now correctly corresponds to a task failure. |
UAC Utility: Web Service | Provides the capability to call endpoints of foreign APIs. | 1.5.0 | 25/01/23 | Added: Enabled Credential Variable for Credential Fields applicable from version 7.6 onwards. |
UiPath: Schedule, Trigger, and Monitor Processes | Schedule, trigger, and monitor the UiPath (RPA) process directly from the Universal Controller. | 1.0.1 | ||
Universal Connector for PeopleSoft | The Universal Connector for PeopleSoft integrates PeopleSoft systems with local administrative tools and enterprise system management infrastructures. | |||
Universal Connector for SAP | Certified by SAP for the latest versions of SAP HANA and NetWeaver, the Universal Connector for SAP automates IT and business processes across your entire IT ecosystem. | |||
VMware: vSphere Integration | 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. | 1.1.2 |