2018-01-28T13:15:00Z

What is your primary use case for Oracle GoldenGate?

Julia Miller - PeerSpot reviewer
  • 0
  • 145
PeerSpot user
29

29 Answers

IfeoluwaOshinowo - PeerSpot reviewer
Real User
Top 20
2024-02-06T16:17:00Z
Feb 6, 2024

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.

Search for a product comparison
Arun Kumarasamy - PeerSpot reviewer
Real User
Top 5
2024-01-25T07:52:02Z
Jan 25, 2024

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

GS
Real User
Top 20
2024-01-12T20:36:15Z
Jan 12, 2024

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.

KB
Real User
Top 5Leaderboard
2024-01-12T13:01:01Z
Jan 12, 2024

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

Andre-Rocha - PeerSpot reviewer
Real User
Top 5
2023-12-19T12:34:22Z
Dec 19, 2023

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.

Prashant Sukhe - PeerSpot reviewer
Real User
Top 5
2023-11-13T17:11:51Z
Nov 13, 2023

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.

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.
Anand_Kumar - PeerSpot reviewer
Real User
Top 5
2023-08-17T04:37:15Z
Aug 17, 2023

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

Mukesh  Kumar - PeerSpot reviewer
Real User
Top 20
2023-07-26T04:51:17Z
Jul 26, 2023

We use the tool to pull on-prem data.

AE
Consultant
2023-06-12T15:11:00Z
Jun 12, 2023

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

ShahidNadeem - PeerSpot reviewer
Real User
Top 10
2023-05-12T10:40:50Z
May 12, 2023

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.

AO
Real User
Top 20
2023-03-09T22:00:41Z
Mar 9, 2023

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

Arsim Kosumi - PeerSpot reviewer
Real User
Top 10
2023-01-13T16:43:49Z
Jan 13, 2023

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

Vipin Mani - PeerSpot reviewer
Real User
Top 10
2022-11-23T09:41:52Z
Nov 23, 2022

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

OD
Real User
Top 20
2022-08-18T10:57:16Z
Aug 18, 2022

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.

LP
Real User
Top 5Leaderboard
2022-05-18T19:19:42Z
May 18, 2022

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.

Jon Davies - PeerSpot reviewer
Vendor
Top 10
2022-04-27T08:20:47Z
Apr 27, 2022

We are using it for getting data back.

SJ
Consultant
2021-10-18T16:55:00Z
Oct 18, 2021

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.

SP
Real User
2021-02-18T10:11:48Z
Feb 18, 2021

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.

MA
Real User
2020-11-24T23:23:18Z
Nov 24, 2020

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

PS
Reseller
2020-07-12T11:48:51Z
Jul 12, 2020

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

CF
Real User
2020-06-25T10:49:17Z
Jun 25, 2020

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).

AM
Real User
2020-03-04T08:49:27Z
Mar 4, 2020

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.

AM
Real User
2019-09-22T06:41:00Z
Sep 22, 2019

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.

OM
Real User
2019-08-04T07:38:00Z
Aug 4, 2019

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.

it_user807540 - PeerSpot reviewer
Real User
2019-07-28T07:34:00Z
Jul 28, 2019

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.

NM
Real User
2019-07-18T11:31:00Z
Jul 18, 2019

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.

AE
Real User
2019-06-20T08:55:00Z
Jun 20, 2019

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.

Real User
2018-01-28T13:15:00Z
Jan 28, 2018

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

NC
Real User
2018-01-28T13:15:00Z
Jan 28, 2018

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.

Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds. Oracle GoldenGate Features Oracle GoldenGate has many valuable key features, including: Simple to use web interface Fast and easy installation or provisioning Command line access via AdminClient that can run anywhere RESTful APIs for...
Download Oracle GoldenGate ReportRead more