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.

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.