Oracle GoldenGate Valuable Features

Vijay Manoharan - PeerSpot reviewer
IT Technical Specialist at a healthcare company with 10,001+ employees

The product is reliable for data integrity. We haven't had any data loss issues. The product does what it is supposed to do. It performs real-time replication without data loss. Most of our replication is unidirectional. When there are bidirectional replications, we use conflict detection and resolution. We can use the tool to define that one database has more priority on certain applications and another on others.

View full review »
ShahidNadeem - PeerSpot reviewer
DBA at Virgin Media

For small databases that are less than a terabyte, GoldenGate handles the migration well. You don't need much input so long as the processes don't upend. As soon as there's a problem, then, obviously, you need to diagnose it. It all depends on the scenario, on the size of the databases, whether you're doing schema replication, or table replication. We normally do the whole database, taking everything across. Finally, because this is an Oracle product, there is support available 24/7.

View full review »
SJ
Cloud Migration Software Consultant - UK & EMEA at 1PLACE

What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace.

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.
AO
Database Manager at State of New York

CDC is the most valuable feature. 

View full review »
IfeoluwaOshinowo - PeerSpot reviewer
Senior Oracle Database Administrator at Computer Information Systems (CIS)

The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios. Secondly, its versatility in supporting data replication across different operating systems and platforms is highly valuable, making it the go-to tool for heterogeneous environments.

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

The live application feature is most valuable.


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

One feature that stands out for me is the data center capability. Leveraging Azure servers, we can effortlessly synchronize data between servers, whether it's from one source to another. This is done seamlessly without the need for additional configurations, just a simple pump to facilitate the process. Another noteworthy feature is its adaptability to changes in the source, such as the addition of a new column or details in Oracle. There's no necessity to modify subsequent processes; a service adjustment suffices, streamlining the workflow. Its reliability is commendable, and maintenance is both straightforward and efficient. Additionally, it facilitates customization for specific market needs. Overall, it is not only user-friendly but also easy to comprehend in various aspects.

View full review »
Vipin Mani - PeerSpot reviewer
Software Engineering Manager/VP at a financial services firm with 10,001+ employees

Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support.

View full review »
Petr Pertov - PeerSpot reviewer
Database Engineer at a computer software company with 51-200 employees

Data migration is the most valuable feature of Oracle GoldenGate.

View full review »
Arsim Kosumi - PeerSpot reviewer
Database System Specialist at TEB SHA

This is a powerful tool.

It is stable and offers good reliability. The server never crashes. 

It is quite scalable. 

The initial setup is very easy. 

View full review »
SV
Solution architect at a energy/utilities company with 10,001+ employees

The solution supports large-volume databases. Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful. The solution is helpful as the databases need to be available as DC and DR.

View full review »
AM
Senior Oracle Database Admin at mrcc

I signed with Oracle to use GoldenGate for this project five months ago. I needed two or three months just to explore GoldenGate to get to know it and the features. There are many awesome features in GoldenGate and from what I see in the case studies, I need some more months of discovery to know what I think are the most valuable features. If you call me a month from now, I will be able to answer the question as to which of the excellent features are the most valuable. Right now it would be that I have confidence that GoldenGate can handle this extensive project.

View full review »
ShanmugaSundaram - PeerSpot reviewer
Vice President - Database management at a financial services firm with 10,001+ employees

The replication of the data table is one of the best features.

View full review »
Anand_Kumar - PeerSpot reviewer
Enterprise Architect - Application & Analytics at DXC Technology

The solution's existing SaaS platform for data integration gives us an edge because many other features' functionalities are available, such as real-time dashboarding and data analytics.

View full review »
Arun Kumarasamy - PeerSpot reviewer
Exadata ,Senior Oracle DBA and Goldengate Consultant at a tech vendor with 10,001+ employees

The solution is useful for data transformation.

View full review »
LP
Senior Database Engineer at a financial services firm with 10,001+ employees

Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility.

View full review »
SP
Database Administrator at a manufacturing company with 10,001+ employees

It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability.

It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality.

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

Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).

View full review »
XB
Data Analysis Lead at a insurance company with 10,001+ employees

I am impressed with the tool's possibility of integrating different systems in a unified place. 

View full review »
Parwaz Khan - PeerSpot reviewer
Head of Data Analytics at Bupa Arabia

The most valuable features of Oracle GoldenGate are the schema application and performance.

View full review »
OM
Consultant at National Water Company

GoldenGate is a perfect product. It's very stable and can integrate heterogenic systems. I believe GoldenGate is one of the best Oracle products.

View full review »
Gaurav Batra - PeerSpot reviewer
Managing Solution Architect at a computer software company with 1-10 employees

I like that the product transforms data and provides real-time applications.

View full review »
PY
Application Enterprise Architect Lead at a transportation company with 10,001+ employees

The product's micro service architecture is scalable. 

View full review »
AE
Senior Technology Consultant at a tech services company with 11-50 employees

Oracle GoldenGate has a lot of benefits. You can use Oracle GoldenGate as a DR for your system. You can use the solution if you don't want to have unnecessary recovery using synchronization or have some restrictions, like character suit or limited use.

Oracle GoldenGate can help if you have only to replicate the subset of your data and not the full data. Suppose you are in an organization with many branches and are interested in replicating only the accounting and not the financial data. In that case, Oracle GoldenGate will help you with some considerations, calculations, and transformations associated with it.

View full review »
Jon Davies - PeerSpot reviewer
Director at a healthcare company with 11-50 employees

It works best with Oracle.

View full review »
ST
Associate Architect - Oracle Database at Virtusa Global

Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments.

View full review »
it_user522123 - PeerSpot reviewer
Technical Specialist at a healthcare company with 1,001-5,000 employees

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.

View full review »
OD
Technical director at RDTEX LLC

What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2.

View full review »
NC
Database Architect and Oracle ACE Director at Chandler Systems

It's the simplicity. It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful.

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

With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database. You can easily monitor and maintain the system, and it doesn't need a primary key for sync; it reads from log shipping and the table. Oracle GoldenGate is a good product for syncing the database.

Oracle GoldenGate is a good product that works best with Oracle. Oracle GoldenGate's monitoring is good. You can easily see the detailed logs, timestamp points, and status of each table.

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

The OGG CDC is flexible and robust but complex to manage. The OGG version with microservices is very important to us because we need to monitor and manage all the database sources. The current OGG monitor is limited to our operations and we built one for our needs using the OGG microservices.

View full review »
AM
Senior Manager at PricewaterhouseCoopers

The most valuable feature is data replication capability.

View full review »
Armando Souza - PeerSpot reviewer
Oracle Solutions Architect at Viceri

GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources. 

View full review »
PS
Senior Manager of System and Database at ESL

We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema.

The solution is quite stable.

They've recently improved the ease of implementation.

View full review »
it_user837 - PeerSpot reviewer
Senior Manager of IT at a tech company with 51-200 employees
Data replication is seamless, once it is setup on a database. No triggers to setup. View full review »
AE
Fintech Project Manager at a comms service provider with 10,001+ employees

The most valuable feature of this solution is its compatibility with Oracle DB and Oracle products, generally, as our environment is really dependant on them.

The flexibility for customization as well as the scalability of the tool is very important, as we expand our environment we can expand and scale up the tool on the go.

View full review »
AZ
Oracle Advisory Engineer at a tech services company with 11-50 employees

The solution's most valuable feature is its ability to integrate with multiple platforms.

View full review »
MA
Oracle ERP DBA Conultant- Oracle Super Cluster T5-8 Admin at a government with 1,001-5,000 employees

GoldenGate can connect and collect data from multiple sources, such as SQL Server.

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

The most valuable feature is the CDC (Changed Data Capture), which captures only the changes that are made to the data. This has the lowest load on the production database, and it runs very quickly in the background.

Reading directly from the log file makes updating the databases very fast.

View full review »
it_user809553 - PeerSpot reviewer
DBA

You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time. In my experience, it is able to transform a large amount of data within a few seconds.

View full review »
it_user276738 - PeerSpot reviewer
Solutions Developer at a music company with 51-200 employees
  • Replication by SCN
  • Ability to perform basic data transformation/call user-defined functions
  • Exception handling
  • CDC capabilities when used with ODI
View full review »
it_user807540 - PeerSpot reviewer
Solutions Architect Manager at a tech services company with 51-200 employees

The most valuable feature of this solution is data replication. When we are replicating data between similar databases then it is straightforward.

View full review »
it_user1221 - PeerSpot reviewer
Database Expert at a tech company with 51-200 employees
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. 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.