Goldengate with Oracle EBS R12.2.8
We need to replicate tables /view from Oracle EBS R12.2.8 database to Oracle operational Data source hence we are planning to leverage Oracle Golden gate for real time data replication . Please let know how may tables from oracle EBS we can replicate using golden gate , is there any limitation on number of tables that can be replicated using golden gate . Does golden gate has any constraint replicating edition enabled tables/view in Oracle EBS R12.2 ? , best approach to follow for replication , how to identify master table v/s transnational table in Oracle EBS for replication
What should be the better approach to build operational data source for Business Intelligence reporting which provide near real data transaction