Oracle GoldenGate Reviews

I work with Oracle Engineering System, which is the platform we use to run databases and applications for customers. We provide this platform to run applications on customer premises. We also sell products like Oracle Database, Oracle Active Data Guard, and Oracle GoldenGate. For customer requirements, I create solution sizing, ensuring the database replication and redundancy needs are met by using Oracle GoldenGate.

Oracle GoldenGate is beneficial for data replication and ensures secure data transport. We use it for database redundancy, and it is crucial for the replication of data. Additionally, Active Data Guard is an important feature for disaster recovery site applications, and we use other Oracle services like Oracle Diagnostic Pack and tuning pack.

I utilize Oracle GoldenGate for data replication. It is set to a master-master pluggable database setup that serves as a container. This is then used from clones to provide test environments for various teams.

The most valuable feature of Oracle GoldenGate is its ability to sync data in real-time, which is crucial for me. I set it to a master-master pluggable database that serves as a container used from clones to provide test environments for various teams. This makes it very effective in managing high-volume transactions. The ability to sync data in real time is a key feature I rely on.

We are using replication from the Paris site to the UK site, to Singapore, and the New York site as typical use cases for Oracle GoldenGate in our organization.

We need to stop the extract, modify the RPM, modify the replication RPM file, do the initial load, and restart it—these specific features of Oracle GoldenGate significantly enhance our data replication.

The real-time replication feature of the product is particularly beneficial.

I am using the graphical interface, which is very helpful for beginners. From the interface, you can check the flow, different flows, errors, and replication. You can analyze the configuration file without needing to connect to the server to find which RPM or process. The graphical interface is very helpful for beginners.

The solution is used for real-time data replication in our environment across RDBMS databases like SQL Server, DB2, Oracle, and SAP HANA. We also use it for Zero Downtime Migration. When an application has to run 24/7, we set up the application to a new server and a new database and keep it active 24/7.

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.

The key consideration in use case was determining if the solution performs better with Oracle databases compared to other database options. I played a role in evaluating both options to determine the most sensible choice.

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

We use it for a project involving data integration from two distinct sources within our factory. One source was an Oracle database, while the other was a MySQL database. Additionally, we incorporated data from a cloud-based Teradata system that Oracle had acquired. Our task involved configuring the data to create a unified data warehouse.

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.

I used Oracle GoldenGate once to integrate two tables in the last twelve months. I also used the solution to integrate two tables from IBM Big Data Analytics to the Oracle Database Services on the cloud.

The major problem in Oracle GoldenGate is the monitoring part. If you need to use the monitoring feature of Oracle GoldenGate, you need to pay a lot, meaning it is very expensive to use the plug-ins from Oracle, so sometimes a user needs to avoid using it. A user directly needs to use the scripts to monitor the integration, which works perfectly. Sometimes, a user finds it more difficult to discover the problem, though solving the problem is easy. It is difficult to discover what was the problem with the integration using Oracle GoldenGate since the logs were not very clear. With Oracle GoldenGate, the documentation was not very clear, even for the parts related to the table or DDL. In general, Oracle GoldenGate can't deliver good feedback from the logs.

We use GoldenGate for migrations, upgrades and when going from Oracle Spark to Linux, for example, so cross-platform. There are many use cases. We are customers of Oracle and I'm a DBA.

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.