Oracle GoldenGate can be used in many different use cases. This blog summarized the published customer stories. From the stores, we can see that the top reasons for people to choose Oracle GoldenGate include:
- Simplify IT Management with lower Total Cost of Ownership (TCO): Oracle GoldenGate's log-based capture can be set up in a non-intrusive way. The captures can be setup once and delivers to many targets for different purposes. Additionally, the data are replicated in real-time. These simplify the IT management by to migrate data with minimum downtime, offloading query to other systems as needed or created integrated data system with agile architecture.
- High Performance with Reliability: The requirement is about handling hundreds millions of DML operations per day, transferring hundreds megabytes of data per hour, and delivering data 24x7 with no loss of data and within sub-second of latency.
- Flexibility and Ease of Use: when data is captures, it can be used and delivered as needed.
- After merge and acquisition, you need to migrate and consolidate the systems.
- You need to perform fraud/audit detection which auditing all the transactions.
- You need to ensure that their critical IT systems have 24/7 availability.
- You need to build better customer/product profile and perform real-time analysis of data from different systems.
- You need to create real-time reporting of the transaction system.
- You need to setup sub-system of the transaction databases for query, analysis or used the data for different purpose or different security groups.
The top use cases are:
- Zero-Downtime Migration
- Real-Time Data Integration
- Real-time Data Warehouse
- Query Offloading
- Operational Reporting
- High Availability and Disaster Recovery.
The industry summary is as follows:
- Financial: Bank of America [13], People's Bank of China [12], 银联商务[12], Visa [13], State Street [10]
- Automobile: Shanghai GM [12], 神龙汽车[12]
- Retail: Walmart [13]
- Aerospace: Boeing [13]
- Oil and Gas: BT [4][7][13]
Avea Telecommunication Services
Avea chooses Oracle Golden Gate for heterogeneous replications from nearly 30 OLTP systems, and for migration from Oracle GoldenGate 10g to Oracle GoldenGate 11g. The implementation is easy and with good support.
Use Case: Real-Time Data Warehouse, Zero Downtime Migration Industry: Telecommunication Database: MS SQL Server, Oracle Database, MySQL. [5]
BT
BT uses Oracle GoldenGate for providing real time data integration, extracting real time information from a production system, and offloading it to various target systems.40 heterogeneous system are integrated with the solution to a single capacity planning database. [4]
Use Case: Real-Time Data Integration, Query Offloading, Zero Down-Time Migration [7] Industry: Oil and Gas Database: Oracle DB
Italian Air Force
Italian Air Force uses Oracle GoldenGate to setup a real-time synchronization of about 50 sites that feed data to the repository for coordinate and control military flights and air space in real-time. (“Blade Runner” command-and-control system). The system can receive a flow of mission-critical information distributed in real-time, despite considerable geographic distances and low-bandwidth networks. [8]
Use Case: Real-Time Data Integration Industry: Aerospace Database: Oracle DB
Sabre Holding
Sabre Holding used Oracle GoldenGate to scale it's IT infrastructure to support it's growing customer base and migrated to Oracle Database 11g without downtime to reduce total cost of ownership and complexity. There are 645 million DML operations each data with 34 billion of selection query in the functional system.[2][3]
Use Case : Zero Down-Time Migration, Query Offloading Database: Oracle DB, (HP Non-Stop, MySQL)
State Street
State Street uses Oracle GoldenGate to setup bi-directional high availability for their financial system. [10]
Use Case: High Availability Industry: Financial Database: Oracle DB
University of Cincinnati
Based on the press release [1], "University of Cincinnati, a public research university with more than 43,600 students, will replace its mainframe legacy system with PeopleSoft Campus Solutions to improve communication among students, faculty, and staff; support campus engagement and student retention; and better compete with peer institutions." UC also selected a wide range of supporting Oracle solutions, including Oracle GoldenGate [1]
Use Case: Zero Down-Time Migration Industry: Education Database: Oracle DB
References
-
Universities Select Oracle’s PeopleSoft Campus Solutions to Enhance the Student Experience
- Sabre Holdings Reduces Complexity with Oracle GoldenGate, 25 Oct, 2012
- Sabre Holdings Deploys Oracle Data Integrator and Oracle GoldenGate to Support Rapid Customer Growth, October 16, 2012
- BT Uses Oracle GoldenGate for Real Time Data Integration, 25 Oct, 2012
- Avea Chooses Oracle GoldenGate for Heterogeneous Replication, 03 Apr, 2013 (Data Sheet)
- Avea Telecommunication Services Accelerates Reporting to Improve Campaign Analysis and New Service Delivery,
- BT Uses Oracle GoldenGate to Migrate Systems and Services, 25 Oct, 2012
- The Italian Air Force Supports Air Operations with Real-Time, Mission-Critical Information, January 21, 2015
- Samsung Electro-Mechanics Compresses Enterprise Resource Planning Data by 30%, Increases Production Efficiency, and Reduces Costs
- State Street Case Study Oracle OpenWorld 2013
- Oracle GoldenGate gaining traction in BFSI, telecom verticals, 30 April, 2013
-
http://www.oracle.com/technetwork/cn/community/developer-day/1-data-integration-2179418-zhs.pdf
- https://www.youtube.com/watch?v=Fgs3va2dnQQ