NON-COMPARABLE OBJECT TOOLS

Filling in the Gaps in PeopleSoft’s Release

Management Tools

Leandro Baca

2

NON-COMPARABLE OBJECTS

• 7 PeopleTools object types cannot be subjected to Compare Reports or “Copy to/from File” operations in Application Designer

• Trees

• Access Groups

• Roles

• Message Catalog Entries

• Dimensions

• Cubes

• Cube Instances

3

NON-COMPARABLE OBJECT TOOLS

• Three tools

• Compare and Report on non-comparable objects

(through Integration Broker)

• Copy objects between environments (through

Integration Broker)

• Automatically generate Data Mover scripts to

copy non-comparable objects to/from file

• Enable direct compare and copy operations

across networks

4

VS. DATA MIGRATION WORKBENCH

• Introduced in PeopleTools 8.53, DMW provides similar functionality

• However, DMW is unwieldy

• Requires access to file servers

• Requires in-depth knowledge of PS_*_HOMEs

• Requires dealing with file permissions and ownership

• Forces you to work with separate projects

• In Addition, the Non-Comparable Object Tools enable full database compares

5

USE CASES

• Day-to-day release management DevOps

• Avoid losing customizations when applying

PeopleSoft patches

• Avoid losing customizations during upgrades

• Reduce release management errors due to

hand-coded DMS

6

SIMPLE INTEGRATION BROKER DEPLOYMENT

• Set up routings between your environments

• Enforce logical environment sequencing during release management

• Use standard security to limit who can run Compare Reports and project copies

7

START BY OPENING A PROJECT DEFINITION

8

LAUNCH COMPARE PROCESS: SELECT TARGET

• Target environments filtered by IB routings

9

SET COMPARE OPTIONS

10

CHOOSE COMPARE SCOPE

11

EXAMPLE FOR FULL DATABASE COMPARE

12

COMPARE REPORT AVAILABLE ONCE COMPLETE

13

UPGRADE VIEW DETAILS: SAMPLE

14

UPGRADE VIEW DETAILS: SAMPLE

• View adapted to object type

15

COMPARE REPORT RESULTS STORED IN TABLES

16

LAUNCH COPY PROCESS: SELECT TARGET

• Target environments filtered by IB routings

• Independent from Compare process permissions

17

CHOOSE COPY SCOPE AND LAUNCH

18

LAUNCH EXPORT PROCESS: SCOPE AND OPTIONS

19

REVIEW AND DOWNLOAD DATA MOVER SCRIPTS

• Configurable file headers

20

FUTURE ENHANCEMENTS

• BI Publisher template for Compare Reports (for

printable version)

• Integrate Compare Report results with the Text

Diff bolt-on (see separate slideshow)