No Comments

    Leave a Reply

    3 + nineteen =

    RoboMQ Launches a Major Upgrade to Connect iPaaS with Michelangelo Release

    RoboMQ Launches a Major Upgrade to Connect iPaaS with Michelangelo Release

    Last week, RoboMQ launched its last release of Connect iPaaS for 2019. This release was named Michelangelo, after the famed renaissance sculptor and painter of the Sistine Chapel in the Vatican. Michelangelo is the third release to go live this year since the launch of Connect iPaaS in Q1, 2019. It is a major release that added a truckload of features and functionalities, covering core platform capabilities as well as the addition of many new API connectors for leading CRM, SaaS, analytics, databases and IoT applications.

    In this blog, we will the cover major additions and functionalities of Connect iPaaS under the following sections:

    1. Core platform features
    2. New ecosystems or application connectors.

    Core Platform Features

    Several new features are added to the core Connect iPaaS platform that are available across each of the ecosystems or the application API connectors supported by it. These new features provide major enhancements to the way workflows are designed.

    Some of the newly added features like conditionals, selective update and delete (in conjunction with the existing event filter functionality) provide powerful UX constructs that apply complex logic and conditional processing. These capabilities are more typical of BPM (Business Process Management) and BPEL (Business Process Execution Language), which are offered in a simple, intuitive and easy way for a business or a non-technical user.

    Conditionals

    Conditionals are the expression of selection criteria, or if-then-else logic, applied to actions or tasks in event processing. Previous to this release, Connect iPaaS supported adding selection criteria to event triggers, called a filter. When filters (or selection criteria) are applied to an event trigger, a user can choose which events of interest will be processed down the workflow. Conditionals, on the other hand, are applied individually to each of the actions or tasks that are executed in response to the event trigger. By using conditionals, each of the actions can select which events will be acted upon by that action.

    For example, take ServiceNow as an application where a “New Incident” is created. The new incident is the event trigger. We may want to only select the incidents that are related to the value “Network”. This can be done by applying the “Event Filter” that selects incidents where “Category” is equal to “Network” as shown below.

    Event selection using Event Filters
    Figure 1: Event selection using Event Filters
    You may want network incidents of “High” urgency to be assigned to an external vendor, which can be done by creating a new incident in the vendor’s PagerDuty system. To do this, you will create an action in the workflow that will apply Conditionals to selectively process ServiceNow incidents of “Network” category that have the “Urgency” field set as “High”.
    Selective Action processing using Conditionals
    Figure 2: Selective Action processing using Conditionals

    “Conditionals” is a powerful feature that allows you to take multiple actions in response to an event trigger, and each one of the actions designates the set of events that it prefers to act on. In addition to the above example, one may want to add an SMS action to notify the in-house support team for network incidents of medium urgency by using the conditional, “Urgency equals Medium”, for the SMS action in this workflow.

    Selective Update and Delete

    Continuing the theme of providing complex conditional processing and execution logic that is typical of enterprise grade BPM platforms, Connect iPaaS has added the capability to apply selection criteria when updating or deleting entities or objects in a CRM, ERP or other SaaS application. Often a workflow will have an action that updates or deletes entities in response to a trigger event. Using selective update, users can select the specific entity based on certain attributes of the trigger.

    In the example below, a Microsoft Dynamics 365 account is updated in response to an account updated in Salesforce which meets the following conditions – 1) the Account Number starts with X12B and 2) the Account Rating is Default.

    Selective update or delete in a task or action in a workflow
    Figure 3: Selective update or delete in a task or action in a workflow

    Excel style functions for data transformations


    An important value creating activity in building API and data integration workflows is the ability to mesh data and apply transformations among multiple application systems. Many of the users of Connect iPaaS are business users and are often very comfortable with Microsoft Excel. We therefore decided to provide Excel style functions for data transformation and mapping. Excel style functions offers a power paradigm for ease of use in data mapping and transformation with absolutely no learning curve.

    Excel style functions for data transformation on Connect iPaaS
    Figure 4: Excel style functions for data transformation on Connect iPaaS

    Bulk data feed and file processing

    In the application integration space, file-based integration, extract processing, bulk data export and imports are some of most common integration scenarios. In this release, we have added full support of file and extract processing. Users can generate an extract of data from ERP and CRM systems like Salesforce and Dynamics 365 based on their preferred schedule and conditions. Users can also select the output fields in the extract. The generated extract or bulk data feed can then be processed by file-based connectors or be saved to data stores like AWS S3 or SFTP servers.

    Bulk data processing, in conjunction with Managed File Transfer (MFT) and connectors like S3, provides a powerful use case for data loading and ETL style file processing using APIs.


    Other UX and product feature enhancements

    In addition to the above, multiple enhancements have been done to Connect iPaaS to provide new incremental functionality, or to improve the User Experience (UX). Some of the notable improvements are:

    1. The ability to suspend and resume a workflow
    2. Enhanced event logging or observability
    3. User interface improvements
    4. Organization of user dashboard along three tabs – Design, Manage and Observe – representing activities that the user can perform for API Integration on Connect iPaaS

    New ecosystems or application API connectors


    Last but not least, a large number of ERP and SaaS application connectors including analytics, databases and IoT gateways have been added as part of the Michelangelo release. These include:

    1. Microsoft Dynamics 365 – CRM and ERP application
    2. Coupa – Enterprise Expense Management
    3. Magento – Leading eCommerce application
    4. QuickBooks – Accounting software
    5. Workday – Human Resource Management and ERP
    6. SAP C4 – Customer Relationship Management
    7. Business Central and Dynamics NAV – ERP and Accounting
    8. HubSpot – Customer Relationship Management
    9. File Processing
    10. Azure AD – Cloud based Identity Management
    11. On-prem Active Directory – Identity Management
    12. Nexmo – Cloud Communication Platform
    13. Microsoft SharePoint – Productivity and Collaboration
    14. Microsoft Teams – Productivity and Collaboration
    15. WhatsApp – Chat, voice, video communication
    16. MS SQL Server – Database
    17. Azure SQL – Database
    18. AWS IoT – Internet of Things
    19. MQTT – Internet of Things
    20. Azure IoT – Internet of Things
    21. Tableau – Analytics and Business Intelligence
    22. TIBCO Spotfire – Analytics and Business Intelligence
    23. MongoDB – Document based database
    24. AWS Aurora – Database

    With these additions of new application connectors and enhanced core product capabilities, Connect iPaaS is the go-to platform for data and API integration of leading ERP, CRM, SaaS, cloud and on-premise enterprise applications. Our focus at RoboMQ has been to provide the best user experience (UX) for line of business and operations users with a simple, intuitive, easy to use and no-code iPaaS. We believe the Michelangelo release takes us much closer to our goal.

    Sign up a free trial to check out the new Connect iPaaS at https://trial.robomq.io/connect/ — and let us know what you think. Please feel free to contact us at sales@www.robomq.io for setting up a session with an expert to discuss your specific integration needs today!

    Did you enjoy this article? Subscribe below for RoboMQ updates:


    No Comments

      Leave a Reply

      seventeen − thirteen =

      You Might Also Like

      adult concentrated image

      With RoboMQ Developers Don’t Need to Learn New Programming Languages

      Many businesses in the tech world use specific protocols and programming languages. Typically, a developer would have to take the time and effort to learn a new programming language or an API (Application Programming Interface) in order to provide…

      Our Story

      It was 2012 when our founder and CEO Bramh Gupta was running middleware for telecom companies. He was managing critical business processes necessary for telecommunication business operations. This included cellular device activation and provisioning, where more than twenty-five systems…

      managers working together to fulfill service order

      Automate Order to Service Fulfillment With Salesforce and ServiceNow Integrations

      In business, the name of the game is efficiency. When a salesman has to spend hours organizing the details of a single order, he loses time he could have spent finding new leads. Let’s explore this scenario in the…

      No Comments

      Leave a Reply

      four × one =