Apache Airflow is an open-source platform created to programmatically author, schedule, and monitor workflows. This integration provides the capability to 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.      Key Features:   This Universal Extension provides the following main features: Triggering a new DAG run. Information retrieval of a specific DAG run. Information retrieval for a task that is part of a specific DAG run. Basic authentication (username/password) and SSL protocol. Using a proxy between Universal Controller and Apache Airflow server.  What's new v 1.1.0The action "Trigger DAG Run" has been enhanced. The latest release provides the ability to configure the task to wait for the execution of the DAG Run until it reaches the state of "success" or "failed". Depending on the final DAG Run state, the task finishes with a corresponding status ("success" or "failed").

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:   Support to consume messages by consumer group subscription, from a specific topic, until a specific condition is met. Filtering is based on the value of the message. When a matching Kafka message is detected, the universal task is finished by publishing information related to the matched message on extension output. Number, String and JSON filter patterns are supported. Support for authenticating to Kafka through PLAINTEXT or SASL_SSL SCRAM security protocol.   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.      

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  

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.

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

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

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)

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

This Universal Extension provides the capability to perform fast and secure data transfers between cloud-based storage services as well as local or distributed file systems. It acts as an interface to RClone, an open source command line program that manages data transfers and supports a vast number of Cloud Providers, including AWS, Google Cloud, and Microsoft Azure. A complete list of Rclone supported Cloud Storage Providers is available on the Rclone official site. Key Features This Universal Extension is an interface for Rclone and as an interface it supports the following key features: ActionsCopy objects between two storages, including copying and renaming the destination objects, as well as copying data from a URL.Move objects between two storages, including moving and renaming the destination objects.Synchronize two storages.List objects on a storage, including listing with details or in JSON format for machine parsing.Create objects on a storage.Delete objects from a storage.OptionsSupport 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.Capability not to overwrite files or objects during data transfersSupport for providing additional Rclone options according to the user needs.OutputProgress of the selected Action is visible, during Universal Task Instance execution.  

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.

This integration for SAP batch input allows users to schedule and execute batch input sessions in SAP. Batch input sessions enter data non-interactively into an SAP system. It's typically used to transfer data from non-SAP systems to SAP systems or to transfer data between SAP systems. Key Features: Runs a batch input session. You only need to provide the batch input session name in the task variable. It's possible to use wildcards (*) to run multiple batch input sessions. There's no need to create a variant manually for the batch input session in SAP. The SAP task uses the feature inline variants of USAP to create a temporary variant for the ABAP RSBDCSUB with the batch input session name. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration schedules any SAP BusinessObjects schedulable resource, including Crystal or Web Intelligence reports, from the Stonebranch Universal Automation Center.Using analytics tools to collect massive amounts of big data from your organization is one thing. Extracting meaning from that data and using it to drive real growth is another. BusinessObjects analytics from SAP can help you unleash the power of collective insight by delivering enterprise business intelligence, agile visualizations, and advanced predictive analytics to all users. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

SAP: BusinessObjects Scheduling Web Intelligence Documents and Crystal Reports is a centralized suite for data reporting, visualization, and sharing.  The integration for SAP BusinessObjects allows scheduling Crystal Reports and Web Intelligence documents. It supports multiple prompts and different output formats like PDF, EXCEL, and Webi.   Key Features Schedule SAP Webi reports Schedule Crystal Reports Support multiple prompts as input parameter Support different output formats like MS EXCEL, PDF, Webi Based on the latest RESTful web service SDK - no Agent needs to be installed on the SAP BO Server Exit code processing and error handling In case a report fails (for example, if you provide a wrong BusinessObjects ID, it will fail), and you can re-start the job with the correct ID. In case of a connection error, the task will fail (for example, wrong IP address or Port of the SAP BO HOST). In case a wrong password has been entered, the instance will fail.     We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration allows users to import the SAP factory calendar and related holiday calendars into the Stonebranch Universal Automation Center. You can use all valid SAP calendars or import a user-defined CSV file of specific SAP calendars. It's also possible to import calendars from different SAP systems. Key Features: Imports calendars that match the configured selection criteria into the Stonebranch Universal Controller (UC). Can be scheduled to always sync with SAP, e.g., import all calendars every day. The CSV list is saved (including versioning) into the UC script library. Runs on Linux and Windows Universal Agents. The calendar export is done using the SAP-certified XBP-RFC interface. SAP is always considered the master calendar; calendars are always exported from SAP, never imported to SAP. All calendar functionalities are supported, including factory, holiday and special rules. A calendar can be imported from a different SAP system automatically by adding the imported calendar's SAP system identifier and client number as a Postfix to the imported calendar. Set different log-levels for the integration, providing you with more information in case of issues. Support for application server and destination connections via 'nwrfc.ini' file, e.g., for load balancing and encryption. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration allows users to query the SAP event history table for the selected SAP event and parameter. If the event is found, it's confirmed so that it doesn't trigger again. It can also launch a task based on the occurrence of an event and parameter. Key Features:  Query the SAP event history table for a selected SAP event and parameter. For the parameter, wildcards (*) are supported. Confirm events in the SAP history table (transaction code SM62). Once the event and parameter have been identified, the event is confirmed in SAP so the monitor won't trigger a second time (optional setting). Launch a task in the Stonebranch Universal Controller, based on the occurrence of an event and parameter. Set different log-levels for the integration, providing you with more information in case of issues.Supported on Linux and Windows agents. Supports SAP application server and 'sapnwrfc.ini' destination connections. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration allows users to export SAP job definitions from SAP into one flat file for each job selected for extraction.  Key Features: Export SAP job definitions from SAP into one flat file for each SAP job. Any defined start criteria will be exported from SAP for each job. Jobs to be extracted can be in any status (scheduled, released, canceled, finished, etc.). The jobs to be extracted are provided via a list saved in the Stonebranch Universal Controller (UC) script library. A detailed log file will be provided after each extraction process to identify jobs that could not be found in SAP, e.g., a Jobname provided in the input file that doesn't exist in the SAP system. The extracted SAP job definition files can then read by the Stonebranch Conversion Tool (CTK), which transitions each read job definition file into an SAP task, including defined start criteria. Support for application server and destination connections via 'nwrfc.ini' file, e.g., for load balancing and encryption. Additional Info: The job definitions to extract from SAP are provided by a CSV input file saved in the UC script library. For each job to extract, the SAP Jobname and SAP Job Count ID must be provided in the input file.The extracted SAP job definition files can be read by the CTK, which transitions each read job definition file into an SAP task. If the SAP job is in 'released' status (meaning start conditions had been defined in SAP for that job), then a time trigger with the scheduling criteria will be created by the transition tool. As a result, the transitioned SAP task is ready to be scheduled in the same way as in SAP. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration allows users to schedule, trigger, and monitor the UiPath robotic process automation (RPA) process directly from the Stonebranch Universal Automation Center.  Key Features: Uses a Python request module to make REST API calls to the UiPath Orchestrator. It can trigger the RPA process in UiPath using the UiPath process name, Orchestrator base URL, UiPath account name, and service instance. Triggers the UiPath process for execution, monitors until process completion, and populates the results in the Stonebranch Universal Controller. It also features tight integration with IT service management tools, meaning that it can auto-create incidents in case of UiPath RPA process execution failure. Additional Info: Please note that the UiPath access token is used by this integration from the global variable named 'Uipath_access_token'. You can update the access token periodically through a web services task.

The Universal Connector for PeopleSoft integrates PeopleSoft systems with local administrative tools and enterprise system management infrastructures.This integration for PeopleSoft provides a way to automate and monitor processes at the business process level, eliminating technology silos and increasing IT effectiveness. It controls background processing within an Oracle PeopleSoft system, either from a command line or a Stonebranch Universal Controller task. The command-line interface allows any computer (and therefore any scheduling tool) on the network to manage PeopleSoft Process Scheduler background processing tasks via the local command line.Please note: This product is not available as a direct download from the Integration Hub. Once purchased, a Stonebranch expert will connect with you to help you access, install, and set up the integration. If you would like to speak with a Stonebranch expert prior to purchase, please contact us.  Key Features: Schedule processes, jobs, and JobSets. Start processes, jobs, and JobSets. Monitor processes, jobs, and JobSets. Return output associated with completed or failed processes, jobs, and JobSets. Hold processes, jobs, and JobSets. Cancel processes, jobs, and JobSets. Restart processes, jobs, and JobSets. Delete processes, jobs, and JobSets. Display process request information. Display job and JobSet schedule information. Display process parameters. Display output produced by processes. Display server constraint information. Display Process Scheduler prompt information. Additional Info:  Pricing note: Price listed is per PeopleSoft endpointUniversal Connector for PeopleSoft uses the PeopleTools web service API to enable seamless integration with the PeopleSoft Process Scheduler. Universal Connector for PeopleSoft supports PeopleSoft 8.42 and later.

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. With this integration, you can enhance and extend the workload automation and job scheduling capabilities supporting SAP environments via a feature-rich direct integration between the Universal Automation Center and SAP.Please note:  This product is not available as a direct download from the Integration Hub.  Once purchased, a Stonebranch expert will connect with you to help you access, install, and set up the integration.  If you would like to speak with a Stonebranch expert prior to purchase, please contact us.  Key Features: Improve control and visibility of end-to-end SAP processes. Manage all SAP business processes, including ABAP, process chain, InfoPackage, mass activity, Batch Input Map (BIM), and more. Optimized error handling that can restart at any point in the workflow, e.g., restart a multi-step job at ABAP step xy). Orchestrate workflows from a web-based browser or use standard SAP interfaces, including XBP and Schedule Manager. Visually design and orchestrate workloads with a browser-based, drag-and-drop workflow designer. Workload lifecycle management for DevOps using jobs-as-code and/or bundle-and-promote features (dev> test>prod). No software installation is required within your SAP instance, removing any version dependency. Full audit trails and reporting to maintain compliance.Pricing note:  Price listed is per SAP endpoint Additionally, the Universal Connector for SAP works directly within your Stonebranch Universal Controller. This option is for those who want more power and flexibility than standard SAP interfaces allow. With the Universal Controller, your team can centrally orchestrate complex workflows across many additional platforms and applications. Truly break down automation silos by creating workflows that span your entire ecosystem of applications and platforms.  Increase the value of your SAP ecosystem and enter the world of automation today. Check out all the SAP automations in the Stonebranch Integration Hub.We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

This integration allows users to query the SAP event history table for the selected SAP event and parameter. If the event is found, it's confirmed so that it doesn't trigger again. It can also launch a task based on the occurrence of an event and parameter. Key Features:  Query the SAP event history table for a selected SAP event and parameter. For the parameter, wildcards (*) are supported. Confirm events in the SAP history table (transaction code SM62). Once the event and parameter have been identified, the event is confirmed in SAP so the monitor won't trigger a second time (optional setting). Launch a task in the Stonebranch Universal Controller, based on the occurrence of an event and parameter. Set different log-levels for the integration, providing you with more information in case of issues.Supported on Linux and Windows agents. Supports SAP application server and 'sapnwrfc.ini' destination connections. We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.

A Web service is a method of communication between two electronic devices over a network.This integration provides the capability to call endpoints of foreign APIs. It is beneficial for Stonebranch SaaS customers accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their datacenter. As the integration is triggered from the Universal Agent, no additional firewall port for the Universal Agent needs to be opened. Key Features: Support for communicating with APIs using the HTTP(S)/REST protocol Support for Authorization towards the foreign API using Basic Authentication or OAuth2 token Support for HTTP Methods GET, POST, PUT, DELETE, PATCH Support for SSL Protocol Ability to use proxy between Universal Agent and target web service Ability for configuration of custom exit codes based on the web service response payload (Supported for JSON payloads) What's New in V 1.2.0The Extension Output is enhanced to include a new JSON attribute body_json. This attribute is populated with the Web Service response body as a JSON object when the Web Service response body is of type JSON.