Overview
These article provides essential information for setting up replications using Oracle as a source database. Syniti Replicates provides different type of replications using Oracle databases as a source system.
Non-Transactional Replication
Refresh: A one-time complete replication from source to target table, according to replication settings and scripts. Learn more for Oracle.
Transactional Replication
In a Mirroring replication, initially copy entire data set from source to target, then copy only changes from the source to the target database according to an interval. This approach is also well known as Change Data Capture. Syniti Replicate provides three options for transactional replications using Oracle.
Log Reader (default): Queries the Oracle Log Miner directly
Log Server Agent (optional): Uses a Windows service and a Log Server component to query the Oracle Log Miner
Triggers: Uses Syniti Replicate triggers installed on the Oracle database to log changes