Azure Blob: Manage File Transfers
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.
Azure Blob: Upload Local Directory
This integration allows users to upload a local Windows or Linux directory to an Azure Blob Storage container. As a result, you can integrate uploads of an entire local directory into your existing or new scheduling workflows, providing a true hybrid cloud (on-prem and cloud computing) file transfer solution. This integration makes it possible to automate your uploads in a way that's not available in the standard Azure SDK. 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, or any other cloud file transfer and integrate them into your existing scheduling flows. This integration offers multiple levels of security: All credentials for Azure Blob Storage are stored in an encrypted form in the database. Key Features: Calls the Python blobxfr module. The Python blobxfr module is called by a Universal Agent running on a Linux server or Windows server. The server running the Universal Agent needs to have Python 2.7.x or 3.6.x installed. All credentials for Azure are stored in an encrypted form in the database. Select different log-levels, e.g., info and debug. A proxy connection towards Azure is currently not implemented for this integration (however, it's possible with minor adjustments).
Azure Data Factory: Schedule, Trigger, and Monitor
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.
Azure Logic Apps: Schedule, Trigger, and Monitor Workflows
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 Virtual Machines: Start, Stop, and Terminate Instances
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.
E-Mail: SMTP and IMAP 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
Inter-Cloud Data Transfer
Stream data from one object store to another without intermediate storage. The Inter-Cloud Data Transfer integration allows users to transfer data to, from, and between any of the major private and public cloud providers like AWS, Google Cloud, and Microsoft Azure. It also supports the transfer of data to and from a Hadoop Distributed File System (HDFS) and to major cloud applications like OneDrive and SharePoint. Integrations within this solution package include: AWS S3 Google Cloud SharePoint Dropbox OneDrive Hadoop HDFS Key Features: Transfer data to, from, and between any cloud provider Transfer between any major storage applications like SharePoint, Dropbox... Transfer data to and from a Hadoop File System (HDFS) Download a URL's content and copy it to the destination without saving it in temporary storage Data is streamed from one object store to another (No intermediate storage) Very Fast, if the object stores are in the same region Preserves always timestamps and verifies checksums Supports encryption, caching, compression, chunking Perform Dry-runs Dynamic Token updates for SharePoint connections Regular Expression based include/exclude filter rules Supported actions are: List objects, list directory Copy/move Remove object/object-store Perform dry-runs Monitor object Copy URL
Microsoft Power BI: Refresh Business Intelligence
This integration allows users to refresh datasets and dataflows in the Microsoft Power BI business analytics service. Key Features: Refresh a dataset in a group-workspace or in my workspace. Refresh a dataflow in a group-workspace. Lookup datasets in a selected group. Lookup dataflows in a selected group. Connection to the Power BI REST API is done via the Python MSAL library. Supports Windows and Linux Universal Agents in order to connect to the Power BI REST API.
Microsoft SQL: Schedule SSIS Packages
This integration allows users to execute a Microsoft SSIS Package using the 'dtexec' utility, which comes with the Microsoft SQL Server installation. In addition, it's also possible to execute an SSIS package via a SQL job, which is executed by a procedure task stored by Stonebranch Universal Controller.
Microsoft SQL: Schedule SSRS
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.
Microsoft SQL: SSIS Package Execution
SQL Server Integration Services is a platform for building data integrations and data transformation solutions. This integration interactively allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. Further, it can trigger the SSIS package execution in the Microsoft SQL server and monitor the SSIS Package execution, and fetch SSIS logs to the universal controller once the SSIS package execution is completed.
Microsoft Teams: Monitor Channel
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.
Microsoft Teams: Notifications
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.
Microsoft Teams: Send and Receive Notifications
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: Send Message with Attachment
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)
SQL: Execute Scripts and Functions
This integration allows users to execute SQL scripts and functions against a MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and SAP HANA database. It uses an agentless connection via ODBC towards SQL Server, MySQL, and PostgreSQL, and the Oracle basic instant client to connect to an Oracle database. Key Features: Supports execution of SQL scripts for Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and SAP HANA: For SQL Server, MySQL, and PostgreSQL: all connections are agentless via ODBC.For SQL Server: Windows Authentication and SQL Server Authentication is supported. For SAP HANA: database connections are performed agentless using the SAP HANA client for Python. For Oracle: the execution of SQL scripts and Oracle PLSQL blocks are supported. Oracle connections are performed agentless using the Oracle basic instant client. Supports Universal Agent for both Linux/Unix and Windows. Select different log-levels, e.g., info and debug. Decide if the SQL-output is provided in the standard out or not. All passwords are encrypted using Stonebranch Universal Controller credentials.