Trigger Polling Page
You can poll for new or changed records.
Note:
No order is maintained while polling records.Polling Page
The following table describes the key information on the Polling page.
Element | Description |
---|---|
Import Tables |
Import the tables and select the root database table for the service query. |
Remove Tables |
Remove the selected table from the service query tables list. |
Review and manage root database table relationships |
Appears after importing tables. Select Edit to open the Manage Table 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. |
Search and Import Tables Page
The following table describes the key information on the Search and Import Tables page. The Search and Import Tables page appears when you select Import Tables on the Polling page.
Element | Description |
---|---|
Schema |
Select the schema for the tables and views you are importing. Special characters (for example, |
Table Name |
The name of the table to which the schema or view is applied. The Table Type list next to the Table Name field allows these selections:
|
Search |
Click to search for the specified table type. |
Available |
Lists the elements of the table type available for selection. |
Selected |
Lists the selected table type. |
Primary Keys Page
The following table describes the key information on the Define Primary Keys page.
Element | Description |
---|---|
Primary Keys |
This page appears when you select tables without a primary key defined. Select the virtual primary keys for the table type. Note: Having the primary key at the database level is the best practice. |
Manage Table Relationships Page
The following table describes the key information on the Manage Table Relationships page. The Manage Table Relationships page appears when you select Edit for the Review and manage root database table relationships option on the Polling page.
Element | Description |
---|---|
Create New |
Opens the Create Relation page with these options:
|
Detach |
Opens the Relationships list in a new window. |
Attribute Filtering Page
The following table describes the key information on the Attribute Filtering page. This page appears when you click Edit for the Review and verify table and relationship attributes option on the Polling page.
Element | Description |
---|---|
Attributes View |
Review the attributes in the object model created from the imported tables and the defined relationships and uncheck any attributes to exclude from the database queries. Primary key attributes cannot be excluded. |
Polling Strategy and Options Page
The following table describes the key information on the Polling Strategy and Options page. The Polling Strategy and Options page appears when you select Edit for Review the polling strategy and specify polling options on the Polling 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 threshold size, that particular record is updated to REJECTED instead of READ. If the outbound operation returns a response greater than the size allowed, the response message is ignored and a fault response is sent to the calling client. For details about supported sizes, see Service Limits in Provisioning and Administering Oracle Integration 3. |
Polling Frequency (Sec) |
Specifies the polling frequency (in seconds) for new records or events. |