The MSPro Boomi Collection
About
Good Practices & Patterns
Good Practices & Patterns
  • Markus' Boomi Integration
  • Implementation Patterns
    • The Cache Challenge
      • The Get-Or-Create Use-Case
      • PropCache Scripts
    • State Management
      • Example Scenario
      • State-Management in general
      • State-Management Functionality
      • Technical Solutions
        • Boomi File-System Implementation
          • saveState
          • readState & fetchStates
    • Exception Handling
      • Exception vs Error
      • Basic Rules
        • Aggregating Exceptions
      • Exception Handling Pattern
        • User-Defined Exception Messages
        • Catch Exceptions
      • The pattern in practice
        • API Error Handling
          • Single Record Strategy
            • Single Record RES
          • Many Records Strategy (Array)
            • Many Records RES
        • Pre-Condition Check
    • SQL Patterns
      • Script Header
      • General Rules
        • Check using RowCount
        • Check if record exists
        • Pagination and Sorting
        • Parameter - Best Practices
        • Use JSON as a complex parameter
    • Process Patterns
      • Process Route Implementation Pattern
      • Sub-Process or Process Route
    • DateTime
      • The Boomi datetime dilemma
      • Database and Flow
      • Groovy
      • Data Hub
      • Get Current Date
    • Groovy Script Patterns
      • Dynamic Document Properties
      • Dynamic Process Properties
      • Documents
    • Array Elements to Documents
  • MSPro Services
    • Intermediate Storage
      • Example Processes
        • Docs 01 - Update and Create
          • sub.SampleData.Invoice
        • 02 - Upsert and Get
    • Render Templates
  • Tips
Powered by GitBook
On this page
  1. Implementation Patterns
  2. State Management

Technical Solutions

Three options how to implement State-Management with Boomi

File-System

The simplest way to implement state-management with Boomi is using the file-system (Disk v2 connector). The (limited) state-management functionality should be implemented as re-usable Boomi sub Processes (process routes).

This solution is recommended for less than 100 states.

Boomi File-System Implementation

PRO

  • Can be implemented with Boomi as-is.

    • No additional applications or services are required.

CON

  • Limited capabilities to query and access states.

  • Slow. Querying records with a certain state requires to read all files data.

  • Managing states manually (working with files) is limited.

Database

Use any database, create a new table and manage states there.

The challenge with that is, that a database is s state-store only, not providing any state-management functionality. It requires a layer on top of the database, for example stored procedures or additional Boomi processes (like for file-system) to implement the state-management functionality.

PRO

  • Fast

CON

  • State-Management services have to be built on-top of the database, like API access for the customer.

  • Requires a database, and a DB admin.

Web-Service

This is probably the easiest and most complete solution to use a web-service to manage states. You can build your own service - welcome to think about its requirements - or you can use it out of the box:

Intermediate Storage

Last updated 6 months ago