Oracle GoldenGate Primary Use Case

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

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.

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

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.

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

Our primary use case is for consultancy, more specifically for moving customers' data from on-prem into the cloud. We do this in conjunction with our product. We do not have to pay extra for the Oracle Enterprise Manager because our software can manage the GoldenGate software.

View full review »
Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.
AO
Database Manager at State of New York

Our primary use case is mostly for new environments and migrations, and sometimes updates. I'm a database manager. 

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

I have used Oracle GoldenGate for a couple of different scenarios. One client wanted to keep their main database secure, so we set up GoldenGate to replicate data in a separate environment for reporting purposes. This allowed users to query the replicated data without directly accessing the main database. Another client needed real-time access to historical data without active data guards, so we implemented GoldenGate to enable querying of archived data from both Oracle and non-Oracle sources. 

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

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.

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

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.

View full review »
Andre-Rocha - PeerSpot reviewer
Senior Database Specialist at Deverg

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.

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

We're using Oracle GoldenGate primarily to check data consistency, replication, and reporting.

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

I used Oracle GoldenGate for a pilot project involving the migration of an Oracle database to AWS using GoldenGate. It was one of the options considered for CICD migration. I attempted to build a pilot to demonstrate the proof of concept.

Our customers have different use cases for Oracle GoldenGate.

View full review »
Mukesh  Kumar - PeerSpot reviewer
Senior Software Engineer at a tech consulting company with 10,001+ employees

We use the tool to pull on-prem data. 

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

We primarily use the solution for the exchange of data between two databases. It's used for replication and some processes.

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

We use Oracle GoldenGate for homogeneous and heterogeneous data migration.

View full review »
AM
Senior Oracle Database Admin at mrcc

The areas we use for this product for is centralizing the collection of hospital data. In Saudi Arabia there are five special hospitals and each branch there is a local facility for data entry. Users enter data in the local database in their branches and the data is collected in a centralized database that is also in Saudi Arabia. These tools use criteria to identify cases that are similar in different hospital branches to help in diagnosis and treatment.

I am working on this project to serve as the administrator for the database. Before this, I joined a lot of projects, sometimes part-time, in Cairo and I gained 18 years of experience working on databases in the maritime ports in Arab countries and in hospitals in Arab countries, in Cairo, in Egypt, in Iraq, in parts of Spain and around the Arabian Sea. My primary responsibility is to make centralized data available.

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

We use GoldenGate for real-time data ingestion and integration.

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

If our data is in Oracle Database and we want to extract and transform the data to Azure or AWS, we use Oracle GoldenGate.

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

Oracle GoldenGate can be deployed on-premise and in the cloud.

We have some critical Oracle databases. Most of our marketing business data are in Oracle databases, we wanted to replicate this data to the downstream application. As part of that, we are using Oracle GoldenGate.

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

It supports data movement for heterogeneous platforms as well as homogeneous platforms. We are using it for both use cases. Some use cases are for secondary sites, and some use cases are for different applications, such as data warehousing. We are using its latest version.

View full review »
OM
Consultant at National Water Company

Right now we use GoldenGate adapt tools to integrate the Oracle database with Microsoft DataPoint. We also use GoldenGate for CDB and as a sophisticated feature for auditing on records and to help with records capture by GoldenGate. 

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

The solution is used for migrating and syncing data between heterogeneous systems.

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

I used Oracle GoldenGate for some migrations and consultations between different types of businesses.

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

We are using it for getting data back.

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

Oracle GoldenGate helps to replicate the changes in one environment on the other. For example, if a team installs new tables, those changes are mirrored on the other side.

View full review »
OD
Technical director at RDTEX LLC

My customer uses Oracle GoldenGate mostly for pumping data from one database to another, including data storage format changes. The solution is also used for migrating from one system to another and cross-platform migrations.

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

The primary use case, generally speaking, is either data migration or data loading from an OLTP system to a data warehouse. It's probably Oracle's primary product for migration to the cloud, to later migrate from on-premises into cloud with zero downtime.

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

Customers use Oracle GoldenGate because they need near real-time analytics to sync their source system to the ODS database.

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

We use the product internally to cover one of our data synchronization needs. The use case is likely to be unique in the world.

The solution involves 3000 pharmacies distributed geographically on several islands and continents. Each pharmacy has an ERP for managing pharmacy operations (sales, purchases, logistics, etc.). And we are synchronizing all the data and transactions that are generated in the ERP, with a central database (Exadata).

View full review »
AM
Senior Manager at PricewaterhouseCoopers

I am part of a consulting firm and we build database solutions for our customers. Oracle GoldenGate is one of the products that we assist our clients with.

It is primarily used to replicate data from the main database to a backup server.

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

We use GoldenGate to integrate and consolidate various databases. After this, we send the information to Oracle Cloud Analytics to generate reports. 

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

The solution in our organization is not used for execution. We use it for a few schedules and to replicate in different databases.

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

Our primary use for this solution is the replication of data between heterogeneous environments to implement a data hub. We use this for reporting purposes or to publish data to the various systems (acquire and publish technique) using multiple technologies and multiple platforms. They are typically Oracle DBs on Oracle platforms, with some different types of databases, like Teradata, and also sourcing data into Hadoop Big Data.

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

We use the solution for data recovery and integration with multiple databases.

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

Our primary use is to transfer data or tables in databases from one server to another.

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

We implement this solution for our customers, and our most recent deployment was for a client in France. The solution involved one central database and ten replicas that were distributed to the local offices. The central database is automatically updated as the replicas are changed, and similarly, when the central database is modified, each of the local copies is updated accordingly.

View full review »
it_user809553 - PeerSpot reviewer
DBA

The primary usage of the product is to transform data from one database to another, for an application.

View full review »
it_user807540 - PeerSpot reviewer
Solutions Architect Manager at a tech services company with 51-200 employees

We are a reseller, and we implement this solution for our clients. They are generally either government or financial institutions. These clients use other Oracle technologies for tasks such as identity management and business intelligence. This solution is used to replicate the data for purposes such as disaster recovery and high availability.

View full review »
Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.