1/9

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Information
• Conventions

1 Introduction to Oracle GoldenGate Veridata

• About Oracle GoldenGate Veridata
• Comparing Data Using Oracle GoldenGate Veridata
• Accessing Oracle GoldenGate Veridata Web User Interface
• Managing the Page View

2 Configuring Workflow Objects

• Overview
• Configuring Connections
  • Creating a Connection
  • Edit a connection
  • Delete a connection
  • Filter the Existing Connections list
  • Editing Connection Settings
  • Editing Connection Details
  • Editing connection properties
• Configuring Groups
  • Filter the Existing Groups list
  • Create a group
  • Edit a group
  • Delete a group
• Configuring Compare Pairs
  • Existing Compare Pairs List Column Details
  • To filter the list
  • To control delta processing
  • Editing a compare pair
  • Configuring row partitions
    • How to use partitions
    • Creating the partitions
  • Deleting a Compare Pair
  • Mapping Objects Using a Pattern
    • Confirm group information
    • Select the datasource
    • Select a Pattern Mapping Method
    • Select and Specify Compare Pair Details
    • Generate the mappings
    • Save the compare pairs to the repository
  • Mapping Objects Manually
    • Confirm group information
    • Select the datasource
    • (Optional) Filter the lists
    • Map a table or file
    • Specify compare pair details
    • Generate the mappings
    • Save the compare pairs to the repository
  • Reviewing and Saving Compare Pairs
  • Viewing details for a compare pair that is finished
• Configuring Column Mappings
  • Choosing a column mapping method
  • Validating column mappings
  • Using Delta Processing
    • What is Delta Processing?
• Configuring Profiles
  • Editing Profile Settings
  • Using the default profile
• Configuring Jobs

3 Working with Jobs

• Overview of Jobs
• Estimating Comparison Time
• Running A Job
  • Estimating Comparison Time
  • How groups are shown on the Run/Execute Job page
  • Overriding Row Partitions
  • Configuring run options
    • Parameter details
• Viewing jobs that are running
  • Managing common tasks
    • Using Favorite Jobs
    • Using Shortcuts
    • Editing Jobs and Shortcuts
  • Editing a job
• Viewing jobs that are finished
  • Viewing details of a job that is finished
  • Viewing details of a group that is finished
  • Viewing details for a compare pair that is finished
    • Using the charts
• Repairing Out-Of-Sync Jobs
  • Viewing Details of an Out-Of-Sync Job
  • Viewing the Repair Report
• Using the Comparison Report

4 Customizing Your Workspace

• Working with the Home Page
  • Setting home page preferences
• Using the Favorites Manager
• Setting user preferences
  • Setting general user preferences
  • Setting home page preferences

5 Tuning Performance

• Improving the Performance of Oracle GoldenGate Veridata
• Performance Statistics

A Column Mapping

• Oracle Data Type to Hive Mapping
• SQLServer to Hive Mapping