OIC Gen3 - New Feature - File Polling Feature using FTP trigger in OIC

Unlocking Efficient FTP Triggers: Using the New File‑Polling Feature in Oracle Integration Cloud (OIC Gen3)

Subtitle:
Learn how to automate smaller file reads from FTP servers using the built‑in file‑polling trigger in OIC Gen3 24.10+.

🛠 Use Case

Many integration scenarios require processing files placed onto an FTP server—like daily CSV or XML reports—without manual intervention. Prior to OIC Gen3 24.10, triggering on file arrival involved workarounds such as scheduled scripts or custom polling logic.

With the new File‑Polling feature, you can:

• Trigger OIC integrations based on new files matching a naming pattern.
• Auto‑load file contents as payload—ideal for lightweight file reads.
• Configure archive, delete, or reject handling.
• Avoid downloads, saving bandwidth and simplifying flow.

---

🔧 Solution Overview: Step‑by‑Step

1. Ensure Compatibility
   Verify you're running OIC Gen3 version 24.10 or higher—this is when FTP file‑polling became available.

2. Set Up FTP Connection
   In your OIC connection settings, choose or configure your FTP/SFTP source.

3. Use File‑Polling Trigger
   In the integration builder, select the “File Polling” trigger. You’ll see options for:

   • Polling frequency (e.g., every 5 minutes)
   • Source directory
   • Filename pattern (e.g., *.csv)
   • Schema type (CSV, XML), plus sample file upload support

4. File Handling Options
   Decide what happens after triggering:

   • Archive to another folder
   • Move after successful read
   • Delete automatically
   • Ignore delete‑errors to prevent retries
   • Reject invalid files

5. Design Integration Flow
   After the trigger, use the file’s contents payload to:

   • Parse with a schema
   • Route data to downstream systems
   • Handle errors via reject logic

6. Test and Validate (POC)
   Always run a proof‑of‑concept:

   • Drop a test file matching your pattern
   • Confirm the integration triggered as expected
   • Validate the post‑processing behavior (archive/move/delete)

7. Deploy and Monitor
   Once verified, deploy your integration. Monitor success/failure and adjust polling or file‑handling parameters as needed.

The below we see the demonstration how to poll a file: