Marketplace - OP Database Transaction Operations

Demonstrates full transaction lifecycle management in OP Database — start, commit, rollback, savepoints, and named transactions across eight databases.

Solution Details

Difficulty Level: BEGINNER
Solution Type: Recipe
Author: OnePoint
Published on: May 30, 2025
Last updated on: Apr 22, 2026

Get Started

Key Features

Manage full transaction lifecycles with start, commit, and rollback in a single Boomi process.
Create named savepoints mid-transaction and roll back selectively without losing prior changes.
Handle transaction errors gracefully by try/catch blocks that trigger automatic savepoint rollback.
Execute CRUD operations and stored procedures within a single atomic, transactional workflow.
Support eight database platforms including PostgreSQL, Oracle, SAP HANA, and Microsoft SQL Server.

How it works

Safe Multi-Step Database Workflows
Enables developers to wrap multiple insert, update, delete, and stored procedure operations inside a single transaction, ensuring all changes either succeed together or roll back cleanly on failure.

Granular Error Recovery with Savepoints
Allows teams to set named savepoints mid-transaction so that a failed step rolls back only to that point, preserving earlier successful operations without scrapping the entire transaction.

Advanced Transaction Management Starter
Provides a ready-to-use reference process for implementing named transactions and multiple savepoints — capabilities exclusive to OP Database and not available in the standard Database V2 connector.

Applications Required

OP Database