Wednesday Sep 25, 2013

Oracle GoldenGate AppAdvantage in Action at Land O’Lakes, Smuckers, and Veolia Water

On Tuesday at OpenWorld we had the honor to host a panel with GoldenGate customers: Land O’Lakes, Smuckers, and Veolia Water. Besides giving us yummy nutrition and healthy water, these companies have another aspect in common. They all use GoldenGate to boost their ERP application.

Veoila Water’s Pierre Kerrinckx came from their HQ in France for this panel and spoke to us about the database migration project for their JD Edwards ERP system. Using GoldenGate Veolia was able to migrate from Oracle Database 10gR2 on Aix 5.3 Oracle 10g R2 to Oracle Database Aix 7.1 Oracle 11g R2 and did so with only 2 hours of interruption to JD Edwards end users. Pierre mentioned, the other benefit of GoldenGate was the ability to switch back to the old environment if needed.

Land O’Lakes’ Mark Kohls talked about their use of GoldenGate for their JD Edwards ERP system supporting the Purina business line. Land O’Lakes had to migrate enterprise-wide JDE Xe ERP system to new database and application server platform with minimal downtime to the business. While their goal was to have less than 8 hours of downtime, with GoldenGate they limited downtime to 30 minutes.

Both Veolia and Land O’Lakes used GoldenGate in an Active-Passive fashion, meaning that the new environment was not used simultaneously with the old one, and the users migrated all at once. GoldenGate provides Active-Active migration model too, if the company prefers to do a phased migration and truly zero downtime.

Smuckers's Neal Indermuhle had a different story to share. He talked about operational reporting for their critical Oracle E-Business Suite and how using Oracle GoldenGate helped the company to achieve the near real-time data they need in making critical business decisions. Neil shared that the replication latency averages less than 10 seconds and Oracle GoldenGate Veridata is leveraged to validate synchronization.

I would like to thank Pierre, Mark, and Neal for sharing their best practices, and taking tough questions from the audience. If you would like to learn more about Oracle GoldenGate’s solutions for JD Edwards, E-Business Suite and other key Oracle Applications please check out our new resource center with recorded video presentations and detailed white papers.

Before I get ready for another full day at OpenWorld tomorrow I would like to leave you with the key GoldenGate sessions we have lined up for Wednesday:

Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard (CON8500)
Wednesday, September 25, 2013 at 10:15AM-11:15AM PT
Moscone South – 104

Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)
Wednesday, September 25, 2013 at 11:45AM-12:45PM PT
Moscone West – 2024

Integrated Apply for Oracle Database: Scalable Replication with Oracle GoldenGate (CON8198)
Wednesday, September 25, 2013 at 5:00PM-6:00PM PT
Moscone North – 131

Thursday May 16, 2013

Sabre Holdings Case Study Webcast Recap

Last week at Oracle we had a very important event. In addition to the visit by the roaming Gnome, who really enjoyed posing for pictures on our campus, I had the priviledge to host a webcast with guest speaker Amjad Saeed from Sabre Holdings. We focused on Sabre's data integration solution  leveraging Oracle GoldenGate and Oracle Data Integrator for their enterprise travel data warehouse (ETDW).

Amjad, who leads the development effort for Sabre's enterprise data warehouse, presented us how they approached various data integration challenges, such as growing number of sources and data volumes, and what results they were able to achieve. He shared with us how using Oracle's data integration products in heterogeneous environments enabled right-time market insights, reduced complexity, and decreased time to market by 40%. Sabre was also able to standardize development for its global DW development team, achieve real-time view in the execution of the integration processes, and the ability to manage the data warehouse & BI performance on demand. I would like to thank Amjad again very much for taking the time to share their data integration best practices with us on this webcast.

In this webcast my colleague Sandrine Riley and I provided an overview of Oracle Data Integration products' differentiators. We explained architectural strengths that deliver a complete and integrated platform that offers high performance, fast time-to-value, and low cost of ownership.  If you have not had a chance to attend the live event we have the webcast now available on demand via this link for you to watch at your convenience:

Webcast Replay: Sabre Holdings Case Study: Accelerating Innovation using Oracle Data Integration

There were many great questions from our audience. Unfortunately we did not have enough time to respond to all of them. While we are individually following up with the attendees, I also want to post the questions and answer for some of the commonly asked questions here.

    Question: How do I learn Oracle Data Integrator or GoldenGate? Is training the only option ?

    Answer: We highly recommend training through Oracle University. The courses will cover all the foundational components needed to get up and running with ODI or GoldenGate. Oracle University offers instructor-led and online trainings. You can go to to get a complete listing of the courses available.Additionally – but not in replacement of training – you can get started with a guided ‘getting started’ type tutorial which you can find on our OTN page:  in the ‘Getting Started’ section of the page.Also, there are some helpful ‘Oracle by Example’ exercises/videos which you can find on the same page.

    For Oracle GoldenGate, we recommend watching instructional videos on its Youtube channel: Youtube/oraclegoldengate. A good example is here

    Last but not least, at Oracle OpenWorld there are opportunities to learn in depth by attending our hands-on-labs, even though it does not compare to/replace taking training.

    Question: Compare and contrast Oracle Data Integrator to the Oracle Warehouse Builder ETL process. Is ODI repository-driven and based on creation of "maps" when   creating ETL modules?

    Answer: ODI has been built from the ground up to be heterogeneous – so it will excel on both Oracle and non-Oracle platforms.  OWB has been a more Oracle centric product.  ODI mappings are developed with a declarative design based approach, and processes are executed via an agent – who is orchestrating and delegating the workload in a set-based manner to the database.  OWB deploys packages of code on the database and produces more procedural code.   For more details – please read our ODI architecture white paper

    Question:  Is the metadata navigator for ODI flexible and comprehensive so that it could be used as a documentation tool for the ETL?

    Answer: Oracle Data Integrator's metadata navigator has been renamed – now called ODI Console.  The ODI console is a web-based interface to view in a more picture based manner what is inside of the ODI repository.  It could be used as documentation.  Beyond the ODI console, ODI provides full documentation from the ODI Studio.  For any given process, project, etc.  you are able to right click – and there is an option that says ‘print’ – and this will provide you with a PDF document including the details down to the transformations.  These documents may be a more appropriate method of documentation.  Also – please check out a whitepaper on Managing Metadata with ODI.

If you would like to learn more about Oracle Data Integration products please check out our free resources here. I also would like to remind you to follow us on social media if you do not already. You can find us on Facebook, Twitter, YouTube, and Linkedin.

Thursday Apr 11, 2013

Why Real Time?

Continuing on the five key data integration requirements topic, this time we focus on real-time data for decision making. 

[Read More]

Tuesday Apr 02, 2013

Starwood Hotels Presents in Customer Success Forum on April 11th

Register before April 5th for the online Customer Success Forum with Starwood Hotels and Resorts (April 11th 11am ET), and ask questions about how they used Oracle Exadata, Oracle GoldenGate, and Oracle Data Integrator for data warehousing and operational reporting.[Read More]

Wednesday Sep 12, 2012

Customers Discuss: Real-World Operational Reporting with Oracle GoldenGate

As businesses leverage business intelligence and analytics for day-to-day decision making, operational reporting solutions become more and more common. While some companies can use their production OLTP system for running operational reports, for many it is too much overhead and performance impact for transaction processing systems. 

Oracle GoldenGate’s real-time data integration capabilities enable companies to create a real-time replica of their OLTP systems, dedicated for operational reporting. This instance can be optimized for the reports needed as well such as containing only the tables needed from the source. Oracle GoldenGate has certified solutions for many Oracle applications such as EBusiness Suite, Peoplesoft, JD Edwards, to offload operational reporting to another reporting server that has real-time data feeding from the production system.

At Oracle OpenWorld we will be hearing from a panel of Oracle GoldenGate customers how they deployed GoldenGate for operational reporting. Comcast, Turk Telekom, and Raymond James will be sharing their experiences and the benefits achieved when implementing GoldenGate’s solution.

If you have performance degradation in your production systems due to reporting or ad-hoc queries, and you will be at OpenWorld, don’t miss this informative session:

Real-World Operational Reporting with Oracle GoldenGate: Customer Panel--

Tuesday Oct 2nd 11:45am Mascone West 3005.

For other data integration sessions at OpenWorld, please check our Focus-On document

If you cannot attend OpenWorld, please check out related white paper “Using Oracle GoldenGate to Achieve Operational Reporting for Oracle Applications to learn more.

Tuesday Oct 25, 2011

Top 3 Ways to Leverage Oracle GoldenGate with MySQL Databases

One of the key differentiators of Oracle GoldenGate in the real-time data integration and data replication technology space is its heterogeneity. It provides log-based change data capture, routing, transformation, and delivery between heterogeneous systems. MySQL is one of the heterogeneous platforms that GoldenGate can support both as source and target.

The most common ways Oracle GoldenGate is used with MySQL are real-time data warehousing, real-time reporting, and query offloading. In real-time data warehousing use case, Oracle GoldenGate feeds online transaction data from Web properties running on MySQL databases to the data warehouse in real time, to enable a complete and reliable view of the business operations. Oracle GoldenGate can feed all major data warehouses including Oracle Exadata, Teradata, IBM Netezza, Greenplum etc.

MySQL is heavily used for departmental enterprise applications including analytical systems. Oracle GoldenGate can deliver real-time data from production OLTP systems to data marts running on MySQL to support operational reporting and analytical applications. This enables analytical systems to have access to up-to-date information when supporting operational decision making.

Last but not least, GoldenGate can enable query offloading from production OLTP systems that may be on a mainframe (such as DB2 z/Series) or open systems (such as  MSFT SQL Server or Sybase ASE). Oracle GoldenGate can move all or a portion of transactional data in real time from production databases to MySQL databases to allow the end users to run their queries and reports on the dedicated server rather than on the production server. This approach is a great way to reduce TCO and maximize the performance of production OLTP systems. In addition, it allows to optimize the database for reporting purposes. Especially in travel and ecommerce industry it helps reduce browsing activity related overhead on OLTP systems.

To read more about how to leverage Oracle GoldenGate please check out our new MySQL and Oracle GoldenGate spotlight document and check the additional resources provided.

Friday May 20, 2011

Real-Time Data Integration for Operational Data Warehousing

Gone are the days when data warehouses were just for reporting, strategic analytics, and forecasting. Today, more companies are using their data warehouses for operational decision making – and thus more critical to the business. To be able to influence operational decisions the analytical environment needs to be able to stay current with the business events happening right now. Therefore an important requirement is to enable lowest possible latency in which new data is delivered to the data warehouse, ideally in real time.

For example, when a snowstorm hits a certain area, the operational data warehouse can help monitor snow shovel sales and then provide information to help determine whether other stores in the affected areas should move more merchandise to the shelves and also offer other related products at a discounted price. There is a lot less value in reacting to data for a snowstorm that occurred 24 hours ago – or even 6 hours ago.

There are many data integration technologies that serve the data acquisition needs of a data warehouse, however only a few offer real-time data delivery with no impact on source systems’ performance. The challenge for the IT group is to determine what solution or combination of data integration solutions will meet their data delivery and performance needs to help propel the move to operational data warehousing. Such data integration evaluations are aided with the understanding of:

  • Selection Criteria – This should include considerations for acceptable latency, data quantity/volumes, data integrity, transformation requirements, and processing overhead/impact on availability.
  • “Right Time” vs. "Real-Time" – When evaluating solutions, the technology should deliver real-time data capabilities and let the user choose the “right time” as a business decision. Right-time should be a component of decision latency – a user preference, not a technical constraint.
  • Transformations – As the data warehouse approaches real time, transformations ideally should take place within the data warehouse in order to reduce data and analysis latency. This eliminates the need for additional steps for aggregating changed data on a middle-tier server until it is batch processed-- not to mention the TCO savings of not acquiring or maintaining a middle-tier transformation server.

Oracle offers a complete and certified data integration solution for implementing operational data warehouse on Oracle Exadata. Oracle GoldenGate provides low-impact, real-time change data capture and delivery, while Oracle Data Integrator EE provides high performance transformations within Oracle Exadata. Oracle Data Integrator also offers integrated solution for data profiling and data quality to enable analysis with trusted data. Here is a great customer example how Oracle’s products enable the move to operational data warehousing. You can read more about Oracle's data integration solution for operational data warehousing in our white paper. If you would like to read more about how to use Oracle Data Integration products for Oracle Exadata please check out our recent data sheet.


Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality


« August 2016