Oracle GoldenGate Veridata compares one set of data to another and identifies data that is out-of-sync, and allows you to repair any data that is found out-of-sync. Oracle GoldenGate Veridata supports high-volume, 24x7 heterogenous replication environments where downtime to compare data sets is not an option. By accounting for data that is being replicated while a comparison takes place, Oracle GoldenGate Veridata can run concurrently with data transactions and replication, while still producing an accurate comparison report.
Oracle GoldenGate Veridata will map column data types across different types of databases automatically, or you can map columns manually in cases where the automatic mapping is not sufficient to accommodate format differences in a heterogeneous environment. For detailed information about this feature in Veridata Web User Interface, see Oracle GoldenGate Veridata Online Help. Alternatively, you can map data by manually uploading an XML file using the
veridata_import utility. For more information, see .
For the purposes of this documentation, the following terms are considered synonymous:
tables and files
columns and fields
rows and records
Figure 1-1 Oracle GoldenGate Veridata Architecture
Oracle GoldenGate Veridata Server
Coordinate the execution of Oracle GoldenGate Veridata tasks
Sort rows (optional)
Confirm out-of-sync data
Produce a report for review
Oracle GoldenGate Veridata Web User Interface
Oracle GoldenGate Veridata Web User Interface (UI) is a browser-based graphical user interface for these activities:
Configure comparison objects and rules
Review the status and output of comparisons
Repair out-of-sync data
Review out-of-sync data
Oracle GoldenGate Veridata Repository
The Oracle GoldenGate Veridata repository is a collection of database objects that persists configuration information to disk, saving it permanently as a user environment.
Out-of-sync data is not stored in the Veridata repository. This data is stored in files on the file system of the Veridata Server.
Oracle GoldenGate Veridata Agent
The Oracle GoldenGate Veridata Agent executes the following database-related requests on behalf of the Oracle GoldenGate Veridata Server:
Hash rows for initial comparison
Fetch and update rows to repair out-of-sync data
Return column-level detail for out-of-sync rows
Oracle GoldenGate Veridata Manager
The Manager process is part of the C-code based agent that is required for the NonStop platform. It controls the Oracle GoldenGate Veridata Agent process.
The Manager is not used in a Java agent, which is used for the other databases that are supported by Oracle GoldenGate Veridata.
Oracle GoldenGate Veridata Command Line Utilities
Oracle GoldenGate Veridata includes the following command-line utilities:
Table 1-1 Command-Line Utilities
Enables you to run comparisons by using automated programs. See Using the Veridata Command Line Tool.
Maps comparison objects and rules in an XML file and imports it into the repository. See Using the Veridata Import and Export Utilities.
Maps comparison objects and rules in the repository and exports them to an XML file. See Using the Veridata Import and Export Utilities.
The Veridata GoldenGate Parameter Processing (VGPP) command line tool to use Oracle GoldenGate parameter files. See Introduction to Oracle GoldenGate Veridata.
Supports viewing encrypted report files and out-of-sync data.