Oracle GoldenGate Review

It replicates in real time between heterogeneous databases such as SQL Server, DB2, Oracle, Sybase.


Valuable Features

GoldenGate replicates in real time between heterogeneous databases such as SQL Server, DB2, Oracle, Sybase and others. In the next few years, we plan to use Oracle GoldenGate to real-time replicate to big data and the cloud.

Room for Improvement

Like everything else, it's getting complicated. I've been using it 15 years in the United States, which is probably at least the top one or two healthcare organizations in America, and it does quite an outstanding job. However, since GoldenGate was purchased by Oracle, it's become more challenging to work with. Obviously, Oracle is profitable but it's becoming quite tougher to work with.

For healthcare databases, there are three leaders for what they call EMRs, electronic medical records: Epic, the market leader in the United States; and then Cerner and GE/IDX. Oracle GoldenGate real-time replicates between databases, but not Epic's database, which is called Caché. Oracle does not do that. If you can come up with a product that replicates in real time from Caché to any other database such as Oracle, DB2, or SQL Server, you'll never have to work again. If you want to make a mint, that’s one thing it could do; it's wide open for somebody to tap into.

Use of Solution

I have been using it for probably 15 years.

Stability Issues

Stability is outstanding, far superior to IBM and other competitors. Real time replication, that's the key.

Scalability Issues

It is quite scalable. They're investing into migrating to the cloud, big data, bi-directional – to and from – real-time replication, streaming, and others.

Customer Service and Technical Support

The support from Oracle could be improved; it is sometimes a challenge. Candidly, and quite anonymously, we sometimes know the product better than the Oracle technical support does. Unfortunately, there are some communication challenges as well; understanding American English.

Other Advice

I recommend buying the product. It performs outstanding. If you want to offload from your online transaction processing, your application, to an enterprise data warehouse, data lake, etc., this is far beyond a superior tool to the competitors. It's worth the price.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email