1 Introducing Oracle GoldenGate Studio

Oracle GoldenGate Studio allows you to quickly create, modify, validate, deploy, and reuse Oracle GoldenGate designs.


1.1 Introduction

Oracle GoldenGate Studio enables you to design and deploy high-volume, real-time replication by automatically handling table and column mappings, allowing drag and drop custom mappings, generating best practice configurations from templates, and contains context-sensitive help. With Oracle GoldenGate Studio, users new to Oracle GoldenGate can start replicating data with minimal effort while experienced users have access to GoldenGate's advanced replication options. Users new to Oracle GoldenGate can start replicating data with minimal effort. Oracle GoldenGate Studio provides you with the following abilities:

  • Quickly create, modify, validate, deploy, and reuse Oracle GoldenGate best practice designs.

  • Define data flows once and deploy to numerous locations.

  • Graphically filter, map, and transform data.

  • Apply global rules and exceptions.

1.2 How Do I Get Started?

To understand what is available in the product and documentation, Oracle recommends that you familiarize yourself with the Concepts and Terminology and the Oracle GoldenGate Commands and Parameters that you can use with the Properties Inspector so that you have an understanding of what are available in the product and documentation.

You can follow the basic steps outlined below to create and deploy your replications:

OGG Roadmap Summary

Roadmap of Tasks

  1. Begin by adding new database and Oracle GoldenGate connections to your Global Resource Library, see Understanding Projects.

  2. Use the wizards to create a Project, Replication Solution, and Deployment Profile. By default each wizard invokes the next. Solutions define the replicat process. The Solution and Deployment Profile wizards provide you with preconfigured templates, see Understanding Solutions.

  3. Solution objects own Mapping groups, which describe the logical view of the replication process. Use the AutoMap button or manually map the schema, table, and column mappings and then assign them to your replication paths, see Understanding Mapping Groups.

  4. Create Mapping groups and assign them to the appropriate replication paths. You can reuse the Solution Mapping groups in multiple replication paths for that solution and the Global Mapping groups across multiple replication paths across the project, see Understanding Mapping Groups.

  5. Add, remove, and fine tune any Oracle GoldenGate option or parameter, see Using the Properties Inspector.

  6. Deploy the Solution online to live Oracle GoldenGate instances or generate the parameter and obey files locally for manual deployment, see, Understanding Deployment Profiles.

  7. Define any additional physical resources and assign them to your deployment profiles through the drag and drop option from the Global Resource Library to the Deployment Profile diagram, see Understanding Deployment Profiles.

  8. Solutions also own one or more Deployment Profiles, which describe the physical attributes of a particular replicat deployment. You can create multiple deployment profiles. For example, separate profiles for development, testing, and production for a single Solution, see Understanding Deployment Profiles.

  9. View deployment history information, see Understanding Deployment Profiles.

  10. Start, stop, and monitor all physical processes, see Monitoring.

  11. Export solutions and mappings to XML files that can be imported by other Oracle GoldenGate Studio users, see Using the Projects Navigator.