- 4 of top 5 largest commercial banks
- 3 of top 3 busiest ATM networks
- 5 of top 5 financial data services companies
- 5 of top 5 telecommunications providers
- 3 of top 5 most major food & drug stores
Real-time data replication is now part of many businesses' core process. It is like the arteries in our body sending the blood, which keep our body full of life. It pumps business blood, the data, across our system in real-time. It is fascinating to see the creative and extensive use of the technology in the many industries in the past few years. Many of the solutions are seen as the secrets to business success. Thousands of Oracle GoldenGate customers including Fortune 500 companies, representing Financial Services, Communications, Healthcare, Public Sector, Retail, Utility industries, are:
Created 1/13/2017, Last Updated 6/9/2017
Real-Time Supply Chain Management
This case is about an 800-store nationwide retail company that uses Oracle GoldenGate to integrate its brick-and-mortar and online stores. This is a supply chain management information system (SCMIS) which organizes information between customers, distributors, manufacturers, suppliers, and other members of the supply chain. All the inventory databases (Oracle Database) and the point-of-sale systems (DB2 for z/OS) are integrated in real-time. The integration allows the retailer to re orchestrate the central inventory, the local inventory, the logistics, and the point-of-sale systems. The retailer can determine how to juggle inventory from closer locations to meet demand where it is occurring. This real-time supply management solution, with better global visibility, orchestration, forecast and planning, reduces the cost and uses the resources more efficiently.
Real-Time Marketing Analytics
This case is about another online retailer, Overstock , that implemented a real-time data warehouse system with Oracle GoldenGate. Data is collected from the marketing system, point-in-sales system and online stores in real-time and fed to the central data warehouse system. Advanced analytics are implemented to gain insights on its customers including tracking the result of the marketing campaigns, analyzing the client purchasing behavior and predicting the demands. With the real-time integration of all the data, Overstock can immediately know if the marketing campaign leads to more visits to the store and if it drives actual purchases.
The stream analytics is rapidly adopted by retailers for near real-time buyer experience, seller insights, and data-driven commerce. Oracle Oracle GoldenGate for Big Data is used to feed transaction data into Kafka.
Real-Time Customer Loyalty Management
Customer loyalty plays a major role in marketing and customer services . Many retailers have created customer loyalty programs. The next story creates a distributed database system which saves the client's information while visiting local shops and integrates the data with Oracle GoldenGate across the nation. The integration allows the system to collect customer data at any local shop and provides a unified view of the client data. Real-Time data integration makes the system more efficient and consistent across the board.
Everyday you are shopping, you are using Oracle GoldenGate. If you buy a cup of coffee at Starbucks, select a recommended item on eBay, buy a song on Apple iTune, shop at Macy's online store during black Friday, use a coupon at Safeway, or browse a catalog at Overstock.com, you are using Oracle GoldenGate.  The Real-Time data replication plays an essential role in retailers' business operations.
The public sector uses the real-time data integration to migrate to the latest technology, maintain high availability for miss-critical services, provide better services, and incorporate advanced analytics to better protect the public interests and assets.
Zero Downtime Migration
Many public services require being run 24x7 and such system uses Oracle GoldenGate for zero downtime migrations.
High Availability for Mission Critical Services
Like other industries, high availability is a must for mission critical systems. This also applies to the public sector. Oracle GoldenGate is used extensively to move large scale data in real-time so that multiple copies of data to ensure availability of data in case something happens.
Real-Time Data Analytics
Public data collected is used for various analysis to improve public services and protect public interests and assets. National security is facing challenges with complex and dynamic changes. Oracle GoldenGate and Oracle GoldenGate for Big Data is used to detect and respond to threats in real-time. Data are collected in real-time and delivered to data warehouse system and big data repository for real-time analysis. Real-Time data analytics is also used for tax fraud and evasion .
Scaling Out the Services with Real-Time Data Integration
With the scale of national support for services, real-time data integration tools such as Oracle GoldenGate are used to scale out the system. For example, one country uses Oracle GoldenGate to implement a voting system where all the votes are collected to the local database but are integrated into the central database for vote calculation in real-time.
Manufacture industry heavily relies on data to manage global inventory efficiently, streamline the assembly lines and analyze customer demands for business decision. Real-Time data integration solutions are created to upgrade to new technologies, provide high availability of the global inventory databases, integrate data needed for the assembly lines and load data to analytic repositories.
Zero Downtime Migrations
Like other industry, companies keep upgrading to new technology to stay competitive and improving the business processes. Real-time replication is used to implement the zero downtime migration solutions to minimize the impact, risks, and downtime.
High Availability for Manufacturing Databases
When Blackberry  experienced exponential growth and stringent carrier SLA’s to meet growing demand for Blackberry devices, Oracle GoldenGate was used to maintain the continuous availability of critical data across all of the four global data centers for manufacturing plants. All plants see same data and can move devices based on regional demand.
Integrated Manufacturing Operations with Analytics
SolarWorld  uses Oracle GoldenGate to move data from multiple manufacturing databases into a single decision support system database in real time, freeing up the OLTP systems for transaction processing, which improves their performance and stability. Using this real-time monitoring capability SolarWorld is able to detect the deviations from the norm right away, and take action to remedy or understand the situation. The integrated data environment allows analytics to improve product design, supply chains, production, and support.
Operational cost reduction is necessary for communication industry due to the large scale both on geographic distribution and the number of users. Real-Time data replication is used to setup distributed database system so that all the operations for the users are handled locally, and the data are synchronized across regions in real-time for other reporting, analytics, and central management purposes. MegaFon  deployed Oracle Golden Gate to extract billions of monthly transactions from eight regional billing systems needed to ensure accurate, trusted, and timely data for all corporate departments. The data was integrated and centralized onto Oracle Database 11g Enterprise Edition and distributed to business-critical subsystems for revenue, fraud, and security analysis.
Customer Analytics for Better Services
Real-Time tracking customer's information helps companies to provide better services and business decision. DIRECTV can use the real-time data to monitor customer churn and premium service upgrades intraday and take immediate action to affect overall performance according to our business goals.  This solution enabled managers and more than 15,000 call center agents to conduct real-time data queries and analysis throughout the day—using dashboards, e-mail delivery, and end-user reporting tools—eliminating the reliance on outdated weekly or monthly reports.  The analytics also driven the targeted marketing campaigns based on enhancing customer profile information and be aware of geographic locations.
Communication companies keep innovating its interaction with the end users to stay competitive. New applications are developed with the mobile access, integrating with social networks, and more leverage the internet connections. To build these applications quickly, real-time data replications are used to create live dev/test environment feeding data from production system so that the applications can use the real-world data without impacting the current business.
Highly Available Transaction Systems
The success of business in financial services industry heavily relies on the continuous availability of their transaction systems. For a credit card company, it is the payment system. For a trading company, it is the trading transaction management system. The system has to operate 24x7 with NO data loss. Maximum availability strategy has to be defined for these cases. Real-time data replication technology is used in two different ways: performing the zero-downtime migration and enabling active-active or multi-master replication for distributed data management. For example, UBS uses Oracle GoldenGate to create a highly available solution integrating 100 back office applications in real-time. State Street make the trading transaction highly available with Oracle GoldenGate replication.  Bank of America uses Oracle GoldenGate to enable continuous availability of 18,000 ATM network serving 60+ million cardholders. 
Real-Time Payment Authorization and Fraud Detection
Payment Authorization and Fraud detection are mission-critical for financial services businesses. Mega-scale data warehouse systems  are built to authorize the new users, track transaction status and detect frauds in real-time. Payment systems such as credit card payment and ATM networks use this approach extensively. These solutions use real-time data replication tools to capture millions of the transactions every second and deliver the data to data lakes for business analytics. A new trend is also to build data lakes with big data repositories in addition to the databases. Increasing demands are also seen on performing event-driven analytics (streaming big data analytics). Retail Decisions, the payment card issuer and a world leader in card fraud prevention and payment processing, uses Oracle GoldenGate to provide real-time payment authorization and fraud detection services to Blue-chip retailers such as Walmart, Sears and Macy's. This is a multi-master replication solution for their data centers across continents. 
Query Offloading for New Services
Financial services keep improving services' user experiences. One example is that many banks now allows users to view their accounts with mobile access and even deposit checks via cell phones. When providing mobile access, there is a significant increase in database queries. Query offloading strategy are used to offload queries to new database so that the primary OLTP database can handle the important transactions with high performance, high security, and availability.
In financial industry, Oracle GoldenGate is used extensively in the core business, Oracle GoldenGate will be used: 
Let's look at a real-time data warehouse use case where Sprint used Oracle GoldenGate to integrate data across different business units.  After the merger with Nextel, Sprint used Oracle GoldenGate capture data from the third party hosted billing applications. The data are offloaded to the reporting databases. Reports are created for investors, retail store systems, customer care systems, and provisioning systems. Oracle GoldenGate implementation achieves the followings:
Created: 10/23/2013, Last Updated 1/19/2017
Bombay Stock Exchange (BSE) established in 1875, is Asia’s first stock exchange and the world's 11th largest stock exchange with an overall market capitalization of $1.43 Trillion as of March, 2016. 
Intuit is founded in 1982, now has 4.5 billion revenue adn 50 million customers. 
Intuit moves to cloud (Amazon AWS) to deliver better customer experiences that can run on any device, anywhere by any authorized user at any time. It also cut cost of 6x to manage the tax season scaling. Oracle GoldenGate is used to perform the following tasks 
Sabre Corporation is a travel technology company based in Southlake, Texas. It is the largest Global Distribution Systems provider for air bookings in North America.
Use Case - Query Offloading , Zero Downtime Migratiion
Customer need to migration to the new IT infrastructure and offload query applications to cheaper databases.
“With Oracle Data Integrator and Oracle GoldenGate, we have been able to create a highly scalable and reliable IT environment. It has allowed us to streamline daily business operations, successfully complete the migration to a new high-performance Oracle Database and reduce time-to-market for new products and services.” - Jessica Thorud, Director, Sabre Holdings.