# Dell Boomi Connector

Dell Boomi is an ETL Tool that supports crawling database objects and Lineage Building. Dell Boomi offers a cloud-based integration platform called Atoms that transfers data between on-premises applications and the cloud. Integration with the cloud is enabled through APIs, lifecycle management, and event-driven architecture for the Dell Boomi connector.

<figure><img src="https://content.gitbook.com/content/hTnkoJQml0pok9awFDhx/blobs/FfxYPnVH7JdHHyA06fat/boomi.webp" alt=""><figcaption></figcaption></figure>

## **Supported Data Objects**

| **Feature**      | **Supported Objects** | **Remarks**                                                                           |
| ---------------- | --------------------- | ------------------------------------------------------------------------------------- |
| Crawling         | Process, Component    | It will Crawl the existing process available in the environment.                      |
| Lineage Building | Process, Component    | It will connect all the components and build lineage with the source and destination. |

{% hint style="success" %}
**Note:** The Dell Boomi connector also supports OE tables and Datasets.
{% endhint %}

## **Prerequisites**

The following are prerequisites required to establish theDell Boomi connection.&#x20;

<table data-header-hidden><thead><tr><th width="92.75"></th><th width="223.25"></th><th></th></tr></thead><tbody><tr><td><strong>Sl. No</strong></td><td><strong>Item List</strong></td><td><strong>Description</strong></td></tr><tr><td>1</td><td>Account ID</td><td><p>Account ID of the Organization to connect to Dell Boomi.</p><p>Ex: ovaledge-9KEK45</p></td></tr><tr><td>2</td><td>User Name</td><td>Example: prasad.gandi@ovaledge.com</td></tr><tr><td>3</td><td>Password</td><td>Example: Prasad@123</td></tr><tr><td>4</td><td>Environment ID</td><td>Example: 810e84cb-f2f9-4bc0-b949-2415c188daa1</td></tr></tbody></table>

{% hint style="success" %}
**Note:** The User should have the Read Permission to validate and crawl the source system.
{% endhint %}

## **Connection Details**

To connect to the Dell Boomi using the OvalEdge application, complete the following steps.

1. Log in to the **OvalEdge** application
2. Navigate to **Administration** > **Crawler** module.
3. Click on the + icon, and the **Manage Connection** with Search Connector pop-up window is displayed.&#x20;
4. Select the connection type as **Dell Boomi**. The Manage Connection with Dell Boomi specific details pop-up window is displayed.
5. The following are the field attributes required for the connection of Dell Boomi.<br>

   | **Field Name**      | **Mandatory/Optional** | **Description**                                                                                                                                                                                                                                     |
   | ------------------- | ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
   | Connection Type     | Mandatory              | By default the selected connection type is displayed as the Dell Boomi.                                                                                                                                                                             |
   | License Type        | Mandatory              | You can choose the License Type as Standard/ Auto Lineage.                                                                                                                                                                                          |
   | Connection Name     | Mandatory              | <p>Enter the name of the connection, the connection name specified in the Connection Name textbox will be a reference to the Dell Boomi database connection in the OvalEdge application.</p><p><strong>Example:</strong> Dellboomi\_Connection1</p> |
   | Boomi accountid     | Mandatory              | Enter the account ID, which will appear in the Dell Boomi connection URL.                                                                                                                                                                           |
   | Boomi User Id       | Mandatory              | Enter the User Id from which user you want to connect to the Dell Boomi from OvalEdge.                                                                                                                                                              |
   | Boomi Envid         | Mandatory              | Enter the Boomi Deployment Environment ID.                                                                                                                                                                                                          |
   | Boomi User Password | Mandatory              | Enter the Password to connect to the Dell Boomi.                                                                                                                                                                                                    |

6\. Once after entering the connection details in the required fields, click on the **Save** button to establish the connection.&#x20;

7\. Click on the Validate button to validate the entered connection details. Once the connection is validated successfully, the connection will be established and displayed on the Crawler Information page.<br>

## **Error Validation Details**

<table data-header-hidden><thead><tr><th width="95.25"></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Sl. No</strong></td><td><strong>Error Messages</strong></td><td><strong>Description</strong></td></tr><tr><td>1</td><td>Error while Validating the connection with Accountid</td><td>Incorrect Boomi Account Id</td></tr><tr><td>2</td><td>Error while Validating the connection with user</td><td>Incorrect Boomi User Id</td></tr><tr><td>3</td><td>Error while Validating the connection with user</td><td>Incorrect Boomi User Password</td></tr><tr><td>4</td><td>The authenticated user does not have access rights to this functionality.</td><td>In case the User doesn’t have complete access permission</td></tr></tbody></table>

## **Connection Settings**

Only the Lineage setting option is available for the Dell Boomi Connector, and the setting option will be enabled when the **Auto Lineage** License type is selected.

The purpose of the lineage setting is to serve the option of changing the server/source connection to build the lineage. You can configure multiple servers simultaneously in the  **Selecting Source Server Type for lineage** and also set the connection priority lists to pick the tables in the **Connections Priority to pick the source table** for lineage building.

## **FAQs**

Components support by OvalEdge&#x20;

1. What are the types of Jobs OvalEdge supports for DellBoomi?

* **Process**: Processes are the central components in Boomi Integration. They contain a series of shapes that determine how data is executed within the system. A process typically represents a discrete workflow that moves a given type of record from one application to another.
* **Connector Action**: Connector actions are used to get data into and send data out of a process. Most processes have one "get" connector and one or more "send" connectors. The Connector action uses a combination of predefined connection and operation components to establish where and how to get or send data.
* **Maps**: Data is transformed from one format (profile) to another using Maps.
* **Business rules**: Use the Business Rules to work with the profile structure of a document in order to check multiple business rules to determine if a document should be accepted or rejected.
* **Notify**: For the purpose of monitoring and troubleshooting, the Notify function can be utilized to write user-defined notifications to the process log.
* **Exception**: To terminate the execution of one or all documents and mark them as failed in Process Reporting, the Exception can be used with a custom error message. This message may include a mix of static content and dynamic variables.
* **Program cmd:** The Program Command enables database and system-level commands to be executed as part of the process flow.
* **Message:** To transform incoming document data into a free-form message using a combination of static and dynamic variables, use the Message.
* **Data process:** Within a process, the Data Process offers a variety of choices for modifying document data, such as splitting and merging documents, as well as compressing and decompressing data through zipping.
* **Stop:** Use the "**Stop**" command to terminate a process or halt the processing of a document.
* **Flow Control**: The Flow Control contains a set of options that allows user to configure how documents are processed within a process execution.
* **Return Documents:** Returns the documents to the calling source point.<br>
* **Decision:** To transform incoming document data into a free-form message using a combination of static and dynamic variables.
* **Business Rules**: The given document is evaluated against several "business rules" to determine whether it should be accepted or rejected.
* **Try**/**Catch:** It captures errors at the document level for instances where one or many documents fail during execution.
* **Route:** Documents are directed down different paths based on a specific value through conditional routing. This value can be static or retrieved dynamically from document properties or the document's actual data.

***

Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA