Trigger Polling Page

The following table describes the key information on the trigger Polling page.

Note:

Sequential order is not always maintained while polling records.

Element	Description
Add Tables	Import tables and the root database table for the service query.
Remove Tables	Removes tables. Select Remove Tables, clear the check box to the right of the table you want to remove, and click OK. You cannot remove the root database table.
Review and manage parent database table relationships	Appears after importing tables. Select Edit to open the Relationships page where you can view, create, and remove relationships between tables.
Review and verify table and relationship attributes	Appears after importing tables. Select Edit to open the Attributes Filtering page where you can review, verify, select, or deselect the attributes in the object model created from the imported tables and the defined relationships.
Review the polling strategy and specify polling options	Appears after importing tables. Select Edit to open the Polling Strategy and Options page where you can define the polling strategy and specify polling options.

Trigger Manage Tables Page

The following table describes the key information on the trigger Manage Tables page. The trigger Manage Tables page appears when you select Add Tables on the adapter trigger Poll for a New or Changed Records page.

Element	Description
Schema	Select the schema for the tables and views you are importing.
Table Type	The type of the table to which the schema or view is applied. The list allows these selections: All — Select all available tables and views. Table — Select tables. View — Select views.
Table Name	Specify the table name. Table names are case sensitive.
Search	Click to search for the specified table.
Available	Lists the tables that meet the selection criteria.
Selected	Lists the selected table.
Filter By	Type the initial letters to filter the display of table names.
Primary Key	Appears when you select tables without a primary key defined. Select the virtual primary key for the table. Note: Having the primary key at the database level is the best practice.

Trigger Relationships Table

The following table describes the key information on the trigger Relationships page. The trigger Relationships page appears when you select Edit to review and manage the parent database table relationships option on the adapter trigger Poll for a New or Changed Records page.

Element	Description
Create New	Opens the Create Relation page with these options: Parent Table — Select the parent table for the relationship between tables. Child Table — Select the child table for the relationship between tables. Relationship — Defines the relationship between the parent and child tables. Attribute Name — Apply attributes to the table relationship. Mapping — Provide the mapping for the table relationship.

Element

Description

Create New

Opens the Create Relation page with these options:

Parent Table — Select the parent table for the relationship between tables.
Child Table — Select the child table for the relationship between tables.
Relationship — Defines the relationship between the parent and child tables.
Attribute Name — Apply attributes to the table relationship.
Mapping — Provide the mapping for the table relationship.

Trigger Polling Strategy and Options Page

The following table describes the key information on the trigger Polling Strategy and Options page. The trigger Polling Strategy and Options page appears when you select Edit to review the polling strategy and specify polling options on the adapter trigger Poll for a New or Changed Records page.

Element	Description
Logical Delete Field	Selects a field in the root database table. To allow the selection, polling must be enabled in the Status column.
Read Value	Identifies the value that is used to indicate a row has been read (for example, PROCESSED). Surrounding quotes are not required.
Unread Value	Indicates the rows to process. Only rows with logical delete field and column values that match the Unread Value are read.
Rejected Value	Set to REJECTED. If the incoming message is greater than the 10 MB threshold size, that particular record is updated to REJECTED instead of READ. If the message payload is greater than 10 MB, a fault response is sent to the calling client.
Polling Frequency (Sec)	Specifies the polling frequency (in seconds) for new records or events.
Advanced Options	Click Edit to access the Batch Size field to specify the number of table rows to process during a single transaction. The default value is 1 and the maximum value is 50.