The Azure command-line interface (Azure CLI) is a set of commands used to create and manage Azure resources. The Azure CLI is available across Azure services and is designed to get you working quickly with Azure, with an emphasis on automation. The Universal Task for Azure AZ CLI allows calling a single or a set of Azure CLI commands. Key Features This Universal Task provides the following key features: The Universal Task for Azure AZ CLI allows you to schedule and Invoke Azure CLI commands. Either a single command or a list of commands can be invoked. No Azure CLI needs to be installed. This Universal Task uses Microsoft-maintained Python modules azure-cli. The following functionalities can be performed: Authenticate with Azure using your Azure user credentials. Authenticate with Azure with a service principal. Invoke a single Azure CLI commands. Invoke a list of Azure CLI commands provides via a Universal Controller Script file. Chooses different log-levels. The Task can run on any Windows or Linux Agent, without the need to install the Azure CLI.

Azure Batch is a set of batch management capabilities that enables developers, scientists, and engineers to easily and efficiently create Azure Batch jobs and tasks. This Universal Extension provides the capability to submit Azure Jobs, add Azure Batch tasks to jobs as well as monitor tasks for completion. Key Features: Actions Add an Azure Batch Job to a specific pool of nodes by providing the Azure Batch Job configuration in JSON format. Add a task as part of a specific job & optionally monitor task for completion. Authentication Ability to connect to Azure using Client Credentials Grant Type. Ability to connect to Azure using User Credentials Grant Type.

The integration for Azure Blob Storage allows secure transfer of files from Azure Blob Storage containers and folders.Storing data in the cloud becomes an integral part of most modern IT landscapes. With the Stonebranch Universal Automation Center, you can securely automate your AWS, Azure, Google, and MinIO file transfers and integrate them into your existing scheduling flows. Key Features: The following file transfer commands are supported: Upload file(s) to an Azure Blob Storage container. Download file(s) from an Azure Blob Storage container. Transfer files between Azure Blob Storage containers. List objects in an Azure Blob Storage container. Delete object(s) in an Azure Blob Storage container. List Azure Blob Storage container names. Create an Azure Blob Storage container. File transfer can be triggered by a third-party application using the Universal Automation Center RESTfull web service API: REST API. The integration for Azure Blob Storage can be integrated into any existing scheduling workflow in the same way as any standard Linux or Windows task type. Security is ensured by using the HTTPS protocol with support for an optional proxy server. Supports Azure token-based Shared Access Signature (SAS). No Universal Agent needs to be installed on the Azure cloud – the communication goes via HTTPS.

This integration allows users to schedule, trigger, and monitor the Azure Data Factory pipeline process directly from the Universal Controller.   Key Features: Uses Python modules azure-mgmt-resource and azure-mgmt-datafactory to make REST API calls to Azure Data Factory. Use the Azure tenant ID, subscription ID, client ID, client secret, resource group, and location for authenticating the REST API calls to Azure Data Factory.  Perform the following Azure Data Factory operations: Run a pipeline. Get a pipeline info. List all pipelines. Cancel pipeline run. List factory by resource group. Azure Data Factory triggers user can perform the  following operations from UAC: Start trigger. Stop trigger. List trigger by factory. UAC also can restart a failed pipeline either from the failed step or from any activity name in the failed pipeline.  

This integration can trigger and monitor the execution of Azure Logic workflows and retrieve Azure Logic workflow output execution. The Stonebranch Universal Controller (UC) integrates with Logic apps through REST APIs securely through the Azure Oauth 2.0 authentication mechanism. Key Features: Passes dynamic input parameters (JSON format) to each Azure Logic app workflow. Triggers a workflow, monitors it until the process is completed, and then delivers the results to UC. Customers can manage and control Logic app workflow execution from UC, with the capability to employ other dependencies like time triggers or event-based jobs/workflows. This task offers ITSM integration capability, enabling the auto-creation of incidents in Logic apps workflow execution failure. 

Azure Synapse is a cloud-based analytics service that combines big data and data warehousing capabilities to enable organizations to ingest, prepare, manage, and analyze large volumes of data for business insights This Universal Task provides the capability to run, monitor, and re-start Azure Synapse Pipelines from Universal Automation Center. Key Features:This Universal Task provides the following key features: Run a Pipeline.Run a Pipeline with parameters.List all Pipelines in a Workspace.Monitor the started Synapse Pipeline. Cancel a Pipeline Run.Cancel a Pipeline Run Recursive.Rerun a Pipeline from a specified activity or the beginning.Service Principal-based Authentication to Azure Synapse. Certificate-based TLS connection.What's New in V1.2.0Enhancements: Json Output is provided for further processing of the output in, e.g., Workflows.

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.

This task has been replaced by UAC Utility: Email Monitor (IMAP) & UAC Utility: Email (SMTP) The Universal Task for E-Mails allows sending and retrieving E-Mails and E-Mail attachments. It also provides the functionality to download mail attachments to a mail folder.This Universal Task is especially useful for Stonebranch SaaS customers, which access Universal Controller in the Stonebranch AWS Cloud and have their Universal Agents deployed in their own data center. Since the Universal Task is triggered from the Universal Agent, no additional firewall ports need to be opened. Key Features 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.

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.2.0 EnhancementsVarious new additional configuration options are available.

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.3.0 Enhancements The Use Large Additional Options field is introduced. When selected, it increases the character limit of Additional Options.The Progress Output field now displays more information and is updated more frequently.Various improvements. Fixes The progress bar was not updating during runtime.

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

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.The list of actual tasks that can be performed includes among others: Deploying / Publishing reports Moving reports Exporting reports to a file Adjust security Cancel a running job Configure SSRS system properties

SQL Server Agent jobs help to schedule and execute tasks within the SQL Server environment for example to trigger the nightly backups, SSIS package executions, and Database applications and administration activities.This extension simplifies interacting with SQL Server Agent jobs. It allows users to: Browse and Select Jobs - Easily list and choose the desired SQL Server Agent job and its specific steps. Automated Execution - Trigger the selected job on the Microsoft SQL Server. Monitoring and Logging - Monitor the job's execution status and retrieve logs upon completion, providing insights into the process. The dependencies of the SQL server agent jobs with other platforms or applications can also be managed easily via UAC workflows. Key Features This Universal Extension provides the following main features: Dynamic Choice field to list the Database(select msdb), SQL server Agent job, and SQL Server Agent Job step name Trigger a MSSQL Server agent job Trigger and Wait until the SQL server agent Job Reaches the status "Success" or "Failed" Read the status of an existing Batch Job Restart the job from a specific if failed

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 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)

The Microsoft Visual Studio Code Extension for the Universal Integration Platform (UIP) enhances the development experience of creating and working with Universal Extensions. This extension allows users to develop their own Universal Extensions within Visual Studio. To access this extension, download it directly from the Visual Studio Marketplace. Download Now Key Features: Provides an IDE wrapper for the uip-cli command line utility Quickly prototype Extensions using starter Extension Templates Build and upload Extensions and/or Universal Templates Pull the latest Universal Template source files from the Controller Download the full Universal Template package Debug Extensions locally without the need of Agent and Controller Note: End user often pair this extension with version control systems like Git or GitHub. In addition, if you prefer coding automated jobs and workflows, take a look at the jobs-as-code extension.

This Universal Extension provides the capability to 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, and Oracle databases. As opposed to the native UAC SQL Task, which runs on the Controller, this integration allows the user to run an SQL Task from the Agent.Key FeaturesFlexibility in database connection definition supporting DSN, FILE DNS and Connection String.Rich metadata information.Capability to store SQL results in files (CSV or JSON format).Rich Observability capabilitiesWhat's New in V3.1.0Added the option to retrieve SQL script to be executed via local path.Resolved issue which would cause the extension to crash when a path containing a '.' was specified in the Output File Path field.Breaking Changes:Version 3.0 is compatible from Universal Controller & Universal Agent 7.4 onwards. Dependent Python Libraries (pyodbc) are now bundled within the integration archive and do not have to be installed manually. Stonebranch is an SAP partner. Universal Automation Center (UAC) is certified by SAP for SAP S/4HANA and RISE with SAP S/4HANA® Cloud.