OIC - ATP - Polling data

Usecase: Here, we will see how to poll data using ATP database.

Note:

Can we poll data as trigger using ATP DB:

• For direct connections (configured without using the connectivity agent), the Oracle Autonomous Transaction Processing Adapter can only be used for making outbound invocations as an invoke connection. This type of Oracle Autonomous Transaction Processing Adapter-specific connection cannot be configured as a trigger connection in an integration. Use cases related to inbound polling must be implemented using the scheduled orchestration integration pattern.
• If we create or configure ATP connection using Connectivity agent, then only we can poll data as trigger  from ATP Database.

Detailed screenshots:

Step1: create ATP connection using  connectivity agent

Step2: take an appdriven integration and configure the ATP poll for new or changed records as logical delete on STATUS field.

Put a logger

Insert some data in the db table

From Monittoring track instances

After polled:

Note : If we create direct atp connection without connectivity agent, then during trigger configuration, it will not allow you for the polling setups cause the feature is only supported with connectivity agent.