Oracle GoldenGate Benefits

Prashant Sukhe - PeerSpot reviewer
Sr Director / Architect at a computer software company with 201-500 employees

One notable improvement the organization experienced is a significant reduction in response time and minimal delay in the Oracle database.


View full review »
GS
Managing Partner at Gs Consultoria em Ti LTDA

It's an incredible tool, as it's quite impressive to construct the gateway. The process is surprisingly quick, and it has been around for a considerable period. I would say it operates seamlessly, eliminating the necessity for any data transformation or Excel-related tasks. You can simply input the data and retrieve it effortlessly. The gateway allows for easy management, providing clear insights. It's truly reliable and stands out as an excellent tool.

View full review »
GO
Data Quality Software Development Manager at Yapı Kredi Bank

Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.

With the upgrade, I now can able to replicate Big Data solution from any supported source system to Hadoop clusters.

View full review »
Buyer's Guide
Oracle GoldenGate
March 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
NC
Database Architect and Oracle ACE Director at Chandler Systems

It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers. Whether that's taking us from on-premise to the cloud or whether that's just going from server to server, either on-premise or within the cloud itself, it's an excellent solution.

View full review »
KB
Managing Partner at a tech services company with 51-200 employees

With Oracle GoldenGate, you will have ODS databases, and you can create a foundation layer on top of it. You can also directly create ODS reports or operational reports. Every customer has 10 to 20 systems. When you put all of them into the same ODS structure, you can also enable integrated reports.

View full review »
CF
Chief Enterprise Architect at a non-profit with 1,001-5,000 employees

Our use case is complex and with Oracle GoldenGate we are improving the efficiency of the data replication and mostly the maintenance and operations support. We are in the process of migrating the current solution (based on queuing and web services) to Oracle Goldengate. Our current data synchronization process is old and not efficient enough to deal with 3000 data sources.

With Oracle Goldengate, we have more control over the CDC phase, and we can improve our management process which is critical for us.



View full review »
AE
Fintech Project Manager at a comms service provider with 10,001+ employees

This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation. There is minimal effort required for maintenance, which would be performed by non-dedicated DBA.

View full review »
NM
Data Analyst & BI Specialist at ABS SCANDINAVIA ApS

Using this solution has improved both the speed and efficiency of the data replication process. Prior to this, I used packages with merge functionality for replication. The process was very slow, and sometimes had negative effects on the production database. This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.

View full review »
it_user809553 - PeerSpot reviewer
DBA

If you have one environment that is for some application and it has a lot of data, and you need this information not only for the application but also for a warehouse - to do some analytics later - you just transform all that data to the warehouse and then you can work with it.

View full review »
it_user276738 - PeerSpot reviewer
Solutions Developer at a music company with 51-200 employees
  • Ability to implement zero-downtime migrations
  • Ability to scale horizontally
  • Ability to use ODI and Goldengate for real-time ETL
View full review »
Buyer's Guide
Oracle GoldenGate
March 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.