Database
The Database connector allows you to process or retrieve data in any JDBC supported database using Database drivers. It enables you to Insert, Get, Update, Upsert, Delete and Execute Stored procedures on the data available in the database.
Solution Details
- Solution Type
- Platform Connector
- Author
- Boomi
- Published on
- May 16, 2026
- Last updated on
- May 16, 2026
Get Started
Get StartedKey Features
- Execute Insert, Get, Update, Upsert, Delete, and Stored Procedure operations against any JDBC-compliant database
- Build SQL queries dynamically at runtime or use standard prepared statements with parameterized inputs
- Leverage connection pooling, document batching, and configurable fetch sizes for optimized performance
- Manage transactions with Start, Commit, and Rollback operations to ensure data integrity
- Auto-generate request and response profiles from database table metadata including special character support
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 Insert, Get, Update, Upsert, Delete, and Stored Procedure operations with both standard prepared statements and dynamically built SQL queries. Connection pooling, document batching, and configurable fetch sizes ensure high-performance data processing at scale. Transaction management capabilities—including Start, Commit, and Rollback—provide robust data integrity for complex integration scenarios.
Applications Required
- Database