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 UC Add Airflow tasks to broader business process workflows in the UC Gain observability of your Airflow workflows - with proactive alerts from the the UC Read this article to learn more about the benefits of integrating Airflow with the Universal Automation Center. Key-Features This 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) and 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 run both batch schedules and event-based automation 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 Controller Monitor Application’s batch processes from the Stonebranch Universal Controller Start/Restart/Rerun/Cancel batch processes automatically or manually from the Stonebranch Universal Controller Synchronous and asynchronous batch execution from Stonebranch Universal Controller Retrieve the results of the AWS Mainframe Modernization Batch processes Capture the AWS Cloudwatch logs of the executed jobs in Stonebranch Universal Controller More information: Article: Mainframe Modernization - How Automation Makes it Possible What'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 Features: This Universal Extension provides the following key features.Actions Execute 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. What's 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

Contact Us for Additional InformationThis solution provides enhanced observability across your IT ecosystem with the new Dynatrace Integration. 

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.

Google Kubernetes Engine (GKE) is a service for deploying, managing, and scaling Kubernetes containers on Google Cloud. Among its capabilities, GKE supports Jobs, which are used for executing tasks that run to completion, such as batch jobs or one-time processing tasks. To deploy a Job, a Kubernetes Job resource definition is used. Said file is typically defined inside of a YAML or JSON file and specifies the task details, container image, and execution configuration. Once applied to a GKE cluster, the Job runs to completion and terminates automatically. This integration provides the capability to deploy a GKE job on a specified cluster or delete a job from a namespace. Key Features Deploy and Monitor a GKE job on the specified cluster by providing the required Job Resource Definition Job can be provided as a UAC Script, a local file or using an HTTP link. STDOUT and EXTENSION Output can be tuned to provide useful information for the execution of the Job. The executed Job can be deleted automatically. Dynamic commands "Retrieve Container Logs" and "Delete Current Job" can be used on invoked Task Instances. Delete a GKE job from the specified namespace.

Note: This integration replaces Informatica Cloud: Schedule, Control, and Manage. Informatica Cloud is a cloud-native data management platform that enables organizations to integrate, transform and orchestrate data across on-premises and multi-cloud environments. This integration allows users to trigger and control Informatica Cloud Taskflows, Processes, and Jobs from UAC. Key Features: Trigger and Monitor an Informatica Cloud Taskflows with capability to optionally provide required input and fault action strategy. Trigger Processes in a synchronous way with capability to provide optionally input for the executed process. Trigger and Monitor Linear Taskflow Job, Synchronization Task, PowerCenter Task, Replication Task and Mapping Task.  Flexibility in providing input as JSON Text or JSON Script Flexibility to provide Activity Log and Session Log on STDOUT and Activity Log on EXTENSION Output. It is also possible for Users to retrieve Activity Logs on demand when required.

This Universal Extension provides the capability to monitor objects (files/directories) on various major Cloud Providers including AWS, Google Cloud, Microsoft Azure and trigger Universal Events, which can be used for execution of tasks and workflows. It 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 S3 Google 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: Features Monitor Object Creation, Change (based on modification time) and Deletion using advanced filtering capabilities Generates Universal Events for each entity the monitor has detected, which can be used to trigger other tasks and workflows. Large set of possible parameterization and coverage of remote storages. Plug & Play, easy installation without the need to install external dependencies. Dynamic token updates for OneDrive Business cloud storage, observing the OneDrive business refresh token flow. Enhanced observability with event metrics, providing users with detailed statistical insights into events processed across all task instances. Shared configuration with Cloud Data Transfer. What's New v 2.0.1 Fixes Fixed an issue where an event produced by this integration caused a crash on certain extensions. What's New v 2.0.0 Enhancements Installing external dependencies is no longer required. The extension can now automatically attempt to update and store short-lived OneDrive tokens without any extra configuration. It is now possible to detect whether an event involves a directory. Introduced observability features using event metrics. Added the option to skip SSL Verification when updating Credentials. Credential updates on the Universal Controller are performed only when necessary. Other user experience improvements. Deprecations and Breaking Changes Event templates have been reduced to a single template. Changed extension prefix to ue_cloud, providing the capability to share the same configuration with Cloud Data Transfer. Refer to the documentation's migration guide if upgrading from version 1. Fixes Action Monitor On Change error when a file was created. Events were not published in some cases when field Recursion Depth was set to a value greater than 1. Unchecking the Use Storage Modtime field resulted in task failure. Running the task with any local user is now supported with Agent versions where issue D-13034 is resolved. Update Credentials functionality is corrected to retain the existing Key Location value. Task will not fail when using Windows paths including whitespaces.

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 S3 Google 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. Observability capabilities, providing users with detailed statistical insights for data transfers across all task instances. Output Progress of the selected Action is visible, during Universal Task Instance execution. Text or JSON formatted output. What's New V 4.1.1 Fixes List actions would not display the complete object name.  What's New V 4.1.0 Enhancements Introduced the ability to authenticate on remotes of type OneDrive using the OAuth Client Credential flow. Introduced the option to provide detailed information of affected files after the Task execution. Added the option to toggle the SSL Verification process when attempting to update Credentials using HTTPS. Credential updates on the Universal Controller are performed only when necessary. Fixes Running the task with any local user is now supported with Agent versions where issue D-13034 is resolved. Extension output enhancement on Task failure. Fixed "Index out of range" error with the List Objects action. Fixed Task failure when paths with whitespaces are provided on Windows agents. Update Credentials functionality now works with Synchronize and Copy From URL actions. Update Credentials functionality is corrected to retain the existing Key Location value.

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.0 This 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 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. What's New Fixed Execution of oc fails when deployed on a path that includes spaces. Corrected Password handling during login phase.