Software AG Products 10.7 | Integrating On-Premises and Cloud Applications | Integration Cloud | Applications | Predefined Applications | Database | Database Application Operations
 
Database Application Operations
To use Database Application, you must create operations. Database operations allow you to connect to the database and initiate an operation on the database from Integration Cloud.
You call database operations from Integration to perform database operation on tables, views, or synonyms. The database operations are performed by calling JDBC APIs.
Operations are based on templates provided with Database Application. Each template represents an SQL statement for doing an operation on a database. For example, use Select operation to retrieve specified information from the database tables.
Creating a new operation from a template is straightforward. You will have to create an account using which you can create a new operation. During this process, select the operation template and configure the operation using the operation wizards.
Database Application provides the following operation templates:
Operation
Description
Batch Insert
Inserts new information into a database table. Use this operation when you insert a large volume of data into a single table.
Batch Update
Updates the existing information in a database table. Use this operation when you update a large volume of data in a single table.
Custom SQL
Executes custom SQL to perform a database operation.
Delete
Deletes rows from a database table.
Insert
Inserts new information into a database table.
Select
Retrieves specified information from the database table.
Stored Procedure
Calls a stored procedure. It obtains the stored procedure's input/output parameters by introspecting when you configure the operation.
Update
Updates the existing information in a database table.