If you run Oracle Fusion Cloud Applications and have spent any time building extraction pipelines with BI Cloud Connector (BICC), you've probably run into the same tension: BICC is reliable, but it's batch-oriented, and large extracts can compete for resources with the live application. Oracle's answer to this is a new architectural layer called RODS (Read-Optimized Data Store), paired with a new customer-facing Data Extraction Tool. This post walks through what both are, how they fit together, and how they compare to the extraction tools most Fusion teams already know.
download copy is available in our linkedin Post - https://tinyurl.com/mv8k6sck
Youtube link our channel post - https://youtu.be/uaQ93AOaxDg?si=PV6XCz7L9ZN87NcN
What Is RODS?
RODS stands for Read-Optimized Data Store. It's built on Oracle Autonomous AI Lakehouse technology and is designed specifically for high-volume, read-intensive workloads. Rather than being a customer-facing product in its own right, RODS is best understood as an architectural layer — a continuously refreshed, read-optimized replica of Fusion's transactional data, sitting alongside the live application database.
The core idea is separation of concerns: extraction workloads should never compete with live transaction processing. Traditionally, reporting and integration tools like BICC, REST APIs, or BI Publisher either query the live Fusion database directly or are constrained to scheduled batch windows. RODS solves this by giving extraction tools an entirely separate environment to query, one that's kept in sync with Fusion but isolated from operational traffic.