- The Processing Method drop-down field is displayed.
- This field allows you to set the processing mode for the SQL query, either single- or batch-processing.
- If the single-processing method is selected, it executes the SQL statement once per message.
- If the batch processing method is selected, it will execute the SQL statement for multiple records. It accepts a collection (array).
- Select an appropriate value from the drop-down: either single or batch processing.
Image
- Now fill the SQL Source field.
- This field allows you to set the SQL source. The SQL Source setting determines how the SQL statement is provided to the Database unit.
- The drop-down provides the following options:
- Fix defined SQL statements:
- In this mode, the SQL query is statically defined in the Database Unit configuration.
- You can write the SQL statement in the SQL section directly.
- The SQL structure does not change at runtime. Only parameter values change.
- SQL statement dynamically picked during runtime:
- In this mode, the SQL statement is determined during flow execution.
- Instead of writing SQL directly in the unit, you can build an expression that can be selected based on the conditions. You can use variables to build the expression.
- Select an appropriate option from the drop-down.
- Once configured, click on the Save button provided in the action area of the screen.
Image
SQL
Based on the option selected in the SQL Source in the Control section, the fields will be shown in the SQL field.
The SQL section allows you to define the SQL statement that needs to be executed. Based on the selected SQL source, the section will display the fields.
- If the Fix defined SQL statements option is selected, the SQL section opens the SQL editor, and the following fields are shown.
- On top of the editor, a toolbar is provided to help you with the SQL editor.
- The editor allows you to write, drag, and drop variables or a message node from any message.
- Create your SQL statement from scratch.
Image
Delete SQL Statement
- You can delete any SQL statement using the delete option.
- To delete any SQL statement, click the Delete icon on the right.
Image
- On clicking the Delete icon, a confirmation pop-up will appear.
- Click Yes to delete the key.
- Click No to close the pop-up.
- Once the SQL statement is deleted, click on the Save button.
Image
Add Multiple SQL Statements
- You can add multiple SQL statements in the section.
- To add another key, click the (+) Add icon on the right.
- Please note that you can add another SQL statement after successfully creating the first one. If any placeholder is present and it is empty, you cannot add an additional SQL statement unless you fill in the values in the placeholder.
Image
- Clicking the (+) icon adds a new placeholder.
- You can create the SQL statement and then add another SQL statement placeholder.
Image
- If the SQL statement dynamically picked during runtime option is selected, the expression builder field will be shown.
- This field is mandatory. By default, the field will be displayed as a function field and represented with 'fx':
- Fx - Function:
- This field supports the Expression Builder, which helps you create logical expressions or formulas without writing complex code. An expression is a combination of Fields / Variables, Operators, Values, and Functions. It allows you to write your own expression.
- It provides a structured interface where you can:
- Select fields or variables
- Choose operators (like =, ≠, >, <, AND, OR, NOT)
- Add functions such as string, date, and math functions
- Build conditions step by step to ensure syntax is correct.
- Build your expression using the functionality. You can drag and drop any message node or variables in the expression editor to create your expression.
Please note that to fill the expression, you can drag and drop the nodeset from the Input section.
Image
Key Handling
Key Handling refers to how unique identifiers (keys) are managed, validated, and used within a flow or integration process. A “key” is typically a value that uniquely identifies a record, object, or transaction. It ensures the correct record is identified, tracked, and updated throughout the flow.
- Expand the band by clicking it. Once expanded, the following fields will be displayed:
- ID
- Primary Key
- OneEnterprise Message
- All fields are mandatory.
Image
- This ID field lets you assign a unique ID to each key. You can create multiple keys for key handling.
- This field is mandatory, and it is a text field where you can enter any alphanumeric key to create an ID. A maximum of 10 characters, 0-9 and A–Z, are allowed in the field.
Image
- This Primary Key field allows you to create a valid expression using the variables, strings, and fields from the Output section.
- This field is mandatory. By default, the field will be displayed as a function field and represented with 'fx'.
- However, you can change the field type to a fixed value type using the drop-down. The drop-down provides the following options:
- Fx - Function:
- This field supports the Expression Builder, which helps you create logical expressions or formulas without writing complex code. An expression is a combination of Fields / Variables, Operators, Values, and Functions. It allows you to write your own expression.
- It provides a structured interface where you can:
- Select fields or variables
- Choose operators (like =, ≠, >, <, AND, OR, NOT)
- Add functions such as string, date, and math functions
- Build conditions step by step to ensure syntax is correct
Please note that to fill the expression, you can drag and drop the nodeset from the Output section.
- A1 - Fixed:
- It allows you to use any alphanumeric keys.
- Create a primary key of your choice.
Image
- The OneEnterprise Message field is mandatory.
- Click on the drop-down to view the list of available OE messages. Select an OE message from the drop-down.
- Once the message is selected, click on the Save button.
Image
Delete Key from Key Handling
- You can delete any key using the delete option.
- To delete any key, click the Delete icon on the right.
Image
- Upon clicking the Delete icon, a confirmation pop-up will appear.
- Click Yes to delete the key.
- Click No to close the pop-up.
- Once the key is deleted, click on the Save button.
Image
Add Multiple Keys for Key Handling
- You can add multiple keys to handle key operations.
- To add another key, click the (+) Add icon on the right.
- Please note that you can add another key after successfully creating the first one. If any placeholder is present and it is empty, you cannot add an additional key unless you fill in the values in the placeholder.
Image
- Clicking the (+) icon adds a new placeholder.
- You can fill in the key details and then add another key.
Image
Extended Error Handling
Extended Error Handling is an advanced error management mechanism that enables a flow to detect, capture, process, and respond to errors in a controlled, structured way. The key functionality of this field is that it does not stop execution; it provides detailed control over how errors are handled.
- Expand the band by clicking it. Once expanded, the following fields will be displayed:
- Condition
- Info
- Category
- All fields are mandatory.
Image
- This Condition field lets you create a valid expression using the variables, strings, and fields from the Output section.
- This field is mandatory. By default, the field will be displayed as a function field and represented with 'fx'.
- This field supports the Expression Builder, which helps you create logical expressions or formulas without writing complex code. An expression is a combination of Fields / Variables, Operators, Values, and Functions. It allows you to write your own expression.
- It provides a structured interface where you can:
- Select fields or variables
- Choose operators (like =, ≠, >, <, AND, OR, NOT)
- Add functions such as string, date, and math functions
- Build conditions step by step to ensure syntax is correct
- Create a valid expression.
Image
- The Info field allows you to create a valid expression or fixed information as a string.
- This field is mandatory. By default, the field will be displayed as a function field and represented with 'fx'.
- However, you can change the field type to a fixed value type using the drop-down. The drop-down provides the following options:
- Fx - Function:
- This field supports the Expression Builder, which helps you create logical expressions or formulas without writing complex code. An expression is a combination of Fields / Variables, Operators, Values, and Functions. It allows you to write your own expression.
- It provides a structured interface where you can:
- Select fields or variables
- Choose operators (like =, ≠, >, <, AND, OR, NOT)
- Add functions such as string, date, and math functions
- Build conditions step by step to ensure syntax is correct
- Please note that you can use the variables, strings, and fields from the Output section only. A drag-and-drop function is also supported.
Please note that to fill the expression, you can drag and drop the nodeset from the Output section.
- A1 - Fixed:
- It allows you to use any alphanumeric keys.
- The supported values are 0-9, and a-z, and a maximum of 10 characters is allowed.
- Fill the Info field either using the expression builder or a simple string.
Image
- The Category field is mandatory.
- Click on the drop-down to view the list of available categories. Select an appropriate category from the drop-down.
- Once all the fields are filled, click on the Save button.
Image
Delete Category from Extended Error Handling
- You can delete any category using the delete option.
- To delete any key, click the Delete icon on the right.
Image
- When you click the Delete icon, a confirmation pop-up will appear.
- Click Yes to delete the key.
- Click No to close the pop-up.
- Once the key is deleted, click on the Save button.
Image
Add Multiple Categories for Extended Error Handling
- You can add multiple Categories for Extended Error Handling.
- To add another key, click the (+) icon on the right.
- Please note that you can add another key after successfully creating the first one. If any placeholder is present and it is empty, you cannot add an additional key unless you fill in the values in the placeholder.
Image
- Clicking the (+) icon adds a new placeholder.
- You can fill in the key details, then add another error-handling category.
Image
Output Section
The Output section displays the unit's final output message. The Output Message of the system call unit is the data generated after the unit completes execution. This final output of the unit is then passed to the next unit in the flow. The Output section provides the message in XML and JSON formats. You can switch between the tabs by clicking on them:
- Message Tab
- JSON Message Tab