Database Adapter

Architecture

Data Base Step Processor

Data Base Retrieve Step Processor

Functionality

In the database adapter, we are able to access and perform operations on different databases such as MySQL, MS SQL, and Oracle. The adapter has separate functionality for Database Insertion Step Processor and Database Retrieve Step Processor, as well as a Database Step Processor. Native insert queries are used to fetch data directly from the database, and it is possible to connect to stored procedures to extract insert data.

The adapters inherit from dbHandler, which performs logical operations on the data. The handler processes data in different ways, such as through stored procedures and batch queries. Database connection details and queries are passed through steps, with the step type corresponding to the respective adapter. Once the database connection is established successfully, a query statement is created from the step data and executed on the database.

Capabilities

• Directly fetch the data from the database using normal queries

• Can connect to stored procedure & extract the insertion data

• Retrieval and insertion of multiple records is possible

DB Handlers

DB Insert Handler

DB Retrieve Handler