Oracle Gloden Gate
Oracle Golden Gate is a best-of-breed, easy-to-deploy product used to replicate and integrate transnational data with sub-second speed among a variety of enterprise systems. Oracle Golden Gate provides the flexibility to move data between like-to-like and heterogeneous systems, including different versions of Oracle Database, different hardware platforms, and between Oracle and non-Oracle databases including Microsoft SQL Server, IBM DB2 for open systems and z/OS, Sybase, and more.
In ODS, we replicate the OIPA source schema transaction data to ODS staging schema via Oracle Golden Gate with the frequency set in Extract,Pump and Replicate processors. Once the data replicate to Staging schema via store procedures data is moved from staging to target.