Oracle GoldenGate Reviews and Pricing

it_user1221

Database Expert at a tech company with 51-200 employees

Jul 20, 2012

Download

Great Replication tool which gives easy of setup and a small software footprint

Pros and Cons

"The setup is simple and it can handle bi directional replication very easily."

"Licensing cost is higher as compared to other replication products."

What is most valuable?

This product is meant to replace Oracle's Data Guard replication. The setup is simple and it can handle bi directional replication very easily. Training cost is minimal and most DBAs self learn this product. replication between various types of databases is supported and software foot print is very small . Change trails are not very big and easy to manage and store.

What needs improvement?

DDL (data definition language) replication is still to mature and can be an issue. Supplemental logging causes extra redo log generation in the log storage. Licensing cost is higher as compared to other replication products. Configuration of Golden Gate in HA (High Availability) mode needs setup of extra VIPs which can be challenging in a RAC environment.

What other advice do I have?

Integration of Golden Gate with monitoring tools like OEM (Oracle Enterprise Manager) is still not available and most DBAs monitor this with custom scripts. We chose this product mostly on it's bidirectional replication feature and easy setup. Some applications are using this as a messaging mechanism between multiple databases.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user126345Works

Report as inappropriate

Jun 9, 2014

Can we monitor using GUI tools like EM Oracle to Teradata replication using GoldenGate?

See all 5 comments

it_user837

Senior Manager of IT at a tech company with 51-200 employees

Jun 6, 2012

Download

Data replication is seamless but time to value can be long

Pros and Cons

"Data replication is seamless, once it is set up on a database."

"Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value."

Valuable Features:

Data replication is seamless, once it is setup on a database. No triggers to setup.

Room for Improvement:

Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user4401Developer at a transportation company with 1,001-5,000 employees

Report as inappropriate

Jun 24, 2014

As far as I know, there is a feature called Syncfile in Goldengate. Do you know if this feature can be used for E-business suite file synching? Thank you.

See all 2 comments