1.2 Concepts

Get familiar with the following concepts and other commonly used terms before you get started with Oracle GoldenGate Veridata.

To begin using Oracle GoldenGate Veridata, you need to create some objects that identify the data that you want to compare and which help you to manage your work. Create these objects in the following order:

  1. Connections: Define a Connection to the source and target databases that contain the data you want to compare. The Oracle GoldenGate Veridata server uses the Connection information to communicate with the Oracle GoldenGate Veridata agent.
  2. Groups: Groups are logical containers for one or more Compare Pairs. A Group is associated with a set of connections to the source and target data.
  3. Compare Pairs: A Compare Pair is the logical relationship between a source and target table for the purpose of comparing their data. Compare Pairs are linked to Groups.
  4. Jobs and Repairs: To run Compare Pairs, you must create a Job. The Job configuration determines which compare groups are processed. In the UI, you can repair jobs and also can generate SQL files for a few supported databases for out-of-sync jobs.
  5. Users, User Groups, and Roles: You can manage users and user groups from the User Management page. You can create, delete, edit, users and user group. Users and user groups are assigned with various roles, which are assigned with various privileges. The following are the various roles assigned in Oracle GoldenGate Veridata: Administrator, Super User, Monitoring Operator, Detail Monitoring Operator, Repair Operator, Job Operator, and Command Line Operator.
  6. Delta Comparison: In Oracle GoldenGate Veridata, the source and target tables are configured using compare pairs, which are grouped and added to a job to run the comparison. During the subsequent runs of a comparison job, the comparison of the tables can be performed based on what has changed in the tables from the previous job run; these jobs are Delta Processing Jobs.
  7. Profile: A profile is a set of global processing parameters, each containing unique settings for a specific purpose. Oracle GoldenGate Veridata provides a default profile, but you can create your own profiles. You can create as many profiles as needed and associate them with any job or compare pair (to override the job profile). You can override profile assignments at run time.