Oracle GoldenGate Veridata

What to Use
The current version is  12.1.3.0.0. The latest patch 12.1.3.0.2 provides the support of Informix IDS database.

Getting Started
Veridata has the following components:
  • Veridata Server: coordinates Oracle GoldenGate Veridata tasks, compares data, confirms out-of-sync data, and produces reports. 
    • Veridata Repository: Veridata needs a database, either Oracle, MySQL or SQL Server, to store management data.
    • Web Interface: Users can interact with the server through the Oracle GoldenGate Veridata Web User Interface client
    • Command Line Utility: the Vericom command client can be used to configure and run comparisons.
  • Veridata Agent: Interacts with a source or target database to fetch and return blocks of rows, return column-level detail, and execute requests on the database. The agent is started at the request of the Oracle GoldenGate Veridata Server. A Java agent is provided for most supported databases. A C-agent is provided for databases on the NonStop platform and is controlled by the Oracle GoldenGate Veridata Manager process on that platform.
Executive Summary 
Oracle GoldenGate Veridata is a high speed, low impact, heterogeneous data comparing utility. It can be used for comparing data, reporting the differences and repairing the out-of-sync data. The product can also send alert when the data are out-of-sync. The major features are:
  • Selective, parallel comparison
  • Support for Oracle and non-Oracle databases (DB2 LUW, DB2 z/OS, Enscribe, Oracle , NonStop SQL/MP, SQL Server, SAP Sybase Adaptive Server Enterprise (ASE), Teradata and Informix)
  • Support very large volumes
  • Flexible reporting for varying roles and access levels  

Resources
 Last Updated: 2/26/2015.