Browser-Based PeopleSoft Data Compare

BEAM Data provides browser-based PeopleSoft data comparisons. The Data tool compares records, and groups of records, across two or more environments. Built in PeopleTools, BEAM Data Compare generates SQL to execute fast, precise and granular comparisons of PeopleSoft data—and structures—between environmants.

The ability to compare data—and everything in PeopleSoft is data, or data about other data—adds a high level of precision, visibility (and comfort) to PeopleSoft teams, and their management. Analysts and developers can "Do More with Less" time and effort, as BEAM Data confirms changes and reduces testing efforts.

BEAM Data is also used to diagnose and troubleshoot issues. It gives both technical and business users a common tool, and a common, consistent set of results (all differences with values by key between selected environments) to share, analyze, and reconcile. 


BEAM Data Compare compares data, metadata, PeopleCode and SQL, across environments, and between applications, releases/images, and platforms.beam_of_light

BEAM Data Compare finds differences and/or verifies changes, freeing up people to resolve issues and make further improvements.

With the automated capabilities of BEAM Data, moves and changes can be verified—compare data and objects in the source and target—before formal testing begins. Developers using BEAM Data are assured that what they turn over is what they intended to turn over.The knowledge that configurations and structures in environments are the same makes for a reduced and less risky test process. Testers and analysts can focus on testing functionality.


Too often, much of the effort (and time) is spent in finding the problem, not in resolving the issue. Isolating differences is done manually.

The process is often time consuming, laborious, and challenging. Complicating the problem, team members use role-based tools.

Users and analysts are likely to run queries in different environments, and try to compare the results in Excel. They want to make sure their configuration data—bank accounts, vendors, job codes, departments, permission lists, trees, and security objects—are set correctly across environments.

Developers are likely to write SQL or run SQRs, again in different environments, and compare results. App Designer can compare objects, but not the values within those objects. 

Administrators and DBAs are likely to use database compare tools, primarily to check structures.

Each of these tools provide a piece of the puzzle. 

BEAM Data compares the record data (for users), the record definitions, the records fields, any PeopleCode or SQL objects (for developers), and the database definitions (for DBAs). And it does it quickly, reliably, and precisely.

BEAM Data provides all these comparisons in a single job.

BEAM Data saves time and effort throughout the change process, easing the burden of testing changes, leading to more reliable applications.

Communication is also improved, as both technical and business teams, using the same BEAM jobs, can share and see the results of compares in a common format, and run jobs the same way.


BEAM Data compares all aspects of PeopleSoft data.

A Simple Record Compare Example

When BEAM Data does a record compare, it compares everything related to the record. Record Definitions, Record Fields, Database Fields, Record Data, as well as any PeopleCode, and SQL attached to the record. Any differences in any step will be shown as a result.


Results are first shown in summary, by step. Here, we show 15 data differences in DEPT_TBL, and 8 differences in the database field definitions. (In this case, the database differences are merely time-stamp differences, which you would see by clicking on its Summary button. BEAM Data can filter these types of differences out of its results)

Compare results

Next, clicking on the yellow Summary button will display the DEPT_TBL differences, and the last step shows the keys of the records that are different.

BEAM Difference Detail

Finally, by clicking on the Budgetary_Only details we can see that two records have different values in the source and target.


BEAM Data compares Records, and groups of Records

In addition to comparing records (including wildcards), BEAM Data compares groups of records. We deliver jobs for the logical groups of records in PeopleSoft – Pages, Components, Trees, etc. This makes it quick and easy to investigate these data structures.

BEAM Data is delivered with 18 types of Compare jobs (See below.)

Pick one. Specify a source, a target, and enter a parameter. (BEAM Data even prompts you with lists of valid parameters, dynamically, to help.) Run. See differences.


BEAM Data also supports the use of Classes. A Class is just a group of records. Customers may group any records together in a class, and compare all the records in the class.

Beacon has set up and delivers classes for PeopleTools records. This enables quick comparisons of various PeopleTools groups, such as AE Programs, Business Interlinks, and all other PeopleTools functions.


BEAM Classes

Below is the BEAM Class of App Engine Programs. A BEAM Data compare of this class would show any differences in these records between environments.

AE Program Records

BEAM Data. Set Up and Architecture

BEAM Data is delivered as a PeopleSoft Project and installed in an (empty) PeopleTools environment. Installation and set up typically takes a day or two. BEAM Data is a read-only tool, (with options for downloading differences to spreadsheets, or automatically generating Data Mover Scripts for updates). Essentially, the BEAM environment is an enhanced PeopleTools environment  (with %Compare and other BEAM functions).

  • One BEAM environment (BEAM and PeopleTools) to manage all your other environments.
  • Define DB Links or Linked Servers in BEAM.
  • Run predefined jobs for comparisons.
  • Select source, select target, provide a parameter.
  • BEAM Data will show all differences, with values.

BEAm and Customer environments

For more information on BEAM Features, click here