Oracle Database
Oracle is a relational database management system developed by Oracle Corporation.
You can read from Oracle as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from Oracle in two phases—initial load, followed by continuous replication—as described in Building pipelines from Oracle Database. For a more detailed comparison of Oracle Reader and OJet, see Oracle Database continuous real-time replication using CDC.
Oracle Database feature summary
Feature | Initial load with Database Reader | Continuous real-time replication with Oracle Reader | Continuous real-time replication with OJet | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|---|
Supported versions | ||||
Oracle Database versions 11g, 12c, 18c, 19c, and 21c self-managed (on-premise or in a cloud VM) | ✓ | ✓ | ✓ | ✓ |
Amazon RDS for Oracle versions 11g, 12c, 18c, and 19c | ✓ | ✓ | ✓ | ✓ |
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 | |||
19c non-CDB database downstream of a 19c non-CDB primary | ✓ | |||
21c database downstream of a 19c CDB or non-CDB primary | ✓ | |||
reference-partitioned tables | ✓ | |||
Security and governance | ||||
SSL/TLS | TLS 1.2 | TLS 1.2 | TLS 1.2 | TLS 1.2 |
Oracle Native Network Encryption | ✓ | ✓ | ✓ | ✓ |
connection profile | ||||
Sherlock AI | ✓ | ✓ | ✓ | ✓ |
Sentinel AIK | ✓ | ✓ | ✓ | ✓ |
Operations | ||||
initial load | ✓ | |||
initial schema creation | ✓ with supported targets | |||
schema evolution | ✓ for 11g to 18c only, not for PDB / CDB | ✓ for all supported versions | ||
DML operations replicable in target | INSERT, UPDATE, DELETE | INSERT, UPDATE, DELETE, TRUNCATE | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | ||||
automated pipelines | ✓ | ✓ | ✓ | |
other wizards | initial load only | change data capture only | change data capture only | initial load only |
Flow Designer | ✓ | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ | ✓ |
Runtime | ||||
event type of output stream | WAEvent | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | via JDBC driver | configurable automatic retries | configurable automatic retries | via JDBC driver |
recovery | ✓ | ✓ | ✓ | |
parallel threads | ✓ | ✓ | ||
metrics & auditing | ✓ | ✓ | ✓ | ✓ |