Agentless Polling in Oracle Integration Using Public Gateway and ATP

Enabling Secure Inbound Polling Without Connectivity Agent

In Oracle Integration (OIC), polling-based integrations are a common way to process database-driven events. This blog walks through a simple and practical polling use case using the classic EMP table, enhanced with a custom column to control processing.

Use Case Overview
We want to:

• Add a column to track whether a record needs processing
• Use OIC to poll records from EMP table
• Process only specific rows
• Update status after processing

Step 1: Create ATP Connection
The Below is Reference for Oracle ATP connection in OIC.

Step 2: Create Integration

• I Prefer the Application Integration, Polling mechanism will work in the Initial Endpoint in the Integration.

• Call ATP Here as like below.

Make sure choose the Review the polling strategy and specify polling options

Note: Apply your requirement handling in the read & unread value W.R.T perform on the Column [HIKE is a column for my case]

• Whenever I update in HIKE column to "NO", The integration polling happens using ATP Polling Event & It will update the respective rows to "YES"

The Final Integration Design as below
I mapped EMPNAME as Primary Business identifier for track.

Step 3:TEST
I will update as below

Step 4:Integration Observation

• It will automatically calls & update the field to "YES"

Full Flow Summary

1. DB Record Update → HIKE = 'NO'
2. OIC Polling Query Runs
3. Record is Picked
4. Integration Logic Executes
5. Record Updated → HIKE = 'YES'

Conclusion

This EMP table polling example demonstrates a lightweight and efficient pattern for OIC integrations:

• Add a flag column
• Poll using a filter condition
• Process and update status

Combined with OIC Public Gateway and ATP Adapter, this becomes a fully cloud-native solution without any Connectivity Agent dependency.