Data Integration and Master Data Management Edition
Oracle Corp
July 2012 Stay Connected: BlogFacebookTwitterLinkedIn
Back to the main page
Run Oracle Like Oracle: Real-Time Operational Reporting Using Oracle GoldenGate

Until recently at Oracle, real-time operational reporting was a pipe dream for many areas of its internal operations. The volume of data and velocity of change forced thousands of users across sales, operations, and finance to make do with stale data or slow-performing reports that were missing critical dimensions or attributes required to drive better decisions. Nowhere was this pain more apparent than in Oracle’s service contracts business. A custom-coded contracts reporting solution running within Oracle’s global single instance of Oracle E-Business Suite had reached a breaking point when contract line volume nearly tripled as the result of acquisitions.

In 2011, Oracle implemented a new operational reporting system using Oracle GoldenGate real-time data replication as an operational data store. Oracle GoldenGate is a proven solution for Oracle’s Siebel customers, but it had less frequently been used to replicate data from Oracle E-Business Suite. However, other methods, such as snap mirror copying of production online transaction processing (OLTP) systems to dedicated reporting instances, were unacceptable. They failed to reduce the data set and as a result required very expensive and ongoing SQL optimization across too many reports. Therefore, this somewhat novel use of Oracle GoldenGate appeared to offer the best approach to real-time reporting on a reduced OLTP data set. Today, the use of this real-time reporting solution is so successful that it is quickly expanding to other Oracle business areas.

Now, a new white paper describes the deployment of Oracle GoldenGate real-time data replication against Oracle’s internal Oracle E-Business Suite and ancillary systems. In addition, the paper includes recommendations for how to architect and configure the solution, as well as before and after quantitative findings. Oracle E-Business Suite customers with enterprise deployments and a need for low latency, real-time operational reporting will want to consider adopting the technologies and solution design patterns included in this study.

Access the Oracle GoldenGate resource kit today to read the full study.

Visit the Run Oracle Like Oracle Website for more information about how Oracle runs its business using its own products.
Back to Top
Oracle Information InDepth newsletters bring targeted news, articles, customer stories, and special offers to business people who want to find out how to streamline enterprise information management, measure results, improve business processes, and communicate a single truth to their constituents.

Please send questions or comments to

For answers to questions about subscribing, unsubscribing, and managing your Oracle e-mail communications preferences, please see the Oracle E-Mail Communications page.

Copyright © 2012, Oracle Corporation and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.