ETL Pipeline for Oracle
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every second). Along the way it connects Oracle Database.
How it runs
Trigger: On a schedule (every second).
- Config (Code): runs custom JavaScript code
- Fan Out Tables (Code): runs custom JavaScript code
- Loop Over Tables (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract Changes (Oracle Database): execute
- Build Merge (Code): runs custom JavaScript code
- Load & Merge (Oracle Database): execute
- Advance Watermark (Code): runs custom JavaScript code
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Oracle Database
n8n-nodes-base.oracleDatabase - No Operation, do nothing
n8n-nodes-base.noOp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview A configurable ETL pipeline and data sync tool for Oracle database replication and data integration. On a schedule, it finds only the rows changed since the last run — an incremental sync — adjusts them if needed, and updates the target to…