Connect with the Database V2 Connector
Last updated Fri Jun 10 2022
Begin your journey with connecting to the Database V2 connector, which includes:
- Quick steps for configuring the HTTP Client connectors to connect to Database V2
- Quick steps for retrieving, modifying, and storing data using Database V2 operations
- Method examples for Get, Insert, and Store Procedure operations
Overview:
The Database V2 connector uses Java Database Connectivity (JDBC) to connect and communicate with supported databases using Database drivers. It allows the processing of data operations on available data in the database. Relational databases, such as MySQL, PostgreSQL, and Oracle, can also be connected using the connector.
Increase performance in retrieving, modifying, and storing data in a database using the Database V2 connector. Each example process in the solution demonstrates various data operations to explore for users to leverage. This helps users to make confident decisions with trusted data to enhance business use cases.
This solution consists of six example use case processes that are grouped into Get, Insert, and Store Procedure operations, which are Get Operation using Connection Properties, Standard Get Operation IN Clause using Multiple Table, Standard Get Operation IN Clause using Single Table, Insert Operation using JSON Datatype, Insert_Operation_ReturningIDValue, and Store Procedure Operation using JSON Datatype. Each process establishes a connection to the Database V2 connector by configuring the the HTTP Client Connector with the appropriate credentials. These steps are taken to perform the desired action and output the expected results.
The recipe qualifies for Boomi’s Recipe Program
This Recipe is eligible for Boomi’s Recipe Program – that bundles free expertise from the Boomi PSO team included in the price of this prebuilt offering. The Boomi experts will help you get set up faster than ever, allowing you to get the most out of the Boomi AtomSphere Platform.