Database Activities
- Creating or Editing a Database Activity Endpoint
Endpoints provide the database connection information that Studio and the Integration Appliance use to connect to a database. - Browsing Database Tables
Use the Browse Database Tables dialog box to dynamically select a table from the current list of tables in the database specified by the Endpoint. - Character Encodings
Set the character encoding at the database level, the table level, or the column or parameter level. - Database Entities and Activities
- Defining Columns for Old Values in Updates
- MaxPooledStatements Parameter
The MaxPooledStatements parameter is automatically defined and set with a default value for all types of Database Endpoints. - Oracle, Sybase, DB2, and Informix Parameters
In the Additional Parameters table of the Database Endpoint, define the connection parameters for Oracle, Sybase, DB2®, or Informix® databases. - Retry Options For Inbound Database Activities
This section contains the procedure for configuring the retry options for the following inbound database activities: Get Inserted Rows activity, Get Updated Rows activity, Get Deleted Rows activity, and Poll Table activity. - Retry Options For Outbound Database Activities
This section contains the procedure for configuring the retry options for the following outbound database activities: Execute Query activity, Insert Rows activity, Update Rows activity, Delete Rows activity, and Call Procedure activity - SequeLink Parameters
- Single-Table Inbound Database Activities
During run time, single-table inbound database activities poll if a database operation has occurred on any rows in the specified columns of a database table at the specified time interval. - Single-Table Outbound Database Activities
This section contains the procedures for configuring the following single-table outbound database activities. - Specifying Delivery Rules for Database Activities
Specify how messages will be delivered at the Delivery Rules pane. - Viewing Column Details
The View Column dialog box allows you to see detailed column information for tables as you enter a SQL statement in the Enter Query task of the Checklist for the Execute Query activity. This task describes how to access the View Column Details dialog box. - Working with Database Parameters
Parameters supply database-specific connection information for an endpoint. - Call Procedure Activity
During run time, the Call Procedure activity runs a stored procedure in a database. The stored procedure must be written and installed in the database before you can complete the configuration of the Call Procedure activity in Studio. - Execute Query Activity
During run time, the Execute Query activity runs a select SQL statement. - Poll Table Activity
The Poll Table activity checks if a database operation (insert or update) has occurred on any rows of a database table by checking the status of a special flag column at the specified time interval. - Testing an SSL Database Connection