Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Information
  • Conventions
• Overview
  • What is Oracle GoldenGate Veridata?
  • Concepts
  • Oracle GoldenGate Veridata Architecture
  • How Oracle GoldenGate Veridata Works?
    • Initial Step or Row Hash Step in Maybe Out of Sync
    • Confirm Out of Sync
  • Oracle GoldenGate Veridata Supported Use Cases
• Prepare
  • Supported Databases for Compare
  • Supported Databases for Repair
  • Supported Databases for Repair SQL
  • Supported Datatypes
    • Supported Datatypes - Oracle
    • Supported Datatypes - Microsoft SQL Server
    • Supported Datatypes - PostgreSQL
    • Supported Datatypes - MySQL, MariaDB
    • Supported Datatypes - DB2 LUW
    • Supported Datatypes - DB2 for i
    • Supported Datatypes - DB2 z/OS
    • Supported Datatypes - Sybase Adaptive Server Enterprise
    • Supported Datatypes - Teradata Vantage
    • Supported Datatypes - Snowflake
    • Supported Datatypes - SingleStore Database
    • Supported Datatypes - Databricks
    • Generic Limitations and Clarifications
  • Oracle GoldenGate Veridata Agent System Requirements
    • Disk and Memory Requirements for the Agent Component
    • Database Privileges for the Agent Component
  • Oracle GoldenGate Veridata Server System Requirements
    • Location for the Server Component
    • Disk and Memory Requirements for the Server Component
  • Oracle GoldenGate Veridata Distribution
    • Downloading Oracle GoldenGate Veridata
    • Downloading Oracle GoldenGate Veridata C-Agent and Java Agent
• Install
  • Installing and Running Oracle GoldenGate Veridata
  • Logging
    • Logs and Log Levels
    • Installer Logs
    • Configuration Assistant Logs
    • Agent
      • Agent Logs Location
      • Updating Agent Log Settings
      • Enabling Performance Logs
      • Enabling Trace Logs
      • Enabling Query Logs
      • Modifying Log Size
    • Server
      • Server Log Location
      • Updating Server Log Levels
      • Changing Log Size
  • Running the Configuration Assistant
  • Installing and Configuring Source and Target Agents
    • About Oracle GoldenGate Veridata Agent Deployment Scripts
    • Configuring Oracle GoldenGate Veridata Agent
    • Starting the Oracle GoldenGate Veridata Agent
    • Using the Oracle GoldenGate Veridata Agent Deployment Script in Debug Mode
    • Reloading the Logging Properties of the Veridata Agent
  • Silent Installation
  • Uninstalling Oracle GoldenGate Veridata
  • Installing Oracle GoldenGate Veridata C-Agent
    • Installation Overview
    • Installing the C-Agent on a NonStop System
      • Installing the Oracle GoldenGate Veridata Agent Files
      • Copying VSNSERV to Remote Nodes
      • Creating a GLOBALS File
      • Configuring Manager
  • Best Practices
    • Veridata Components Proximity
      • How to Check Connection between 2 Nodes
    • Veridata Server and Agent Memory
      • Server Memory
      • Agent Memory
      • Memory for Sorting and Sort Directory
    • CPU Sizing Recommendations
    • SSL Certificate Validation
    • Database Permissions
    • Data for Comparison
      • Specifying Primary Key (PK) Columns
      • Partitioning
      • Exclude Columns
      • Delta Comparison
        • Delta Column Selection
        • ROWDEPENDENCIES
    • Veridata Configurations
      • Connection Configurations
      • Profile Configurations
        • Sorting Configuration
        • Initial Compare Configuration
        • Out-of-Sync Configuration
        • Repair Configuration
      • Server Configurations
      • Agent Configurations
        • Coos Batch Fetch
        • ROWSCN
    • Frequently Asked Questions (FAQ)
• Get Started
  • Accessing Oracle GoldenGate Veridata Web User Interface
  • Home Page
    • Settings
    • About
    • Help
    • User Menu
• Manage
  • Connections
    • Creating a Connection
    • Viewing and Editing a Connection
    • Deleting a Connection
  • Groups and Compare Pairs
    • Group Details
      • Creating Groups and Compare Pairs
        • Mapping Rules
        • Mapping
          • Automatic Row Partition
        • Preview and Generate Compare Pairs
      • Cloning a Group
      • Deleting a Group
    • Compare Pairs
      • Compare Pair Details
        • Column Mappings
          • Validate Column Mapping
          • Key Mapping Method
        • Delta Processing
          • What is Delta Processing?
        • Row Partitions
        • Deleting a Compare Pair
  • Profiles
    • Editing Profile Settings
    • Using the Default Profile
  • Jobs
    • Overview
    • Creating a Job
    • Running Jobs
      • Overriding Manual Row Partitions
    • Editing a Job
    • Scheduling a Job
    • Monitoring Jobs
      • Viewing Completed Jobs
      • Viewing Jobs that are Running
      • Viewing Details of the Repair Jobs
    • Estimating Comparison Time
    • Using the Comparison Report
    • Repairing Out-Of-Sync Jobs
      • Downloading SQL Statements for Out-of-Sync Records
        • Executing the SQL File
  • Users
    • Configuring User Groups
    • Configuring Users
  • Utilities
    • Export
    • Import
• Administer
  • Starting and Stopping the Veridata Server and the Repository
  • Managing Veridata Agent
    • Starting and Stopping the C-Agent
    • Managing Java-Based Components
      • Starting and Stopping the Java-Based Components
      • Managing Bequeath Agent
    • Reloading Logging Information
    • Connecting to the Oracle GoldenGate Veridata Web Interface
  • Vericom
    • Overview of the Vericom Tool
    • Supported Commands in Vericom
    • Vericom Output Examples
  • Veridata Export and Import Utilities
    • Introduction to the Export and Import Utilities
      • Supported Configurations
    • Running the Export and Import Utilities
      • Using the Export Utility
      • Using the Import Utility
      • Processing the Configuration
      • SSL Configuration for Export and Import Utilities
    • 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
      • table partition
  • Server Parameters
    • Overview of the Server Memory
    • Estimating Memory Usage
    • How to Set a Parameter
    • Parameter Descriptions
  • Agent Parameters - General
    • compare.xmldatatype.format
    • coos.batch.fetch
    • database.characterSet
    • database.transaction.isolation
    • pool.maxIdleTime
    • pool.checkInterval
    • pool.maxIdle
    • pool.maxSize
    • pool.maxStatements
    • server.port
    • rowscn
    • zlib.buffer.flush.size
    • network.checksum.level
    • network.checksum.types
    • network.encryption.level
    • network.encryption.types
  • Agent Parameters - Connections
    • IBM Db2 for i
    • IBM Db2 for LUW
    • IBM Db2 for z/OS
    • Apache Hive
    • MariaDB
    • Microsoft SQL Server
    • MySQL
    • Oracle Database
    • PostgreSQL
    • Snowflake
    • Sybase Adaptive Server Enterprise
    • Teradata Vantage
    • SingleStore
    • MongoDB
    • Databricks
• Configure
  • High Availability
    • Setting Up the High Availability for Oracle GoldenGate Veridata Server
    • Configuring a Shared File Path
      • Reports
      • Wallet
    • Setting up High Availability for Oracle GoldenGate Veridata Agent
• Secure
  • Securing Access to Oracle GoldenGate Veridata
    • Overview of Oracle GoldenGate Veridata Security
    • Configuring SSL Connection between Oracle GoldenGate Veridata Server and Agents
  • Configuring Workflow for Two-Way SSL in Oracle GoldenGate Veridata using Self-Signed Certificates
    • Enabling SSL in the Agent Properties File
    • Generating Agent Keystore and Certificate
    • Generating Server Keystore and Certificate
    • Importing Agent Certificate to Server Truststore
    • Saving Server Keystore/Truststore Passwords to Server Wallet
    • Importing Server Certificate to Agent Truststore
    • Saving Agent Keystore/Truststore Passwords to Agent Wallet
    • Creating an Agent Connection in UI
  • Configuring Workflow for Two-Way SSL in Oracle GoldenGate Veridata using Custom Certificates
    • Copying Custom Certificates
    • Enabling SSL in the Agent Properties File
    • Generating Agent Keystore and Truststore
    • Saving Agent Keystore/ Truststore Passwords to Agent Wallet
    • Generating Server Keystore and Truststore
    • Saving Server Keystore/ Truststore Passwords to Server Wallet
    • Creating an Agent Connection in UI
  • Configuring Two-Way SSL for the NSK C-Agent on the Veridata Server
  • Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Oracle Database
  • Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Hive
  • Connecting Oracle GoldenGate Veridata to SSL-Enabled Oracle Database
  • Connecting Oracle GoldenGate Veridata to SSL-Enabled MySQL Database
  • Connecting Oracle GoldenGate Veridata to SSL-Enabled SQL Server Database
  • Connecting Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL Database
  • Connecting Oracle GoldenGate Veridata to SSL-Enabled Mongo Database
  • Veridata Keystore Files
    • Replacing Veridata Web Certificates
• Migrate
  • Migrating Veridata Configuration from Veridata 12.2.1.4.0 to Oracle GoldenGate Veridata 26c
• Performance
  • Improving the Performance of Oracle GoldenGate Veridata
• Accessibility
  • About this Accessibility Article
    • Accessibility Overview
    • What is Web Accessibility?
    • Why Accessibility is Important?
    • About Building for Accessibility
  • Using Oracle GoldenGate Veridata with Assistive Technologies and Keyboard
    • Component-Specific Keyboard Controls
• Troubleshooting
  • Configuration Assistant
  • MySQL Operation
  • Comparison and Repair Performance
    • Slowed Comparison
      • Sorting Phase
      • Initial Compare Phase
      • COOS Phase
      • Check Stalled Queries in Database
    • Slowed Repair