This frequently asked question comes in several variants, including:
Can I use Oracle GoldenGate with EBS on-premises to set up an operational reporting environment in Oracle Cloud?Yes. We have certified the use of Oracle GoldenGate to create and run an EBS reporting environment for on-premises. A reporting environment is a secondary (duplicate) instance, which contains selected tables replicated from the primary EBS database. This enables read-intensive, custom reports to be run without using resources on the primary Oracle E-Business Suite database. While we have not formally certified use of GoldenGate to create and run an EBS reporting environment in Oracle Cloud, this is technically feasible and would work the same way as on-premises.
If you wish to explore this option, refer to our standard documentation for guidance and recommendations:
Can I use Oracle GoldenGate Cloud Service with EBS?No. The use of Oracle GoldenGate Cloud Service with Oracle E-Business Suite is not currently certified.
Can I use Oracle GoldenGate to replicate my EBS database to Oracle Cloud?
No. Oracle GoldenGate cannot be used to replicate an EBS database, because it does not support replication of all the datatypes used by EBS.
Can I use Oracle GoldenGate to perform a live migration of my EBS database from on-premises to Oracle Cloud?No. Oracle GoldenGate cannot be used to perform live database migrations from on-premises to Oracle Cloud, again due to restrictions with EBS datatypes.