1/15

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New

• New and Changed Features for Release 12c (12.1.3)
• Other Significant Changes in this Document for Release 12c (12.1.3)

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.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.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 Encrypting Report Files
  • 2.5.1 Enabling Report Encryption
  • 2.5.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 Command Line Interface
• 4.2 Running Vericom
• 4.3 Vericom exit statuses
• 4.4 Vericom Output Examples

5 Configuration Scripting

• 5.1 Introduction to Scripting
  • 5.1.1 Supported Configurations
  • 5.1.2 Running the Scripting Utility
  • 5.1.3 Processing the Configuration
• 5.2 Elements
  • 5.2.1 configuration
  • 5.2.2 column
  • 5.2.3 compare-pair
  • 5.2.4 connection
  • 5.2.5 description
  • 5.2.6 enscribe-info
  • 5.2.7 enscribe-key
  • 5.2.8 expandddl
  • 5.2.9 group
  • 5.2.10 job
  • 5.2.11 partition
  • 5.2.12 query, source-query, target-query

6 Oracle GoldenGate Veridata Server Configuration Parameters

• 6.1 Overview of the Server Memory
• 6.2 Estimating Memory Usage
• 6.3 How to Set a Parameter
• 6.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.max_sort_memory
  • server.max_comparison_sort_memory
  • server.sort_waiting_threshold
  • 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

Glossary

Index