Oracle Golden Gate Replication Architecture

Oracle ms sql postgre sql mysql and ibm db2.

Oracle golden gate replication architecture.

It enables high availability solutions real time data integration transactional change data capture data replication transformations and verification between operational and analytical enterprise systems. The goldengate replication topology includes the capture and transfer of the extracted data from the source database across to the destination database. Using this technology it enables cost effective and low impact real time data integration and continuous availability solutions. The oracle goldengate hub is an architectural concept that places the oracle goldengate software on a different host than the databases being operated against.

Oracle goldengate provides real time log based change data capture and delivery between heterogeneous systems. The captured data is written to a file called the source trail. Thanks to its oracle goldengate hybrid structure it can support replication in cross platform or database. The trail is then read by a data pump sent across.

This is the basic configuration. Figure 1 2 illustrates the logical architecture of oracle goldengate for initial data loads and for the synchronization of dml and ddl operations. The oracle goldengate architecture consists of four distinct modules and components. Oracle goldengate s modular architecture for database to database replication enables high speed reliability and flexibility.

Trails or extract files. In this post we ll understand the golden gate replication flow and examines each of the architectural components. Oracle goldengate features direct access to oracle database heterogeneous replication real time streaming and analysis microservices architecture for goldengate integrate with big data portfolio of integration solutions integrate with oracle veridata oracle management pack for oracle goldengate. Goldengate tutorial oracle goldengate concepts and architecture made simple.

I have done 2000 table replication with goldengate or sql server replication tool for dwh databases in many clients. Goldengate replication flow the typical goldengate flow shows new and changed database data being captured from the source database. Oracle goldengate is installed separately to the source and target servers and the configurations of the servers can be different. The hub must be located close in network proximity to the target database leading to two possible architectures.

Oracle goldengate capture oracle goldengate trail files oracle goldengate delivery oracle goldengate manager figure 3. Oracle goldengate is a comprehensive software package for real time data integration and replication.