Use case for Oracle Goldengate to replication source:
- Logical replication from source to target, means SQL statement executed to propagate changes to target.
- Source and target database is heterogeneous, i.e. Oracle to SQL server, Oracle to MySQL.
- Source and target database is homogeneous i.e. Oracle to Oracle, SQL server to SQL server.
- Source and target database object structure is different.
- Rollback source transaction using Goldengate utility reverse.
- One column on source is mapped to different column on target.
- Prevent deletion of rows on target i.e. if rows are deleted from source and should not be deleted on target using Oracle Goldengate Event Market Interface.
- Only part of the row need to replicated from source to target.
- Filtered data is replicated from source to target using SQLEXE function.
- Prevent modification of certain data on target when source data is modified, and log data modification using Oracle Goldengate Event Market Interface.
Comments
Post a Comment