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.

Learn More

Related Solutions

Accelerator

Boomi EDI Dashboard

Simplify EDI with End-to-End Visibility

Recipe

Cloud Atom Migration

Kick start your cloud atom migration process using this recipe. By utilizing Atomsphere API, various parts of the migration are automated.
Learn more

Recipe

Local Atom Migration

Kick start your local atom migration process using this recipe. By utilizing Atomsphere API, various parts of the migration are automated.
Learn more