1/13

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle GoldenGate Veridata

• 1.1 Oracle GoldenGate Veridata Architecture
• 1.2 Configuring Single Sign-on for Oracle GoldenGate Veridata
• 1.3 Comparing Data with Oracle GoldenGate Veridata
  • 1.3.1 Oracle GoldenGate Veridata Comparison Objects
  • 1.3.2 Satisfying Uniqueness Requirements
  • 1.3.3 How Oracle GoldenGate Veridata Compares Data
    • 1.3.3.1 Initial Comparison Step
    • 1.3.3.2 Confirmation Step
• 1.4 Viewing Comparison Results
  • 1.4.1 Out-of-Sync Report
  • 1.4.2 Comparison Report

2 Configuring Oracle GoldenGate Veridata Security

• 2.1 Oracle GoldenGate Veridata Security Overview
• 2.2 Configuring an SSL Connection between Veridata Server and Veridata Agents
  • 2.2.1 One-Way and Two-Way SSL Connections
  • 2.2.2 Enabling SSL: Main Steps
  • 2.2.3 SSL Settings for Oracle GoldenGate Veridata Agent
  • 2.2.4 SSL Settings for GoldenGate Veridata Server
  • 2.2.5 Creating Keystores and Self-Signed Certificates by using the Keytool Utility
    • 2.2.5.1 Creating an Identity Keystore with a Self-Signed Certificate
    • 2.2.5.2 Building Veridata Server and Veridata Agent Keystores
    • 2.2.5.3 Importing Certificates to the Veridata Server and Agent Truststores
    • 2.2.5.4 Examples
  • 2.2.6 Using OPSS Keystore Service to Manage Veridata Keystores
  • 2.2.7 Modifying the Veridata Agent Wallet
• 2.3 Securing the Oracle GoldenGate Veridata Files
  • 2.3.1 Controlling Access to the Installation Directories
  • 2.3.2 Securing files that Contain Business Data
• 2.4 Securing Access to Oracle GoldenGate Veridata by Defining User Roles
• 2.5 Changing Database Schema Passwords
• 2.6 Encrypting Report Files
  • 2.6.1 Enabling Report Encryption
  • 2.6.2 Using the reportutil Tool to view Reports

3 Running the Oracle GoldenGate Veridata Programs

• 3.1 Starting and Stopping the C-agent and Manager
• 3.2 Starting and Stopping the Java-Based Components
  • 3.2.1 Controlling the Java-Based Components from the Command Line
• 3.3 Reloading Log Information
• 3.4 Connecting to Oracle GoldenGate Veridata Web Interface

4 Running Comparisons from the Command Line

• 4.1 Overview of the vericom Tool
• 4.2 Running Vericom
• 4.3 Vericom exit statuses
• 4.4 Vericom Output Examples

5 Using the Veridata Import and Export Utilities

• 5.1 Introduction to the Import and Export Utilities
  • 5.1.1 Supported Configurations
• 5.2 Running the Import and Export Utilities
  • 5.2.1 Using the Export Utility
  • 5.2.2 Using the Import Utility
  • 5.2.3 Processing the Configuration
• 5.3 Configuration File Element Reference
• configuration
• column
• colfilter
• colfiltercol
• compare-pair
• connection
• conn-properties
• delta-config
• description
• enscribe-info
• enscribe-key
• excluded-column
• expandddl
• filter
• group
• job
• profile
• key-column
• profile-general
• sorting-method
• initial-compare
• confirm-out-of-sync
• param
• repair
• sql-partition

6 Running Veridata GoldenGate Parameter Processing

• 6.1 Overview of the Command Line Interface
• 6.2 Running VGPP
  • 6.2.1 Using a Property File
• 6.3 Parameter Handling
• 6.4 Map and Table Statement Handling

7 Oracle GoldenGate Veridata Server Configuration Parameters

• 7.1 Overview of the Server Memory
• 7.2 Estimating Memory Usage
• 7.3 How to Set a Parameter
• 7.4 Parameter Descriptions
• Server Parameters
  • server.veridata_data
  • server.persistence_db_type
  • server.meta_session_handle_timeout
  • server.max_concurrent_jobs
  • server.max_concurrent_comparison_threads
  • server.mapped_sort_buffers
  • server.max_sort_memory
  • server.concurrent.writers
  • server.concurrent.readers
  • server.number_sort_threads
• Parameters for Configuring SSL Communication
  • server.useSsl
  • server.ssl.client.allowTrustedExpiredCertificates
  • server.ssl.client.identitystore.keyfactory.alg.name
  • server.ssl.client.truststore.keyfactory.alg.name
  • server.ssl.algorithm.name
• Parameters for Veridata Command-Line Utility
  • veridata.cli.run_from_managed_server
  • veridata.cli.managed_server_name
  • veridata.cli.server.listenAddress
  • veridata.cli.server.timeout.seconds
• Parameters for Report File Encryption
  • server.encryption
  • server.encryption.bits

A Moving from a Test to Production Environment

• A.1 Moving Installations from a Source Environment to a Target Environment
• A.2 Additional Steps for Moving Oracle GoldenGate Veridata Repository
  • A.2.1 Moving Veridata Configuration Data from Test to Production
  • A.2.2 Applying Configuration Changes while Moving from Test to Production
  • A.2.3 Modifying the Agent details in the Production Environment

B Sample Configuration File

• B.1 Sample Configuration File

C Profile Parameters

• C.1 General (profile-general)
• C.2 Sorting Method (sorting-method)
• C.3 Initial Compare (initial-compare
• C.4 Confirm-Out-Of-Sync (confirm-out-of-sync)
• C.5 Repair (repair)