Database (Legacy)

Use the Database connector to select, insert, update and delete records in a database.

Solution Details

Solution Type: Platform Connector
Author: Boomi
Published on: May 16, 2026
Last updated on: May 16, 2026

Get Started

Key Features

Execute standard or dynamically built SQL queries at runtime based on input parameters
Perform Insert, Get, Update, Upsert, Delete, and Stored Procedure operations on database tables
Leverage connection pooling, document batching, and configurable fetch sizes for optimized performance
Manage transactions explicitly with Start, Commit, and Rollback operations for data integrity
Auto-generate request and response profiles from database table metadata and column data types

How it works

The Database connector enables seamless integration with any JDBC-compliant relational database, including MySQL, PostgreSQL, Microsoft SQL Server, and Oracle. It supports inserting, retrieving, updating, upserting, and deleting records, as well as executing stored procedures with IN, OUT, and INOUT parameters. Connection pooling, document batching, and configurable fetch sizes help optimize performance for high-volume data operations. Transaction control through explicit start, commit, and rollback actions ensures data integrity across complex integration processes.

Applications Required

Database (Legacy)