Apache Airflow is an open-source platform created to programmatically author, schedule, and monitor workflows. This Universal Extension provides the capability to integrate with an Apache Airflow Standalone Server or Google Cloud Composer Airflow and use it as part of your end-to-end UC workflow, allowing high-level visibility and orchestration of data-oriented jobs or pipelines.You gain many enterprise-level benefits by using the Universal Automation Center to control Airflow. Notable benefits include: Run your Airflow data pipelines in realtime by using event-based triggers from the UCAdd Airflow tasks to broader business process workflows in the UCGain observability of your Airflow workflows - with proactive alerts from the the UCRead this article to learn more about the benefits of integrating Airflow with the Universal Automation Center.Key FeaturesThis Universal Extension provides the following key features:ActionsTrigger a DAG run and optionally wait until the DAG was reached "success" or "failure".Information retrieval of a specific DAG Run.Information retrieval for a task that is part of a specific DAG Run.AuthenticationBasic authentication for Stand Alone Airflow Server.Service Account Private Key for Google Cloud Composer.OtherCapability to use HTTP or HTTPS proxy instead of direct communication to Stand Alone Airflow Server. What's new v 2.0.0 The latest release provides the ability to integrate with Google Cloud Composer Airflow Server. Furthermore, provides the ability to configure Action "Trigger DAG Run", by passing JSON configuration parameters.

Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics, data integration, and mission-critical applications. A Kafka Event Monitor is a Universal Extension responsible for monitoring events (messages) from topics in Kafka.    Key Features:   This Universal Extension provides the following main features:   Monitor messages and consume a Kafka message by consumer group topic subscriptionAuthenticate against Kafka using PLAINTEXT, SASL_SSL or SSL security protocolCapability to filter Kafka messages based on the value of the message. Number, String and JSON filter patterns are supported.Capability to fetch dynamically Kafka topics, during task creation.Capability to control the partition assignment strategy, as well as session-related timeout values   Typically this extension can be used to monitor events from Kafka and upon successful execution to trigger workflows or other tasks, or just to pass information related to the Kafka event within UAC.   What's New in V1.1.0With this new release client authentication over SSL is supported.  

Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics, data integration, and mission-critical applications. This Integration is responsible for publishing events (messages) to topics in Kafka.   Key Features: This Universal Extension supports the following main features: Perform authentication towards Kafka, using PLAINTEXT or SASL_SSL security protocol Send a message to Kafka with the capability to select, the topic, the partition, the message key, the message value and message metadata Capability to control the transport of the messages by configuring the message acknowledgment strategy and the request timeout Capability to fetch dynamically topics and partitions from kafka for selection during task creation Capability to automatically select the serialization method depending on the key/value message data types What's New in V1.2.0This new release improves robustness of this integration and adds a number of useful features:Support for client authentication over SSL against Kafka bootstrap server.Extension Output is now provided upon successful execution.Debug mode execution is enhanced to properly close extension execution.Partition field enhanced to show and use all its dependent fields.

The AWS Command Line Interface (AWS CLI) is an open source tool that enables you to interact with AWS services using commands in your command-line shell. With minimal configuration, the AWS CLI enables you to 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. This integration provides an interface to call the AWS CLI and enables users to execute AWS CLI tasks in UAC.Key FeaturesThis Universal Extension provides the following key features.Execute AWS CLI on UAC.Ability to provide configuration options through UAC scripts.

AWS Mainframe Modernization service is an AWS cloud-native platform to migrate, modernize, execute, and operate mainframe applications within a fully-managed runtime. Stonebranch Universal Automation Center (UAC) works with AWS Mainframe Modernization to offer a high-availability, template-driven approach to shift existing mainframe batch schedules and event-based automation to re-platformed or refactored mainframe applications that run on AWS. Using the Stonebranch AWS Mainframe Modernization extension, enterprises may run automation in both the mainframe and on AWS simultaneously.  Key Features: The ability to schedule, automate and execute mainframe batch jobs running in AWS Mainframe Modernization Service via the Stonebranch Universal ControllerMonitor Application’s batch processes from the Stonebranch Universal ControllerStart/Restart/Rerun/Cancel batch processes automatically or manually from the Stonebranch Universal ControllerSynchronous and asynchronous batch execution from Stonebranch Universal ControllerRetrieve the results of the AWS Mainframe Modernization Batch processesCapture the AWS Cloudwatch logs of the executed jobs in Stonebranch Universal Controller More information: Article: Mainframe Modernization - How Automation Makes it PossibleTechnical Brief: Mainframe Modernization: Convert Mainframe-Centric Schedulers to a Modern Service Orchestration and Automation PlatformWhat's New In 1.4.0:  * BluAge support added* Log Fetching Methods updated

Step Functions is a serverless orchestration service that lets you combine AWS Lambda functions and other AWS services to build business-critical applications. Through Step Functions graphical console, you see your application’s workflow as a series of event-driven steps.This integration allows customers to execute AWS Step Functions from Universal Controller.Key FeaturesThis Universal Extension provides the following key features.ActionsExecute a AWS Step Function and wait until is reaches status "Success" or "Failed".Execute a AWS Step Function asynchronously without waiting for the execution to finish.AuthenticationAuthentication using AWS CredentialsAuthorization via IAM Role-Based Access Control (RBAC) strategy.OtherCommunication through Proxy with use of HTTP or HTTPS.Whats New V2.0.0Breaking Change: This version supports Universal Agent and Universal Controler 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. Added: A suffix is added to the Execution Name before AWS Service is called. That suffix represents the execution count for a specific task instance, therefore providing uniqueness of the Execution Name. Fix: The Extension Output attribute “fields.invocation.execution_name” is corrected to represent the user input after the resolution of UC Functions and variables

This integration is for any email provider that uses SMTP and IMAP, including email vendors like Outlook.com, Microsoft Exchange, and Gmail. This integration allows sending and retrieve E-Mails and E-Mail attachments. It also provides the functionality to download mail attachments to a mail folder. This Integration is beneficial for Stonebranch SaaS customers, accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their own datacenter. As the Integration is triggered from the Universal Agent, no additional firewall ports would need to be opened. Key Features Some details about Universal Tasks to send and retrieve E-Mails and E-Mail attachments. Main functionalities: Send an E-Mail with or without attachments Use Universal Controller Variables Retrieve an E-Mail based on filter criteria like From, To, sender, subject, body content … Move an E-Mail to a Mail folder after downloading it to a configured folder Delete an E-Mail after downloading it to a configured folder

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.

This Universal Extension provides the capability to monitor data (files/directories) on various major Cloud Providers including AWS, Google Cloud, Microsoft Azure. This integration can be executed as a standalone UAC Task, however in order to benefit from the full functionality and scalability of UAC, it is suggested to be used in conjunction with Universal Monitor Triggers and Universal Monitor Tasks.Multiple storage systems are supported (an overview can be found here). Integrations within this solution package include:Amazon S3Google Cloud StorageMicrosoft OneDrive Business, including Sharepoint Microsoft Azure Blob Storage Hadoop Distributed File Storage (HDFS) Local file system (Linux, Windows) HTTP(S) URL Key Features:  This Universal Extension supports the following key features: Action Monitor objects creation Monitor objects change - change based on modification time Monitor objects deletion Options Trigger On Existence - available for Action Monitor On Create.  Advanced filtering capability for objects to be monitored. Universal Event Event published upon single object creation, holding information about the new object Event published upon single object change, holding information about the updated file, including the latest object size and modification time. Event published upon single object deletion, holding information about the deleted object. Event published upon single object existence, holding information about the object. What's New v1.0.1:Fixes:Fixed an issue where events were not published with the action Monitor On Create when Trigger on Existence was enabled.Fixed an issue with the appearance of some warnings at the beginning of the extension execution that happens on later versions of the Universal Controller.Fixed an issue when updating credentials.

This Universal Extension provides the capability to perform data transfers between cloud based storage services, as well as local or distributed file systems. Transfers are fast and secure since data are streamed from one storage to another with no intermediate storage taking place. Multiple storage systems are supported (an overview can be found here). Integrations within this solution package include: Amazon S3Google Cloud Storage Microsoft OneDrive Business, including Sharepoint Microsoft Azure Blob Storage Hadoop Distributed File Storage (HDFS) Local file system (Linux, Windows) HTTP(S) URL Key Features This Universal Extension supports the following key features: Actions Copy, move, synchronize data between two storages. Copy a URL's content and to cloud or local destination without saving it in temporary storage. List data on a storage, including listing with details or in JSON format for machine parsing. Create objects on a storage. Delete objects from a storage. Features: Fast transfers for objects stored in the same region. Preserves always timestamps and verifies checksums. Supports encryption, caching, compression, chunking. Dynamic token updates for OneDrive Business cloud storage, observing the OneDrive business refresh token flow. Support for dry runs. Allows users to execute a Universal Task without making any permanent changes on the target storage. Advanced filtering capability for files or objects to be listed or transferred. Option to mark the Universal Task as Failed when no files have been transferred. List of overwrite options for existing data. Additional customized options. Output Progress of the selected Action is visible, during Universal Task Instance execution. Text or JSON formatted output. What's New (v. 4.0.1) Fixes Avoid setting executable flag for rclone binary on Windows  

This integration 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. This integration provides the capability to perform refresh actions on Microsoft PowerBI Datasets and Dataflows. A typical Use Case is when UAC is used as a Data Pipeline orchestrator, where the last step of a workflow could be the refresh of a Microsoft Dataset or Dataflow. Key Features: Capability to execute refresh commands for Datasets or Dataflows and monitor their status

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.

Microsoft Teams is a collaboration app that helps teams stay organized and have conversations. This Integration provides the capability to monitor a Microsoft Teams channel for uploaded files and run job(s) and/or workflows accordingly.Key Features This Universal Extension provides the following main features: Support authentification to Microsoft Teams with Oauth2 protocol (Grant Type: Resource Owner Password Credentials) For a specific Microsoft Teams Channel, periodically poll all the new messages since the last lookup For each fetched message having attachments, launch a task in Universal Controller with variables holding message and attachment details Ability to resume from the last read message on restart.What's New In V1.0.3Compatibility with Python 3.11.

This integration allows users to send messages to an existing channel of Microsoft Teams. Key Features: End-users can request notifications within Teams alerting them about task results from Stonebranch Universal Automation Center. Task results can include items like completed workflows and task failures. Only requires a Python library 'pymsteams' to function.

This integration enables users to receive task-related notifications and send task-related approvals through a Teams channel. It uses incoming webhooks to integrate Microsoft Teams with the Stonebranch Universal Automation Center (UAC).  Key Features: Using this task, UAC task-related information can be sent directly to an operational Teams channel. Send interactive messages to a Teams channel to trigger an approval process for manual tasks whenever user intervention is needed. End-users can request notifications within Teams alerting them about UAC task results. Task results can include items like completed workflows and task failures. Additional Info:  Requires serverless infrastructure (e.g., AWS Lambda, Microsoft Azure Functions, or Google Cloud Functions).

Microsoft Teams is a collaboration app that helps teams stay organized and have conversations. This Universal Extension provides the capability to post messages with attachments on a Microsoft Teams channel. Key Features This Universal Extension provides the following main features: Support to post a message with an attachment on a Microsoft Teams channel Support for authentication to Microsoft Teams with Oauth2 ROPC (Resource Owner Password Credentials) grant type Support for different attachment handling options in case an attachment already exists in Microsoft Sharepoint (fail, replace, rename)

This Universal Task 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.The BPESUB command is an operating system utility used to submit JCL requests in UniKix Batch Processing Environment.Key Features: This Universal Extension provides the following main features: Submit RequestFetch LogsProcess output to identify step exit codesExecute Environment Script

Oracle Scheduler, a feature embedded in Oracle Database, facilitates the automation of a variety of tasks, jobs, and processes within the database environment. Users can schedule and oversee the execution of jobs, programs, and scripts at specified intervals or in response to events.  The Universal Task in Stonebranch enables users to directly schedule, trigger, monitor, and orchestrate jobs and job chains within the Oracle Scheduler through the Python module cx_Oracle in Universal Controller. Additionally, it allows the establishment of dependencies among different Oracle jobs or job chains, as well as connections with processes in other applications or platforms through UAC workflows. This integration permits Oracle Scheduler jobs to be triggered from UAC, either through time-based or event-based mechanisms Key Features: This Universal task provides the following main features:Ability to schedule, trigger & orchestrate the execution of Oracle Scheduler Job / Job chainsMonitor the Oracle job / Job Chain execution.Print job logs/execution status post-execution.

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

Qlik Sense is a Business Intelligence (BI) Tool. Qlik Sense users can connect and combine data from hundreds of data sources by defining data pipelines as applications. Data can then be visualized via custom dashboards on the Qlik Sense Cloud or Desktop application. Key Features:This Universal Extension provides the following key features:Support to reload a Qlik Sense Cloud Application Support to read the status of an already reloaded Qlik Sense Cloud Application What's New V1.1.0This new release introduces a button that gives the capability to users to trigger and wait until the Qliksense app reaches status "Success" or "Failed".

(Large File Download - Please be Patient)This integration acts as an interface to OpenShift CLI (oc) enabling users to run any OpenShift command from the Universal Controller. OpenShift CLI (oc) is bundled within this integration and does not require a separate installation. Key Features: Capability to run any OpenShift command.Authentication types: Basic, Session Token and Web Console Token.Integration can be deployed on an Agent that lives inside an OpenShift cluster.

*Large File Download - Please be PatientOpenShift Jobs in the context of Kubernetes are resources designed for running finite tasks or batch jobs. They create and manage pods to execute these tasks, ensuring completion and termination upon success. Commonly used for operations like batch processing or periodic tasks. This integration 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. Key Features: Capability to run a single OpenShift Job using a job resource file or a job resource URL and monitor its completion.Capability to delete OpenShift registered jobs.Authentication types: Basic, Session Token and Web Console Token.Integration can be deployed on an Agent that lives inside an OpenShift cluster.Capability to retrieve container logs automatically upon job completion.What's New V 1.2.0 Added ability to retrieve container logs after running a job.

This integration allows users to create contact and lead objects in Salesforce and execute Salesforce Object Query Language (SOQL) queries.  Key Features: Allows advanced automation by enabling the creation of Salesforce objects (e.g., contacts and leads) from the Stonebranch Universal Controller, as well as event-based triggers. Use the Salesforce Object Query Language (SOQL) to search your organization's Salesforce data for specific information. SOQL is similar to the 'select' statement in SQL, but specifically for Salesforce data. With SOQL, users can construct simple but powerful query strings and execute them from within the Universal Controller.

SAP Integrated Business Planning (IBP) is a cloud-based planning software for supply chain management and this Universal Extension helps to integrate with SAP IBP to Schedule & launch a SAP IBP Job Template or process chain from Universal ControllerKey FeaturesThis Universal Extension provides the following main features:The ability to schedule, automate and execute SAP IBP jobs running in SAP Cloud via Stonebranch Universal ControllerMonitor SAP IBP Jobs from the Stonebranch Universal ControllerStart/Rerun/Cancel batch processes automatically or manually from the Stonebranch Universal ControllerRetrieve the results of the SAP IBP Jobs that are executedCancel a IBP Job execution via dynamic command or by a separate task using the cancel function choiceDisplaying real time IBP execution status in Universal ControllerWhat's New in V1.0.1This new release involves a minor bug fixFix: issue during import due to incompatibility of the extension name