Adapter Service Type | Adapter Service Template | Description |
Select SQL | SelectSQL | Retrieves specified information from a database table and includes a mapping for an output field that stores the number of rows retrieved. For instructions about configuring the service, see
Configuring SelectSQL Services. |
Insert SQL | InsertSQL | Inserts new information into a database table. For instructions about configuring the service, see
Configuring InsertSQL Services. |
Update SQL | UpdateSQL | Updates the existing information in a database table and includes a mapping for an output field that stores the number of affected rows. For instructions about configuring the service, see
Configuring UpdateSQL Services. |
Batch Insert SQL | BatchInsertSQL | 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. For instructions about configuring the service, see
Configuring BatchInsertSQL Services. |
Batch Update SQL | BatchUpdateSQL | 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. For instructions about configuring the service, see
Configuring BatchUpdateSQL Services. |
Delete SQL | DeleteSQL | Deletes rows from a table and includes a mapping for an output field that stores the number of affected rows. For instructions about configuring the service, see
Configuring DeleteSQL Services. |
Custom SQL | CustomSQL | Defines and executes custom SQL to perform database operations. You can execute almost any SQL statement required by integrations, such as data management statements. For instructions about configuring the service, see
Configuring CustomSQL Services. |
Dynamic SQL | DynamicSQL | Defines and executes a SQL statement, part of which you set at run time through the input field. For instructions about configuring the service, see
Configuring DynamicSQL Services. |
Stored Procedure | StoredProcedure | Calls a stored procedure to perform database operations. For instructions about configuring the service, see
Configuring StoredProcedure Services. |
Stored Procedure with signature | StoredProcedureWithSignature | Calls a stored procedure to perform 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. For instructions about configuring the service, see
Configuring StoredProcedureWithSignature
Services. |
Execute Service | ExecuteService | Executes a Java or flow service using a JDBC connection object from the Adapter for JDBC connection pool. For more information see
Using a Connection from the Connection Pool
Within a Java or Flow Service. For instructions about configuring the service, see
Configuring ExecuteService Services. |