Marketplace - OP Database - Partner connector CRUD Operations

Demonstrates full CRUD capabilities of the OP Database connector — insert, update, upsert, delete, custom queries, and stored procedures.

Solution Details

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

Get Started

Key Features

Execute all CRUD operations—insert, update, upsert, delete, and get — across eight database platform
Choose from three operation modes: Standard, Dynamic, and Entity for flexible query configuration.
Run custom read and write SQL queries directly within Boomi for advanced data control.
Trigger stored procedures natively via the connector to leverage existing database business logic.
Restore database state automatically via a setup sub-process for consistent, repeatable testing.

How it works

Full Database Operation Coverage
Gives developers a single recipe to explore and validate all core database operations — insert, update, upsert, delete, and get — across multiple query modes and database platforms.

Flexible Query Mode Selection
Supports Standard, Dynamic, and Entity operation modes, enabling teams to choose the right approach for their use case — from static SQL to runtime-built dynamic queries with minimal configuration.

Stored Procedure and Custom SQL Execution
Allows developers to run stored procedures and custom read or write SQL queries natively within Boomi, enabling full reuse of existing database logic without rebuilding it in the integration layer.

Applications Required

OP Database