Oracle Database continuous real-time replication using CDC

Striim offers two CDC (change data capture) readers to read data from your Oracle databases: Oracle Reader and OJet. Both can read from Oracle databases 11g and higher, RAC, and PDB / CDB. Both can read from a primary database, logical standby database, or Active Data Guard standby database

You can use Oracle Reader, which utilizes Oracle LogMiner for change capture, offering a non-intrusive approach with minimal database impact. You can deploy this adapter for workloads processing between 20 GB and 80 GB of CDC data per hour, and it supports all DML operations, including INSERT, UPDATE, and DELETE.

For high-volume scenarios, you can use OJet, which utilizes a high-performance log mining API capable of handling 150+ GB of data per hour. You can choose this option for high-volume, high-throughput CDC workloads in mission-critical applications where performance is paramount.

If not using an automatic pipeline wizard, before creating the continuous real-time replication application, see Switching from initial load to continuous replication of Oracle Database sources.

Alternatively, if you are already using Oracle GoldenGate, you can use Striim's GG Trail Reader, which reads from your existing GoldenGate trail files without requiring additional LogMiner sessions. You can use this approach with GoldenGate versions 11g, 12c, 18.1, and 19.1. If your Striim cluster is licensed for Oracle GoldenGate, the GG Trail Reader will be available in the Flow Designer. For more information, see Oracle GoldenGate.

See the table below for a detailed feature comparison.