Table of Contents
- Title and Copyright Information
- Preface
-
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.1.1 Supported Datatypes - Oracle
- 1.3.1.2 Supported Datatypes - SQL Server
- 1.3.1.3 Supported Datatypes - PostgreSQL
- 1.3.1.4 Supported Datatypes - MySQL, MariaDB
- 1.3.1.5 Supported Datatypes - Teradata
- 1.3.1.6 Supported Datatypes - DB2 LUW
- 1.3.1.7 Supported Datatypes - DB2 for i
- 1.3.1.8 Supported Datatypes - DB2 z/OS
- 1.3.1.9 Supported Datatypes - Sybase
- 1.3.1.10 Supported Datatypes - Informix
- 1.3.1.11 Generic Limitations and Clarifications
- 1.3.2 Satisfying Uniqueness Requirements
- 1.3.3 How Oracle GoldenGate Veridata Compares Data
-
1.3.1
Oracle GoldenGate Veridata Comparison Objects
- 1.4 Viewing Comparison Results
-
2
Configuring Security
- 2.1 Overview of Oracle GoldenGate Veridata Security
-
2.2
Configuring SSL Connection between Oracle GoldenGate Veridata Server and Agents
- 2.2.1 One-Way SSL Connection
- 2.2.2 Two-Way SSL Connection
- 2.2.3 Generating Self-Signed Keystores and Truststores
- 2.2.4 Configuring SSL Settings for the Oracle GoldenGate Veridata Agent
- 2.2.5 Updating Oracle GoldenGate Veridata Agent Wallet
- 2.2.6 Configuring SSL Settings for the Oracle GoldenGate Veridata Server
- 2.2.7 Configuring an SSL Connection between Oracle GoldenGate Veridata Server and NonStop Agent
- 2.2.8 Updating Oracle GoldenGate Veridata Server Trust Store
- 2.3 Securing the Oracle GoldenGate Veridata Files
- 2.4 Securing Access to Oracle GoldenGate Veridata by Defining User Groups
- 2.5 Creating and Editing Users
- 2.6 Changing Database Schema Passwords
- 2.7 Encrypting Report Files
- 3 Managing C-Agent, Manager, and Java Components
- 4 Managing Identities and Comparing Data
-
5
Using the Veridata Import and Export Utilities
- 5.1 Introduction to the Import and Export Utilities
- 5.2 Running the Import and Export Utilities
- 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
- 5.29 table partition
- 6 Running Veridata GoldenGate Parameter Processing
-
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.4.1
Server Parameters
- 7.4.1.1 database.hash
- 7.4.1.2 max_lob_key_len
- 7.4.1.3 server.concurrent.readers
- 7.4.1.4 server.concurrent.writers
- 7.4.1.5 server.convert_empty_to_null
- 7.4.1.6 server.mapped_sort_buffers
- 7.4.1.7 server.max_concurrent_comparison_threads
- 7.4.1.8 server.max_concurrent_jobs
- 7.4.1.9 server.max_sort_memory
- 7.4.1.10 server.memory_mapped_sort_directory
- 7.4.1.11 server.meta_session_handle_timeout
- 7.4.1.12 server.persistence_db_type
- 7.4.1.13 server.veridata_data
- 7.4.1.14 socket.timeout.mins
- 7.4.1.15 truncate_spaces_len
- 7.4.2 Parameters for Configuring SSL Communication
- 7.4.3 Parameters for Veridata Command-Line Utility
- 7.4.4 Parameters for Report File Encryption
- 7.4.5 Parameters for Email Notifications and Alerts
- 7.4.6 Server Parameters for Oracle Streams Tagging
- 7.4.7 Server Parameters for Confirm Out-of-Sync Fetch Strategy
-
7.4.1
Server Parameters
- 8 Agent Parameters
- A Moving from a Test to Production Environment
- B Sample Configuration File
- C Profile Parameters