1/14

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Information
• Conventions

1 Introduction to Oracle GoldenGate Veridata

• 1.1 Oracle 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

2 Configuring Security

• 2.1 Overview of Oracle GoldenGate Veridata Security
• 2.2 Configuring an SSL Connection between Oracle GoldenGate Veridata Server and Agents
  • 2.2.1 Configuring One-Way and Two-Way SSL Connections
  • 2.2.2 Process for Enabling SSL
  • 2.2.3 Configuring SSL Settings for the Oracle GoldenGate Veridata Agent
  • 2.2.4 Configuring SSL Settings for the Oracle GoldenGate Veridata Server
  • 2.2.5 Creating Keystores and Self-Signed Certificates
    • 2.2.5.1 Creating an Identity Keystore with a Self-Signed Certificate
    • 2.2.5.2 Building Server and Agent Keystores
    • 2.2.5.3 Importing Certificates to the Server and Agent Truststores
    • 2.2.5.4 Examples
  • 2.2.6 Managing the Server Identity and Trust Keystores
  • 2.2.7 Modifying the Oracle GoldenGate Veridata Agent Wallet
• 2.3 Securing the Oracle GoldenGate Veridata Files
• 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 Displaying Encrypted Files with the reportutil Utility

3 Managing C-Agent, Manager, and Java Components

• 3.1 Starting and Stopping the C-Agent and the Oracle GoldenGate Veridata Manager
• 3.2 Starting and Stopping the Java-Based Components
• 3.3 Reloading Logging Information
• 3.4 Controlling Logging Levels for Oracle GoldenGate Veridata Agent
• 3.5 Connecting to the Oracle GoldenGate Veridata Web Interface

4 Managing Identities and Comparing Data

• 4.1 Overview of the Vericom Tool
• 4.2 Managing Identities in a Credential Store
  • 4.2.1 Adding a Credential Store
  • 4.2.2 Deleting a Credential Store
  • 4.2.3 Creating an Alias
  • 4.2.4 Using the Alias
  • 4.2.5 Display Alias
  • 4.2.6 Updating the Alias
  • 4.2.7 Deleting the Alias
• 4.3 Running the Vericom Tool
• 4.4 Vericom Exit Statuses
• 4.5 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
• 5.4 configuration
• 5.5 column
• 5.6 colfilter
• 5.7 colfiltercol
• 5.8 compare-pair
• 5.9 connection
• 5.10 conn-properties
• 5.11 delta-config
• 5.12 description
• 5.13 enscribe-info
• 5.14 enscribe-key
• 5.15 excluded-column
• 5.16 expandddl
• 5.17 filter
• 5.18 group
• 5.19 job
• 5.20 profile
• 5.21 key-column
• 5.22 profile-general
• 5.23 sorting-method
• 5.24 initial-compare
• 5.25 confirm-out-of-sync
• 5.26 param
• 5.27 repair
• 5.28 sql-partition

6 Running Veridata GoldenGate Parameter Processing

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

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
• 7.5 Server Parameters
  • 7.5.1 server.veridata_data
  • 7.5.2 server.persistence_db_type
  • 7.5.3 server.meta_session_handle_timeout
  • 7.5.4 server.max_concurrent_jobs
  • 7.5.5 server.max_concurrent_comparison_threads
  • 7.5.6 server.mapped_sort_buffers
  • 7.5.7 server.max_sort_memory
  • 7.5.8 server.concurrent.writers
  • 7.5.9 server.concurrent.readers
  • 7.5.10 server.number_sort_threads
• 7.6 Parameters for Configuring SSL Communication
  • 7.6.1 server.useSsl
  • 7.6.2 server.ssl.client.allowTrustedExpiredCertificates
  • 7.6.3 server.ssl.client.identitystore.keyfactory.alg.name
  • 7.6.4 server.ssl.client.truststore.keyfactory.alg.name
  • 7.6.5 server.ssl.algorithm.name
• 7.7 Parameters for Veridata Command-Line Utility
  • 7.7.1 veridata.cli.run_from_managed_server
  • 7.7.2 veridata.cli.managed_server_name
  • 7.7.3 veridata.cli.server.listenAddress
  • 7.7.4 veridata.cli.server.timeout.seconds
• 7.8 Parameters for Report File Encryption
  • 7.8.1 server.encryption
  • 7.8.2 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)