Boomi Introduction

Boomi is a cloud-based integration platform that allows businesses to easily and quickly connect their various applications, data, and systems. It offers a wide range of scalable and flexible integration capabilities, such as data integration, application integration, and API management, to integrate on-premises and cloud-based applications.

Boomi is used for creating and deploying integration between various enterprise systems like Salesforce, SAP, Oracle and other cloud-based platforms (AWS and Azure). It has a drag-and-drop visual interface and minimal coding, pre-built connectors, which helps businesses to connect and streamline their process.

Advantages of Boomi:

Effective with its drag-and-drop feature.
Boomi AtomSphere Integration is stable.
Excellent Data Quality and management.

Boomi comes up with lots of advantages but has limitations as well. One of which is explained below.

Limitation:

In Boomi, we have lots of prebuilt connectors, but after some connector operations (Ex: Disk, Database, Mail etc.), the process execution does not continue. This generally happens when no response document is generated by the connector operation. This can be seen mostly after a write/post operation.

Solution:

There might be multiple solutions available to handle such a situation, but let’s take a simple example to understand this.

Let’s start,

Here, the requirement is to perform multiple operations on the same data set, including a database write operation. All these operations are sequential but the catch is Database write operation does not generate any document and hence flow got aborted after database operation.

In this example, we have to insert records in database and on successful insertion we have to display success result else error result

Image: Process execution is stop

As you can see in above example there is no document generated after database write operation and process execution got aborted which leads to not satisfying requirement.

Here is one solution that overcomes Boomi limitations for database connector that is we can use the Branch Shape connector to take this operation forward.

What is Branch shape?

Branch shape is a predefined connector that works as a sequential operation. We can define a number of paths in branch shape according to need. Each branch shape can have up to 25 paths and a minimum of two paths. If path one executes successfully, then after second path will execute.

Contact us today to learn how we can help you to implement integration solutions with Boomi.

Here we go, by using a branch shape we got a success response back from the flow after successful database insertion.

Image: Success scenario

As we can see in the above image, after a successful database operation, the flow was redirected to another path that contained the success message and was required as per our requirements.

Let’s take another use case to explore more if we receive any error from database operation.

Image: Error scenario

In the above image, we can see the error occur during database operation, but due to the function of branch shape the other path also got terminated and try catch shape comes in picture to handle the exception.

What is Try/Catch?

The keywords “try” and “catch” represent the handling of exceptions caused by data or coding errors during process execution. A try block is a section of code where exceptions occur. Exceptions from try blocks are caught and handled by a catch block. The try block code is executed first, and if it throws an exception, the catch block code is executed.

In this manner, other actions can be performed after any connectors operation that do not generate any documents after it’s execution.

Perficient + Boomi 

At Perficient, we excel in tactical Boomi implementations by helping you address the full spectrum of challenges with lasting solutions rather than relying on band-aid fixes. The end result is intelligent, multifunctional assets that reduce costs over time and equip your organization to proactively prepare for future integration demands. 

Contact us today to learn how we can help you to implement integration solutions with Boomi.