Recommendations to others considering Oracle GoldenGate:
Those who are looking for replication mechanism between production and non production databsee then they can confidently go ahead with Oracle goldengate. Also goldengate can be used widly for both side replication mechanism as well. Which will be surely an multilevel software we can use it as data recovery mechanism, we can use it as replication for reporting, we can use it as a back mechanism as well Review collected by and hosted on G2.com.
What problems is Oracle GoldenGate solving and how is that benefiting you?
For a huge remedy databse running reports over the production system creates more performance issues. By using Oracle goldengate the production data is replicated to another databse and using the same data the reports will provide the live data to customers. I would suggest to use unidirectional goldengate in such reporting scenario and bidirection configuration in area where both the databse will go under editing and both edited data should be at sync. Review collected by and hosted on G2.com.