• Home
    • 2018
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • Reading
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

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
  • Oracle GoldenGate 12.1.3 Documenation 
  • Oracle GoldenGate12.1.3 Datasheet



 Last Updated: 2/26/2015.  
Copyright © 2010-2027 Jinyu Wang.