GoldenGate Veridata is an easy-to-use tool that manages to identify out-of-sync data and in the new version optionally to repair it. It is cross-platform and is efficient of comparing data between divergent databases without affecting other ongoing operations.
Before we go any further on how GoldenGate Veridata functions, its architecture should be inspected. The two-way arrows indicate that all communications are duplex. It must be pointed out that GoldenGate Veridata repository, source and target databases can coincide on the same machine where GoldenGate Veridata components are deployed or on separate.
GoldenGate Veridata server
The GoldenGate Veridata server coordinates all the tasks, sorts rows, compares the data between source and target database, confirms out-of-sync data and produces a report for review.
GoldenGate Veridata web User Interface (UI)
GoldenGate Veridata web UI is a graphical user interface that is used for configuring comparison objects and rules, initiating comparisons, reviewing the status and output of comparisons, reviewing out-of-sync data and repairing them.
GoldenGate Veridata repository
GoldenGate Veridata repository is a collection of database objects that persists configuration information, saving it permanently as a user environment.
GoldenGate Veridata agent
GoldenGate Veridata agent is responsible for fetching and returning blocks of rows to compare, as well as returning column-level detail for out-of-sync rows on behalf of the GoldenGate Veridata Server. Also the agent hashes the row and then sends the row hash plus PK values to the Veridata Server for sorting and comparison.
GoldenGate Veridata manager
The manager is part of the C-code based agent that is required for the Nonstop platforms. It controls the agents’ process.
GoldenGate Veridata Command Line Interface (CLI)
GoldenGate Veridata CLI or else called vericom is an interface that enables you to run comparisons, specify overrides and stop
IPv6 support for java agents
Previous releases of GoldenGate Veridata supported only IPv4 for the java agents. The new release now provides IPv6 support too.
Single sign-on support :
Single sign-on provides the user with logging in once and gaining access to all GoldenGate Veridata tools without being prompted to log in again.
Security enhancements :
New security roles were added for the users in order to control their access in GoldenGate Veridata. Moreover, support for Secure Sockets Layer (SSL) communication between Veridata Server and Veridata Agents was added.
Report encryption :
GoldenGate Veridata now provides the option to encrypt the report files of the comparisons between the source and the replicated databases.
Installation using Oracle universal installer
From this release, GoldenGate Veridata is a part of Oracle Fusion Middleware. Oracle Fusion Middleware is a platform for the enterprise and it consists of certain Oracle products. For this reason, GoldenGate Veridata 12c uses Oracle Universal Installer for the installation and configuration process.
