Browser-Based PeopleSoft Data Compare
BEAM Compare provides browser-based PeopleSoft data comparisons. The tool, which is part of BEAM Change, compares records, and groups of records, across two or more environments. Built in PeopleTools, BEAM 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 Compare confirms changes and reduces testing efforts.
BEAM Compare 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 Compare compares data, metadata, PeopleCode and SQL, across environments, and between applications, releases/images, and platforms.
BEAM Compare finds differences and/or verifies changes, freeing up people to resolve issues and make further improvements.
With the automated capabilities of BEAM Compare, moves and changes can be verified—compare data and objects in the source and target—before formal testing begins. Developers using BEAM Compare 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 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 Compare provides all these comparisons in a single job.
BEAM Compare 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 compares all aspects of PeopleSoft data.
A Simple Record Compare Example
When BEAM Compare 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 Compare can filter these types of differences out of its 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.
Finally, by clicking on the Budgetary_Only details we can see that two records have different values in the source and target.
BEAM Compare 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 Compare is delivered with 18 types of Compare jobs (See below.)
Pick one. Specify a source, a target, and enter a parameter. (BEAM Compare even prompts you with lists of valid parameters, dynamically, to help.) Run. See differences.
BEAM Compare 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.
Below is the BEAM Class of App Engine Programs. A BEAM compare of this class would show any differences in these records between environments.
BEAM Compare - Set Up and Architecture
BEAM Compare is delivered as a PeopleSoft project and installed in an (empty) PeopleTools environment. Installation and set up typically takes a day or two. BEAM Compare 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.