Oracle GoldenGate Veridata compares source data with that of the target, identifies discrepancies, generates comparison reports, and repairs the out-of-sync jobs.
In this article, I would like to highlight a few key features of Oracle GoldenGate Veridata. I call them the 5Cs of this GoldenGate flavor: Connections, Configure Groups, Compare Pairs, Configuring Partitions, and Correcting Jobs.
If you want to get started with Oracle GoldenGate Veridata, then your first step is to create connections to the source and target databases; these databases contain the data that you want to compare. The Oracle GoldenGate Veridata server uses this connection information to communicate with the Veridata agent.
Here's a snapshot of the GoldenGate Veridata product:
A Connection is defined by a host, the port number of an Oracle GoldenGate Veridata Agent, and the datasource the agent accesses. Create Connections before you create any of the GoldenGate Veridata objects, such as groups, compare pairs, profiles, or jobs.
Create a Group and associate it with a set of connections to the source and target data.
Compare pairs are linked to groups. A compare pair is the logical relationship between a source table or file and a target table or file for the purpose of comparing their data.
To run the compare pairs, you must create and execute the job.
Watch this video to create Connections, Configure Groups, Compare Pairs, and Correct Jobs:
Configure Partitions - Now, let's talk about the 4th C.
Partitions allow you to compare source and target tables or files that have the same structure but a different number of rows. The usage of partitions also speeds throughput by splitting the load into multiple processing streams.
There are 2 types of Partitioning in Oracle GoldenGate Veridata:
You can configure manual or automatic row partitioning by using the existing database table partitions.
“Manual Row Partitioning” helps you to create multiple row partitions on a given table and then you can select any one partition in the comparison pair. The “Automatic row partitioning” functionality allows you to create row partition for a selected table and creates the compare pairs for each partition automatically.
Watch this video to get a better idea on configuring different types of row partitions in Oracle GoldenGate Veridata:
Finally, the 5th C - Correct the out-of-sync jobs by using the Repair Jobs functionality. Oracle GoldenGate Veridata also provides the Generate SQL functionality (specific to Oracle), which generates SQL files for the source and target tables associated with the out-of-sync jobs.
Reviewed and Approved by: Nisharahmed Soneji, Senior Principal Product Manager, GoldenGate Development & Aslam Khan, Senior User Assistance Development Manager.
As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.
Previous Post
Next Post