Oracle ODI and GoldengatePosted: December 1, 2014
Goldegate vs Advanced Replication/Streams
Streams is Oracle only.
Active Data Guard is readonly, Golden Gate can write.
Golden gate links into Log Miner API (188.8.131.52+ specific patch) now and multi threaded (184.108.40.206).
Classic Log Capture still needed for remote databases and integration with Active Data Guard.
Oracle DR still Data Guard.
Goldengate license includes Active Data Guard.
Goldengate linked to Java Message Bus.
Golden gate allows subsetting at schema,table,column,row.
Golden gate low impact, knowledge module for integration.
Goldengate apply to staging area, or JMS queue to ETL tool (chargeable option) or send to flat files for consumption by Etl Tools (chargeable option).
Conflict resolution out of the box. Can also consume from Java Message Bus.
Script check for setup of Goldengate – database check and health check for integrated components.
Oracle Goldengate Coherence – real time.
Goldengate supports off box capture – do not need to install on vendor host.
Trail files used to store changes, universal Trail Format, no endian issues.
Can batch operations, can call to the database procedures as well. Simple transformation, calculations, no aggregations.
Non-oracle databases, reads transaction log.
Capture->Trail file ->Pump (transaction not complete files)->Trail file->Delivery.
Replication Hub possible.
Pump process checkpoint in source/target trail files.
Manager process will restart pump process if network going down.
Rman knows about goldengate now, qill not discard archived logs.
Bounded recovery – can checkpoint partial long running transactions.
RAC – use DBFS for trail files, Goldengate integrated into cluster software – grid control.
Trail files, checkpoint and bounded recovery files.
Can replay trail files from archive logs or source trail files.
If cannot install on source machine use oracle stub database on downstream machine.
Integrated Extract only 1 target can send to downstream machine directly, rest have to be via archived logs.
GoldenGate 12c adds integrated delivery and co-ordinated delivery for non-oracle databases (co-ordinator thread).
Streams can be migrated to Goldengate.
12c added capture for Informix.
Integrated components must be used for Oracle 12c multi-tenant databases.
SQL Server configure DSN,username,password.
Parameter file per Goldengate process.
Capture can be started from SCN or date/time or BEGIN NOW.
Audit tables – ignore deletes, convert all transactions to inserts.
Install Goldengate, start capture,backup.restore, start apply from specific SCN.
Can added metadata via GETENV function and convert all changes to inserts only for audit.
Goldengate Veridata compare source/target.
Veridata 12.1.3 – can fix as well, use literal primary key+hash of non-primary key columns.