Oracle GoldenGate Supported Processing Methods and Databases
Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, Non-Oracle platforms across the enterprise. It moves committed transactions with transaction integrity and minimal overhead on your existing infrastructure. Its modular architecture gives you the flexibility to extract and replicate selected data records, transactional changes, and changes to DDL (data definition language) across a variety of topologies.
Note:
Support for DDL, certain topologies, and capture or delivery configurations varies by the database type.
Here is a list of the supported processing methods.
| Database | Log-Based Extraction (capture) | Non-Log-Based Extraction (1) (capture) | Replication (delivery) |
|---|---|---|---|
|
DB2 for i |
N/A |
N/A |
X |
|
DB2 LUW |
X |
N/A |
X |
|
DB2 z/OS |
X |
N/A |
X |
|
Oracle Database |
X |
N/A |
X |
|
MySQL |
X |
N/A |
X |
|
SQL Server |
N/A |
X |
X |
| Terradata | N/A | N/A | X |
Footnote 1 Non-Log-Based Extraction uses a capture module that communicates with the Oracle GoldenGate API to send change data to Oracle GoldenGate.
Note:
Non-Log-Based Extraction uses a capture module that communicates with the Oracle GoldenGate API to send change data to Oracle GoldenGate.