Oracle Database
The Oracle Database connector allows you to select, insert, update, delete, upsert records and also allows you to call stored procedures in an Oracle 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 select, insert, update, delete, and upsert operations against Oracle database tables
- Call stored procedures directly from integration processes for complex data logic
- Dynamically build SQL statements based on input parameters without manual query writing
- Leverage Oracle Wallet and TCPS connectivity for enhanced authentication and encryption security
- Support XMLType data types for handling XML-based content stored in Oracle databases
How it works
The Oracle Database connector enables seamless integration between Boomi and Oracle databases, supporting core data operations including select, insert, update, delete, upsert, and stored procedure execution. It leverages OJDBC drivers to communicate with the database, offering both manual SQL statement entry and dynamic SQL generation based on input parameters. The connector supports Oracle Wallet and TCPS for enhanced security, and operates across local and cloud runtime environments. Organizations can streamline database-driven workflows by mapping Oracle data to and from virtually any connected system within the Boomi platform.
Applications Required
- Oracle Database