Oracle Corporation

Oracle Fusion Middleware 11g

Oracle GoldenGate Partner Workshop
Hands-on Workshop

Oracle Platform Technology Solutions

Workshop Description

Oracle Fusion Middleware 11g is the #1 middle-tier infrastructure that enables enterprises to create and run agile, intelligent business applications and maximize IT efficiency by exploiting modern hardware and software architectures. Oracle GoldenGate (OGG) is a comprehensive solution for replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.

This FREE partner workshop will be focusing on demonstrating the heterogeneous capabilities of replication between MySQL and an Oracle Database. This is a hands-on-workshop, and as such you will be guided through the process of installation, configuration and execution of Oracle GoldenGate running with both Oracle and MySQL with the intent of getting you quickly started on using these products. No prior knowledge or experience in using Oracle GoldenGate, Oracle Database and MySQL is required to attend this workshop. Also, it is not the intent of this workshop to make someone proficient in either the Oracle or the MySQL databases.

After taking this course on Oracle Golden Gate11g , you can go on to build real-time data integrations, industry-focused solutions, customer facing demos, proof-of-concepts (POCs), pilot implementations and reference architectures. If you are a developer or consultant who specializes in data integration, data migration, data warehousing, ETL, BI, or SOA you cannot afford to miss this workshop.

Workshop Outline
Day One:

  • Introduction and Overview of Oracle GoldenGate (PPT)
  • Lab 1: Getting Started - Configuring the databases for using Oracle GoldenGate and our workload simulation app  (Hands-On)
  • Lab 2: Downloading and Installing Oracle GoldenGate for MySQL and Oracle  (Hands-On)
  • Lab 3: Setting up an Initial load from MySQL to Oracle  (Hands-On)

Day Two:

  • Lab 4: Configuring one-way replication from MySQL to Oracle  (Hands-On)
  • Lab 5: Configuring Bi-Directional Replication between MySQL and Oracle  (Hands-On)
  • Lab 6: Configuring Transformations with Oracle GoldenGate  (Hands-On)
  • Lab 7: Configuring Filtering using Oracle GoldenGate  (Hands-On)


  • Data Integration, Data Migration and Application Migration Implementers
  • Data Warehouse/ETL, BI and SOA Consultants
  • Enterprise and Industry Solutions Architects
  • Database and System Administrators


  • Familiarity with databases
  • Basic understanding of replication and data integration

Equipment Requirements

This workshop requires attendees to provide their own laptops.
Attendee laptops must meet the following minimum hardware/software requirements:

This class duration is two Days.

9:00am: Sign-in and technical set up
9:30am : Workshop starts
5:00pm : Workshop ends

Registration is FREE but seating is limited.

Oracle GoldenGate 11g Workshop Schedule
January 29-30, 2013: BVP, Birmingham, UK
Register here


For registration questions please send an email to

Oracle Platform Technologies Enablement Services

Hardware and Software Engineered to Work Together
Copyright © 2012, Oracle. All rights reserved. Contact Us | Legal Notices and Terms of Use | Privacy Statement


Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL - E-mail Services, Redwood Shores, CA 94065, United States

Create or update your profile to receive customized e-mail about Oracle products and services.

If you do not wish to receive any further electronic marketing communications from Oracle you can Opt-Out completely, please note you will no longer receive newsletters and product information you may have subscribed to.