webMethods Adapter for JDBC is an add-on to webMethods Integration Server that enables you to exchange data with relational databases through the use of a JDBC driver. The adapter provides seamless and real-time communication with the database without requiring changes to your existing application infrastructure.
Using Adapter for JDBC, Integration Server clients can create and run services that execute
transactions to retrieve data from, and insert and update data in, relational databases.
Adapter for JDBC enables you to configure the following components:
Adapter connections: Enable Integration Server to connect to database systems at run time.
You must configure an adapter connection before you can configure adapter services or adapter
notifications
Adapter services: Enable Integration Server to initiate and perform database operations on a
database. For example, an adapter service could enable a trading partner to query your
inventory database to determine whether a particular item is currently in stock. You configure
adapter services using adapter services templates, which are provided with AdapterforJDBC.
Adapter for JDBC provides the following adapter service templates:
Select SQL: Retrieves specified information from a database table and includes a mapping for an output field that stores the number of rows retrieved.
Insert SQL: Inserts new information into adatabase table.
Update SQL: Updates the existing information in a database table and includes a mapping for an output field that stores the number of affected rows.
Batch Insert SQL: Inserts new information into a database table. Use this service when you will be inserting a large volume of data into a single table.
The data source for the service can be from a flat file or from other services that generate an Integration Server document list.
Batch Update SQL: Updates information in a database table when dealing with a large volume of data. Use this service when you will be updating a large volume of data in a single table. The data source for the service can be from a flat file or from other services that generate an Integration Server document list.
Delete SQL: Deletes rows from a table and includes a mapping for an output field that stores the number of affected rows
Custom SQL: Defines and executes custom SQL to perform database operations. You can execute almost any SQL statement required by integrations, such as data management statements.
Dynamic SQL: Defines and executes a SQL statement, part of which you set at run time through the input field.
Stored Procedure: Calls a stored procedure to perform database operations.
Stored Procedure with signature: Calls a stored procedure to erform database operations. Obtains the stored procedure's parameters by introspecting and
listing the signature of the stored procedure at the time you configure the adapter service.
Execute Service: Executes a Java or flow service using a JDBC connection object from the Adapter for JDBC connection pool.