Oracle Database CDC readers

For an introduction to reading from Oracle, see Oracle Database.

Striim offers two CDC readers to read data from your Oracle databases: Oracle Reader and OJet.

Oracle Reader and OJet can both 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.

OJet's primary advantage over Oracle Reader is higher throughput. Striim recently published a white paper documenting OJet's ability to read 160 GB of CDC data per hour: see Real Time Data Streaming from Oracle to Google BigQuery and Real-time Data Integration from Oracle to Google BigQuery Using Striim.

See the table below for a detailed feature comparison.

Feature comparison: Oracle Reader and OJet

	Oracle Reader	OJet
supported versions
Oracle Database 11g Release 2 version 11.2.0.4	✓	✓
Oracle Database 12c Release 1 version 12.1.0.2 and Release2version12.2.0.1	✓	✓
Oracle Database 18c (all versions)	✓	✓
Oracle Database 19c (all versions)	✓	✓
Oracle Database 21c (all versions)	✓	✓
Amazon RDS for Oracle	✓ all versions listed above	✓ all versions listed above except 21c
supported topologies
PDB / CDB	✓	✓
application PDB		✓
RAC (all versions)	✓	✓
can read from
primary database	✓	✓
logical standby database	✓	✓
Active Data Guard non-CDB standby database	via archive log
Active Data Guard CDB standby database	via archive log (through version 19.9 only)
Data Guard physical standby	via archive log
downstream database		✓
reference-partitioned tables		✓
key features
DML operations replicable in target	INSERT, UPDATE, DELETE	INSERT, UPDATE, DELETE, TRUNCATE
schema evolution	✓ for 11g to 18c only, not for PDB / CDB	✓ for all supported versions
uncommitted transaction support	✓
Striim-side transaction caching	✓
recovery	✓	✓
quiesce	✓	✓
bidirectional replication	✓	✓
SSL	✓	✓
Oracle Native Network Encryption	✓	✓
supported when Striim Platform is running in Microsoft Windows	✓
summary of supported data types (for full details, see Oracle Reader and OJet data type support and correspondence)
BINARY_DOUBLE, BINARY_FLOAT, CHAR, DATE, FLOAT, INTERVALDAYTOSECOND, INTERVALYEARTOMONTH, JSON, NCHAR, NUMBER, NVARCHAR2, RAW, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARCHAR2	✓	✓
ROWID	✓
VARRAY	see Oracle Reader and OJet data type support and correspondence
BLOB, CLOB, LONG, LONG RAW, XMLTYPE	see Oracle Reader and OJet data type support and correspondence	✓
BFILE	see Oracle Reader and OJet data type support and correspondence
ADT, NESTED TABLE, SD0_GEOMETRY, UDT, UROWID

Striim provides wizards for creating applications that read from Oracle and write to various targets. SeeCreating an application using a wizard for details.

To learn more about these CDC readers or purchase them, Contact Striim support.

Oracle Database CDC readers

Feature comparison: Oracle Reader and OJet

Search results