1/46

Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Related Documents
• Conventions

1 Introducing Oracle GoldenGate Studio

• 1.1 Introduction
• 1.2 How Do I Get Started?

2 Using the Interface

• 2.1 Understanding the User Interface Basics
  • 2.1.1 Oracle GoldenGate Studio Repository Login
  • 2.1.2 Menu Options
    • 2.1.2.1 The File Menu
    • 2.1.2.2 The Edit Menu
    • 2.1.2.3 The View Menu
    • 2.1.2.4 The Search Menu
    • 2.1.2.5 The Diagram Menu
    • 2.1.2.6 The OGG Menu
    • 2.1.2.7 The Tools Menu
    • 2.1.2.8 The Window Menu
    • 2.1.2.9 The Help Menu
• 2.2 Setting Your Preferences
  • 2.2.1 How to Set Preferences
• 2.3 Navigation Using the Keyboard
• 2.4 Using the Projects Navigator
• 2.5 Using the Editor Area
• 2.6 Using the Resources Navigator
  • 2.6.1 Add a New Data Server Connection
  • 2.6.2 Add a New Global Mapping Group
  • 2.6.3 Add a New Oracle GoldenGate Instance
• 2.7 Using the Properties Inspector
  • 2.7.1 How to Use the Properties Inspector

3 Working with Solutions and Deployment Profiles

• 3.1 Understanding Projects
  • 3.1.1 Creating a Project
• 3.2 Understanding Solutions
  • 3.2.1 Creating a New Solution
• 3.3 Understanding Deployment Profiles
  • 3.3.1 Components of the Deployment Profile
    • 3.3.1.1 Name of the Oracle GoldenGate profile
    • 3.3.1.2 Deployment Architecture Template
    • 3.3.1.3 Assign Physical Resources
    • 3.3.1.4 Deployment Options
  • 3.3.2 Toolbars in the Deployment Profile
  • 3.3.3 Creating a New Deployment Profile

4 Working with Mappings Groups

• 4.1 Understanding Mapping Groups
  • 4.1.1 Schema and Table Mapping
  • 4.1.2 Column Mapping
  • 4.1.3 Automap
• 4.2 How to Create a Mapping Group
• 4.3 How to Assign Mapping Groups to Replication Path
• 4.4 How to Copy And Share Mapping Groups

5 Deploying and Monitoring Your Solutions

• 5.1 Deploying Solutions
  • 5.1.1 How to Deploy a Solution
• 5.2 Overview
  • 5.2.1 Definition
  • 5.2.2 Deployment History
  • 5.2.3 Monitoring
  • 5.2.4 Deployment Configuration

6 Managing Security

• 6.1 Understanding Security in Oracle GoldenGate Studio
• 6.2 Using the Security Navigator
  • 6.2.1 Adding a New User
  • 6.2.2 Modifying an Existing User
  • 6.2.3 Deleting an User

7 Troubleshooting

• 7.1 Positioning of Docked Windows
• 7.2 Performance Issues While Using Oracle GoldenGate Studio
• 7.3 Privilege Issue with Oracle GoldenGate Studio
• 7.4 Syntax Errors with Generated Code
• 7.5 Not Able to Set Multiple Environment Variables
• 7.6 Not Able to Add Resources

A Concepts and Terminology

B Relating Properties Inspector Options to Oracle GoldenGate Commands and Parameters

• B.1 Commands with Options
  • B.1.1 ADD EXTRACT Commands
  • B.1.2 ADD REPLICAT Commands
  • B.1.3 ADD EXTTRAIL Command
  • B.1.4 ADD RMTTRAIL Command
  • B.1.5 REGISTER EXTRACT Command
  • B.1.6 START EXTRACT Command
  • B.1.7 START REPLICAT Command
  • B.1.8 ADD TRANDATA Command
• B.2 Parameter Category Names
• B.3 Units of Measure
• B.4 Opposites
• B.5 Other Oracle GoldenGate Parameters/Options