The BTRG Methodology for the PeopleSoft Upgrader Bruce Driver - - PowerPoint PPT Presentation

The BTRG Methodology for the PeopleSoft Upgrader

Bruce Driver

Chief Technology Architect

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

The BTRG Methodology for the PeopleSoft Upgrader

Best Practices For Fitting Your PeopleSoft Upgrade Into the Go-Live Time Window

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Outline

• PeopleSoft Upgrade Project Overview
• PeopleSoft Upgrade Project Roles
• Primary Goals of Multiple Upgrade Passes
• PeopleSoft Upgrade High-Level Outline
• PeopleSoft Upgrade Guidelines - Overall
• PeopleSoft Upgrade Guidelines – Task-By-Task
• PeopleSoft Upgrade Toolkit
• Summary

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Overview

• Multiple Upgrade Passes
• An Initial Upgrade Pass
• Several Move-To-Production (MTP) Upgrade passes
• Each pass has a Source database and a Target Database

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Overview

• Source database
• At the new PeopleSoft Application and PeopleTools

version

• New version PeopleSoft/ PeopleTools objects migrated

from the Source database to the Target database

• Initial Upgrade Pass
• Uses new version Demo database as the Source
• Move-To-Production Passes
• Use already upgraded Copy of Production as the Source

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Overview

• Target database
• A new copy of production
• Starts at old PeopleSoft Application and PeopleTools

versions

• Finishes a new PeopleSoft Application and PeopleTools

versions

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Overview

• Several PeopleSoft Move-To-Production

( MTP) Upgrade Passes

• Referred to as Practice MTP Upgrade Passes
• Performed to prepare for the eventual Go-Live MTP

Upgrade Pass

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Roles

Upgrader Developers Database Administrator Functional Module Leads Upgrade Project Manager Engagement Manager

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrader

• Lead role in executing the PeopleSoft Application

Upgrade procedure

• Executes tasks prescribed by PS Upgrade manual
• Uses Change Assistant to execute this procedure
• Performs Initial Upgrade Pass, Test MTP Upgrades

Passes, and Go-Live MTP Upgrade Passes

• Installs and configures Change Assistant and

Environment Management Framework

• Often installs target PS App/ PT versions including new

version Demo database

• PeopleSoft infrastructure administration skills and

strong SQL skills needed

• Performance tuning and debugging skills
• Database administration skills helpful

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Developers

• Technical PeopleSoft developer responsible for:
• Reviewing existing customizations
• Re-implementing customizations being maintained
• Developing new customizations if required
• PeopleSoft development skills as necessary
• Application Engine, PeopleCode, SQR, COBOL, SQL
• XML, Web Services

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Database Adm inistrator

• Create and administer the PeopleSoft databases

necessary for a PeopleSoft Upgrade

• PeopleSoft Demo databases
• PeopleSoft Upgrade Source database
• PeopleSoft Upgrade Target database
• New version Development, Test, UAT, Production

databases

• Performance Tuning

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Functional Module Leads

• Functional responsibility for supporting specific

PeopleSoft module(s) through the upgrade

• Financials – GL Module Lead, AP Module Lead, AR

Module Lead, etc.

• HCM – Benefits Module Lead, Payroll for NA Module

Lead, etc.

• Functional expertise in the specific PeopleSoft

module(s) for which is the lead

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Project Manager

• Responsible for managing the PeopleSoft

Upgrade project

• Development and maintenance of the Upgrade Project

plan

• Management of Upgrade Project resources
• Ensuring successful completion of project deliverables
• Project status reports
• Project issue management and change management
• Onsite and provides day-to-day management of

Upgrade team for larger upgrade projects

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Engagem ent Manager

• Senior-level manager with comprehensive

implementation experience

• Serves as advisor during the PeopleSoft Upgrade project
• Ensures adequate stakeholder and business

representative involvement

• Usually offsite and participates in Steering Committee

meetings

• Point of contact for project engagement issues

escalation

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Prim ary Goals of Multiple Upgrade Passes

Build Upgrade Toolkit

1

I dentify and Rem ove Upgrade Breakdow ns

2

Tune Upgrade Perform ance

3

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Prim ary Goals of Multiple Upgrade Passes

• Build Upgrade Toolkit
• Develop and compile a set of SQL scripts, Data Mover

script, and Guidance Notes

• Organized for easy reference with naming convention

reflecting Upgrade task/ step

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Prim ary Goals of Multiple Upgrade Passes

• I dentify and Resolve Upgrade Breakdow ns
• Example
• Alter Without Deletes tasks - run out of database space
• Data Conversion tasks – encounter unique constraint

violation on a unique index

• Identification and resolution of breakdowns consume

time

• Goal – identify and resolve all upgrade pass breakdowns

before the Go-Live MTP Upgrade Pass

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Prim ary Goals of Multiple Upgrade Passes

• Tune Upgrade Perform ance
• Make actual tasks/ steps of the Upgrade perform faster
• For example
• Data Conversion tasks
• Designing and creating appropriate indexes
• Rewriting SQL
• Rewriting Application Engine code
• Alter Without Deletes tasks/ Alter With Deletes tasks
• Create and run multiple Alter scripts in parallel

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Other Goals of Multiple Upgrade Passes

• E.g., Initial Upgrade pass – Project Compares
• Identify customizations
• Responsibility of PeopleSoft Developer
• Primary Goals of Multiple Upgrade Passes
• Primary goals of the PeopleSoft Upgrader

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrader Role

• Primary PeopleSoft Upgrader
• Needs to be involved in all Upgrade passes
• To achieve primary goals of multiple Upgrade Passes
• To build the knowledge to complete the Go-Live MTP

Upgrade Pass in the allotted Go-Live Time Window

• DO NOT
• Shuffle this responsibility between different team members
• Farm out to a part-time team member
• Backup PeopleSoft Upgrader
• Shadows Primary Upgrader, perhaps leads some passes

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade High- Level Outline

Chapter 1 : Planning Your Application Upgrade Chapter 2 : Preparing Your Database for Upgrade Chapter 3 : Applying PeopleTools Changes Chapter 4 : Running and Reviewing Compare Reports Chapter 5 : Applying Application Changes Chapter 6 : Completing Database Changes Chapter 7 : Applying Changes to the Production Database

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

"Amat victoria curam "

Catullus, Carmen 62: 16

"Victory loves preparation"

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• PeopleSoft Upgrade manual
• E.g., PeopleSoft Financials/ Supply Chain Management

8.9 to 9.2 Upgrade manual

• Prescribes required procedure on a Task-by-Task basis
• Typically 300 – 450 pages in length

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• "To a large extent the ultimate success of a

PeopleSoft Upgrade depends on the sustained attention to detail required to persevere in the successful execution of the PeopleSoft Application Upgrade tasks through multiple upgrade passes "

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Resist temptation to cut corners
• to skip steps deemed unnecessary for a particular

upgrade pass or to perform steps incompletely for the sake of expediency

• Multiple upgrade passes are practice for the Go-

Live upgrade pass

• Maxim: “Practice does not make perfect; rather, perfect

practice make perfect”

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Develop, Compile, and Retain Upgrade Scripts

and Notes

• E.g., upgrade task requires a set of tables to be dropped
• r set of indexes to be created
• Develop a SQL script and retain for future passes
• Have scripts log their output
• E.g, some upgrade tasks are executed conditionally
• Develop a script to ascertain this condition
• Compile notes pertinent to execution of specific tasks as

necessary

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Develop, Compile, and Retain Upgrade Scripts

and Notes

• Organize upgrade scripts and notes by directory

structure and useful naming convention

• E.g., including the Upgrade manual task description and

numbering

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Keep All Log and Trace Files
• Keep all log and trace files from all upgrade passes
• Not only for tasks/ steps run through Change Assistant
• But also for all tasks/ steps executed manually
• Not only enable debugging at time of breakdown
• Help diagnose problems not identified until some time

later during Unit or System testing

• Enable performance tuning by enabling identification of

poorly performing steps and SQL

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Update Statistics
• Update statistics for appropriate tables at all stages of

upgrade pass as prescribed by PS Upgrade manual

• Temptation to skip - communication and wait for DBA
• Without updating statistics subsequent steps in the

upgrade will be slower

• Will not adequately determine duration of these steps
• Determine how to update statistics efficiently
• Often can kick off update statistics script and proceed

with subsequent tasks of upgrade

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Update Statistics
• Three of the key tasks prescribed for updating statistics
• Performing Updates to PeopleTools System Tables
• Need to update statistics for affected PeopleTools tables
• Modifying the Database Structure
• After Alter Without Deletes and associated steps performed,

need to Update Statistics in preparation for Data Conversion

• Running Final Update Statistics
• After Finalizing the Database Structure and its associated Alter

With Deletes step, need to Update Statistics in preparation for remaining Upgrade tasks

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Perform Pre-Upgrade and Post-Upgrade Manual

Functional Tasks For All Upgrade Passes

• Typically completed by someone other than Upgrader
• Compile task lists
• for Chap 2 Pre-Upgrade Manual Functional Tasks
• for Chap 6 Post-Upgrade Manual Functional Tasks
• Determine which tasks necessary for this particular

PeopleSoft environment and who is responsible for performing each task

• Individual team member practice and team coordination

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Run Data Conversion and Other Upgrade Tasks

With Appropriate Tracing Enabled

• Expressed reluctance – “I don’t want to have tracing

enabled because it will slow it down.”

• Trace files of indispensible value in practice passes
• In identifying what steps need to be tuned
• In diagnosing and debugging Application Engine program

failures

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Run Data Conversion and Other Upgrade Tasks

With Appropriate Tracing Enabled

• Each upgrade pass may have particular focus – e.g.,

Performance Tuning MTP Upgrade Pass

• Each upgrade passes should work toward all of the Primary

Goals – including tuning performance

• Possible to choose an appropriate level of tracing so that

the impact on performance is minimized

• Need to be instrumented to facilitate problem diagnosis

and resolution

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Perform All Audits
• Chap 2 Preparing Your Database for Upgrade
• Initial DDDAUDIT, Initial SYSAUDIT, Initial Alter Audit
• Chapter 5 Applying Application Changes
• Final DDDAUDIT, Final SYSAUDIT, Final Alter Audit
• Audits can provide critical information necessary

for success of upgrade

• Can not rely on assurances of Non-Upgrade team

resources that “Production is audited and clean’

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• SQL Script Generation
• During Go-Live MTP Upgrade pass, upgrader should not

need to generate SQL scripts

• SQL scripts from previous MTP Upgrade passes can be used
• Conditions
• No records have been changed since those SQL scripts

were generated

• I.e., an appropriate code/ object freeze occurs before the

last time these SQL scripts were generated

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• SQL Script Generation
• Two of main tasks where these observations applicable
• Modifying the Database Structure
• Finalizing the Database Structure
• These tasks (along with Data Conversion) are two of the

most time-consuming tasks of an MTP Upgrade Pass

• Code Freeze
• Imperative that Record and Field definitions be frozen

before the final Test MTP Upgrade pass

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Data Mover Exports
• During Go-Live MTP Upgrade pass, upgrader should not

need to perform Data Mover exports from Source database

• Exports from previous MTP Upgrade passes can be used
• Condition
• an appropriate code/ object freeze - no modifications to

Source database since the Upgrade pass during which the exports were generated

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Upgrade Database Backups
• Upgrade manual prescribes database backups at various

points of the upgrade pass

• Database Backups – variety of different methods
• Work with DBA team to devise a backup method that is

fast and reliable

• Consider not only the amount of time to perform backup

but also the amount of time to perform restore

• If Go-Live Upgrade Time window is 72 hours and Database

Backup/ Restore method requires 36 hours for Restore, that factor should be known when weighing options

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Go-Live MTP Upgrade Pass Deployment Timeline
• Compile Upgrade task timings to compile a Go-Live MTP

Upgrade Pass Deployment timeline

• Include tasks not only explicitly documented in Upgrade

manual, but also Pre- and Post-Upgrade task such as

• Suspending and restarting Production system system feeds

and interfaces

• Disabling user access for the duration of Go-Live

Deployment

• Creating new Production PeopleSoft infrastructure

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines - Overall

• Go-Live MTP Upgrade Pass Deployment Timeline
• Include task resource assignments
• Compiled, updated, and reviewed repeatedly by Upgrade

team during latter phases of Upgrade project

• for completeness
• with view to complete the Upgrade successfully in the

designated Go-Live time window

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Guidelines – Task-By-Task

• PeopleSoft Upgrade Guidelines – Task-By-Task
• Preparing Your Database For Upgrade
• Applying PeopleTools Changes
• Applying Application Changes

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Toolkit

• PeopleSoft Upgrade Toolkit
• Necessarily different and specific for every customer’s

upgrade

• Nevertheless, significant commonality
• BTRG has developed toolkits and expertise in developing

Upgrade toolkits over the course of scores of upgrades

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Best Practices – Fitting Your PeopleSoft Upgrade I nto the Go-Live Tim e W indow

• PeopleSoft Upgrade Project Roles
• not enough to have a person, must have right person
• PeopleSoft Upgrader
• Special combination of PS and RDBMS administration,

development, debugging and tuning skills

• not everyone has the aptitude
• PeopleSoft Developer
• Combination of cross-functional/ development skills

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

• Primary Goals of Multiple Upgrade Passes

1. Build Upgrade Toolkit 2. Identify and Resolve Upgrade Breakdowns 3. Tune Upgrade Performance

Best Practices – Fitting Your PeopleSoft Upgrade I nto the Go-Live Tim e W indow

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

• PeopleSoft Upgrade Guidelines – Overall
• Preparation through Practice MTP Upgrade Passes
• Sustained Attention to Detail
• Upgrade Toolkit
• BTRG has prepared toolkits for scores of PeopleSoft

Upgrades

Best Practices – Fitting Your PeopleSoft Upgrade I nto the Go-Live Tim e W indow

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrades and BTRG BTRG has the expertise and experience to make your PeopleSoft Upgrade a success

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

The Future of PeopleSoft Maintenance: Patching and Updating w ith PS 9 .2 / PT 8 .5 3

Bruce Driver

Chief Technology Architect

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS 9 .2 / PT 8 .5 3 – New Features

• User Interface
• PeopleSoft Search Framework
• Life Cycle Management
• Server Administration and Infrastructure
• Security Administration
• Integration Technology
• Reporting and Analysis Tools
• Development Tools

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Lifecycle Managem ent

• PeopleSoft Update Manager
• Configuration Management with the Data

Migration Workbench

• PeopleSoft Test Framework
• Three-Way Merge Support

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager

• Overhaul of PeopleSoft Maintenance
• Update and Patching procedures
• PeopleSoft 9.2 application releases and

higher/ PeopleTools 8.53

• “a new Lifecycle Management process that is the next step in our

continued effort to help you lower the cost and stay current on your application maintenance”

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Classic PS Maintenance Approach

• Updates
• Bundles
• Maintenance Packs
• Cons
• Cumbersome process entailing downloading and

applying multiple Maintenance Packs and/ or Bundles sequentially

• As many as are necessary to get current or to fix

problem(s)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Classic PS Maintenance Approach

PeopleSoft Maintenance Then Creates Changes Packages Changes Consumes Changes

Customer

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager

• PeopleSoft Update Manager - new

m aintenance process

• Only maintenance facility for PeopleSoft 9.2 applications
• Intended for application maintenance only
• Minimal impact on installation and upgrade processes at

this time

• PeopleSoft Update Manager PI A Application
• delivered with PeopleTools 8.53 Lifecycle management

suite of tools

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager

• PeopleSoft I m ages
• Oracle VM VirtualBox virtual machines that you

download locally

• One PeopleSoft Image per application
• Released periodically according to the image schedule

posted on the My Oracle Support

• Master source environment from which
• Obtain updated objects
• Create a custom change package
• Apply updates to your environment

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager

• PeopleSoft I m age
• Contains the updates
• PeopleSoft Update Manager PI A Application
• The searching tool and custom change package

definition generator

• Change Assistant
• Still the tool used analyze and compare changes and to

apply updates to your environment

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager Process

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager Process

1. Review PeopleSoft Image schedule on My Oracle Support - PeopleSoft Update Manager Home Page [ ID 1464619.1] 2. On or after release date find link to PeopleSoft Image on PeopleSoft Update Manager Home Page 3. Each PeopleSoft Image is cumulative – only need to download most recent image 4. Download PeopleSoft Image and deploy PeopleSoft Virtual Machine running on Oracle Virtual Box

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager Process

5. Use PeopleSoft Manager PIA Application to search and select updates and to create a custom change package definition 6. Use PeopleTools Change Assistant to generate the change package, compare it to your environment, and apply the change package to your environment

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager Benefits

• Benefits
• No Bundles or Maintenance Packs
• Bundles and Maintenance Packs are all or nothing
• Each Patch, Bundle, or Maintenance Pack is its own change

package

• One Consolidated Change Package
• Change package tailored to your needs – you select the

updates you want

• Calculates dependencies (prerequisites) automatically
• No more maintenance of a DEMO environment for the sole

purpose of patching (if using Oracle DBMS)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Update Manager Costs

• Costs
• Incremental investment in infrastructure for running

Oracle cross-platform virtualization software – Oracle VM VirtualBox

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft I m age Virtual Machine

• PeopleSoft I m age
• Virtual machine running Oracle VM VirtualBox
• Guest Operating System - Oracle Enterprise Linux
• RDBMS - Oracle Database 11gR2
• No additional license requirements for PeopleSoft

VirtualBox Images used for non-production activities such as patches and updates or demonstration environments

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft I m age I dentification

• PeopleSoft I m age
• Delivered on regular, published schedule
• Current PeopleSoft Image is cumulative – containing all
• f the updates from previous PeopleSoft Images
• Each of the following applications will deliver an image
• n a regular basis
• Financials/ Supply Chain Management (FSCM)
• Human Capital Management (HCM)
• Customer Relationship Management (CRM)
• Enterprise Learning Management (ELM)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft I m age Virtual Machine

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

• PeopleSoft Update Manager PI A Application
• Available in the PeopleSoft Image virtual machine and

works only there

• Use to search within the PeopleSoft Image for updates,

fixes, and features and to create a custom change package definition

• Target environm ent
• Does not have to be at PeopleTools 8.53
• Application must be at PeopleSoft 9.2

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

• Navigation: Main Menu > PeopleTools > Lifecycle

Tools > Update Manager > Define Change Package

1 . Select a target database.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

2 . Enter a nam e for your change package.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

3 . Select the search option.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PS Update Manager PI A Application

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Various Application Updates

Type of Update Description

PeopleSoft Image The PeopleSoft Image is a VirtualBox virtual machine that is posted to My Oracle Support on a regular

• basis. This image contains several zip files that you

download locally. The PeopleSoft Image contains the very latest maintenance for the application release. This documentation focuses primarily on this type of update. PeopleSoft Release Patchset (PRP) PRPs are sometimes needed in between the regularly released PeopleSoft Images. These are for critical fixes that cannot wait until the next image is

• posted. These fixes must be applied to a specific

PeopleSoft Image. Use the PeopleSoft Update Manager PIA Application to create a custom change package that contains the fix from the PRP . Proof of Concept (POC) Patches These patches are created only for escalated critical

• reasons. A POC patch is posted and available only

for a single customer in a password-protected patch. The patch is applied directly to the customer environment, bypassing the PeopleSoft Image. If a POC fix is provided in a subsequent PeopleSoft Image, you are expected to apply the patch from the image as soon as it is available.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

The Future of PeopleSoft Maintenance

• Classic Patching Process
• Costly and time-consuming for customers, resulting in

delayed or infrequent patching

• Patching and Updating w ith PS 9 .2 / PT 8 .5 3
• PeopleSoft Update Manager
• New maintenance process
• Alleviates pain points by removing some manual, repetitive,

time-consuming activities

• The only patching facility for PeopleSoft 9.2 applications

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Using PeopleSoft Test Fram ew ork

Bruce Driver

Chief Technology Architect

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Using PeopleSoft Test Fram ew ork

• What is the PeopleSoft Test Framework (PTF)?
• How does it shorten your upgrade?
• BTRG has test scripts!

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

W hat is PeopleSoft Test Fram ew ork ( PTF) ?

• An integrated and autom ated PeopleSoft

application testing tool

• Integrated with PeopleTools
• Automates PeopleSoft functional testing
• Execute more tests with greater accuracy during shorter time

window

• Replicates the actions of a single user

executing functional tests against a PeopleSoft brow ser-based application

• Record and Playback automation of manual test procedures

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

W hat is PeopleSoft Test Fram ew ork ( PTF) ?

• Test Assets
• Tests and test cases – stored in database as

Application Designer objects

• PeopleTools–managed objects – can be

managed along with other PeopleTools objects through PeopleSoft Lifecycle Management

• Can be compared and copied between databases

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

W hat is PeopleSoft Test Fram ew ork ( PTF) ?

• Features not available in other com m ercially -

available Record-and-Playback autom ation tools

• Ability to validate recorded objects against PeopleSoft object metadata

definitions

• Features to help manipulate data within PeopleSoft’s rowset-oriented

data structure

• Functionality to automate numerous PeopleSoft-specific functions,

such as running processes through Process Scheduler

• Built-in commands to interface with other PeopleSoft tools, such as

Data Mover and PeopleSoft Query

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

W hat is PeopleSoft Test Fram ew ork ( PTF) ?

• Under-utilized testing tool that is built into

PeopleTools

• First introduced in PeopleTools 8.51
• Significantly enhanced in PeopleTools 8.53

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PTF Term inology

Term Definition

Test

The primary type of test asset in PTF . Tests contain steps that replicate the action of a tester executing a functional test against the PeopleSoft application.

Test Case

A set of data associated with a test corresponding to the values entered or verified in the application. For example, if a hire test hires three similar employees into the PeopleSoft system, a user might elect to record one test and to configure that test to call three test cases, one for each employee hired. A test can have multiple test cases associated with it.

Test Asset

An object used in PTF to automate a functional test. PTF test assets are saved in the application database and can be retrieved at any time to help automate tests. The five types of test assets are:

• Execution Options
• Libraries
• Logs
• Tests
• Test Cases

Log

An object that saves the experience of a single test execution

• event. Logs report the success or failure of the test execution

and include messages and screen shots to indicate where errors

• ccurred.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PTF Term inology

Term Definition

Library

Similar to a test, a library contains one or more steps that together automate some discrete amount of test functionality. Unlike a test, a library is never executed by itself. Rather, libraries are meant to be called (sometimes repetitively) by tests.

Execution Options

A list of application environments available to the tester. Execution options store application environment information such as URL, user ID, password, and Process Scheduler server, and information needed to run DataMover. PTF supplies this information to the test by default when a test does not explicitly specify such information.

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

How Does I t Shorten Your Upgrade?

• PeopleSoft Upgrade Testing
• Execute more tests with greater accuracy during shorter

time window

• After upgrade execute PTF tests to test expected

behavior

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

BTRG’s Test Scripts

• BTRG and PeopleSoft Upgrade Testing
• Twenty years of performing PeopleSoft upgrades
• Compiled many test scripts across a broad range of

PeopleSoft application modules/ functionality

• BTRG Test Scripts and PeopleSoft Testing Framework

can greatly expedite your PeopleSoft Upgrade testing

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrades and Archiving w ith I BM Optim

Bruce Driver

Chief Technology Architect

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrades and Archiving

• Business Drivers
• Archiving Strategy & Requirements
• IBM Optim, Archiving, & PeopleSoft Upgrades
• Summary

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Business Drivers

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrades and Archiving

• PeopleSoft commonly has significant data

volumes

• Mature Implementations or large data conversion
• Some recent BTRG customers DB size:
• 500 GB - 3 TB
• Upgrades include Table Alters and Data

Conversion

• Increase project complexity, delay go-live, major data

issues

• Delivered PS Upgrade process can take days
• Major culprits are Alter and Data Conversion tasks
• Data is unique & delivered process often struggles
• Tuning is one of the major cost centers during upgrades

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Common Drivers of Data Growth

• Organizational growth
• Data retention compliance
• Too much of everything
• Keeping data “always available”
• Data multiplier effect
• Full copy of production anyone?
• No surprises here, there is often a TON of data in

PeopleSoft

• Big offenders: PC, PY, GL, AR, IN, AP
• Not helping: BI, AP, PO, TL, CA, SA, HR

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrade Risks

 Go-Live Upgrade Window

• Overrun Go-Live Upgrade Window timeframe

 Miss Go-Live Date  Slow Performance

• Upgrade
• Live Production System

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Archiving Strategy & Requirem ents

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

What is meant by Archiving?

 Segregate historical enterprise application data by age, status, event or other criteria  Copy historical records to a secure archive  Delete transaction details from production system  Retain access to information for query, reporting, customer service, audit and discovery requests

Current

Production

Historical Archive

Archive

Historical Data Reference Data

MOVING DATA . . . NOT LOSING DATA

(Unless desired)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Archiving for PeopleSoft Upgrades

 Move cold legacy data to secure archive  Delete transaction details from legacy system  Convert current/ warm data to new/ upgrade application  Retain access to information for query, reporting, customer service, audit and discovery requests or move data to new system/ version at different time

Current

Legacy System

Historical Archive

Archive

Historical Data Reference Data Current

New System Can be linked

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

W hat this m eans for I m plem entations

 Easier, faster Upgrade  Fewer data related issues  Shorter go-live window  Better performance  Better user experience

• Maximize Investment
• Improve Performance
• Reduce Costs

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Data Archive Strategy: 4 Key Requirements

1

Application Intelligent

• PeopleSoft Enterprise
• Oracle EBS
• JDE
• Siebel, etc.

2

Take the right data

• ut
• Complete Business Object
• Apply Functional Condition Checks
• Accommodate Unique Business

Requirements

3

Store data where you want

• Support & automate data retention

policies as per ILM business requirements

• Multiple formats – DBMS, File

4

Access archived data when & how you want

• Native application access
• Application independent access

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

I BM Optim , Archiving & PeopleSoft Upgrades

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Functional Archive Policies: Financials

Application Retention (Years) Archiving Recovery / Access Requirements Lead Time Type of Data to Archive GL 3 Yearly Audit; Trend analysis Y Ledgers, Journals, fully posted AP 3 Yearly Audit; Trend analysis Y Vouchers, Payments, fully paid and posted AR 3 Yearly Audit; Trend analysis Y Invoices, items Billing 3 Yearly Audit; Trend analysis Y Invoices Billing Interface 1 Quarterly Troubleshooting Y Billing input AM 3 Yearly Audit; Trend analysis Y Retired assets AM Interface 1 Quarterly Troubleshooting Y Asset input, GL interface Payroll 2 Yearly Audit Y Paycheck processing data and balances

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Where Does Archiving Fit?

 Archive Before Upgrade

• Reduces amount of data to convert during production

cutover

• Reduces downtime during upgrade

 Archive While Upgrade

• Combines common technical and functional tasks to

save overall elapsed time

• Technical Tasks: Validate individual steps (such as moving

query tables forward), validating new technical environment, performance testing

• Functional/ Business Tasks: Reconciling “before” & “after”

results, regression testing on key business processes (such as payroll processing or financial close)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Archive Before Upgrade

Application Older Version Upgraded Version

Archives

Universal Access to Application Data

ODBC / JDBC XML Report Writer Application

Upgrade Project

Application Current Data

Archives

Current Data Application Data

Archive

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Archive While Upgrade

Application Older Version Upgraded Version Universal Access to Application Data

ODBC / JDBC XML Report Writer Application

Upgrade Project

Application Current Data

Archives

Application Data

Archive Archive Planning

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

IBM Optim vs. PS Data Archive Manager

99 Confidential Information

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft Upgrades and Archiving

 IBM Optim, Archiving, & PeopleSoft Upgrades

• Data Archiving
• Reduce DB footprint = Reduced costs
• Less data = More efficient upgrade
• Integrated with PeopleSoft
• Retain access to archived data

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

PeopleSoft and Database Security w ith I nfoSphere Guardium

Bruce Driver

Chief Technology Architect

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Database I nfrastructure Protection

• "Although much angst and security funding is given to offline data, mobile

devices, and end-user systems, these assets are simply not a major point

• f compromise ...“
• Verizon Business Data Breach Investigations Report 2009, 2010

% of Compromised Records

Database servers are the prim ary source of breached data

2009 2010 75% 92%

Database Servers Laptops & Backup Tapes Desktop Computers Other

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Database Security – W hy?

• Database servers contain your m ost

valuable inform ation

• Financial records
• Credit card and other account records (PCI)
• Personally Identifiable Information (PII)
• Patient records
• Customer data
• High volum es of data
• Structured - easy to access and interpret

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Perim eter Defenses Are Not Sufficient

• “I n an offense-dom inant environm ent, a fortress m entality w ill not

w ork. … [ w e] cannot retreat behind a Maginot Line of firew alls, or it w ill risk being overrun.”

• William J. Lynn III, U.S. Deputy Defense Secretary, Foreign Affairs Magazine

Outsourcing Web-Facing Apps Employee Self-Service, Partners & Suppliers Insiders

(DBAs, developers,

• utsourcers, etc.)

Stolen Credentials (Zeus, etc.)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

I nternal Database Security Threats

• “Organizations overlook the most imminent threat to their

databases: authorized users.”

• (Dark Reading, http: / / www.darkreading.com/ database_security/ security/ app-

security/ showArticle.jhtml?articleID= 220300753)

• “Most organizations (62% ) cannot prevent super users from

reading or tampering with sensitive information … most are unable to even detect such incidents …

• nly 1 out of 4

believe their data assets are securely configured”

• (Independent Oracle User Group,

http: / / www.ioug.org/ BestPracticesSolutions/ GSADownload/ .../ Default.aspx?...

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Breaches Not Quickly Discovered

• "Attackers know the value of databases too. For a three-year period

beginning in 2005, a hacker named Albert Gonzalez and a small group of his accomplices broke into the online databases of multiple companies, including:

• TJ Maxx, Heartland Payment Systems, Hannaford Brothers, 7-Eleven,

Dave & Buster’s, DSW, Office Max, Sports Authority, Forever 21, Barnes & Noble, Boston Market, BJ’s Wholesale Club

• In all, over 100 million people had their personal data, including their

credit card numbers, stolen by Mr. Gonzalez and his colleagues, and this was just the work of one single, small hacker group.“

• Web Application Security: A Beginner's Guide, Bryan Sullivan, Vincent Liu

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Breaches Not Quickly Discovered

• "Our evidence indicates that APT1 [ Advanced Persistent Threat 1] has

been stealing hundreds of terabytes of data from at least 141

• rganizations across a diverse set of industries beginning as early as
• 2006. ... we found that APT1 maintained access to the victim’s network

for an average of 356 days. The longest time period APT1 maintained access to a victim’s network was at least 1,764 days, or four years and ten months."

• “APT1: Exposing One of China's Cyber Espionage Unit”, Mandiant

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Hom e-Grow n Solutions

• Hom e-Grow n solutions are typically costly and

ineffective

• Native Database Logging
• Perl/ Unix Scripts -> Parse Logs -> Move to Central Repository ->

Create Reports -> Manual Review -> Manual Remediation, dispatch, and tracking

• Disadvantages and Shortcom ings
• Significant labor cost to review data and maintain process
• High performance impact on DBMS from native logging
• Not real-time
• Does not meet auditor requirement for Separation of Duties
• Audit trail is not secure
• Inconsistent Policies enterprise-wide

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Collector

I nfoSphere Guardium - Real Tim e Database Monitoring and Protection

• No DBMS or application changes
• Does not rely on DBMS-resident logs that

can easily be erased by attackers, rogue insiders

• 100% visibility including local DBA access
• Minimal performance impact (2-3%)
• Cross-DBMS solution
• Granular, real-time policies & auditing

– Who, what, when, how

• Automated compliance reporting,

sign-offs and escalations (financial regulations, PCI DSS, data privacy regulations, etc.)

Host-based Probes (S-TAPs)

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Addressing the Full Database Security Lifecycle

110

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Guardium - Database Activity Monitoring

• Database Activity Captured
• Session Information, SQL Commands, SQL Errors, Failed

Login Attempts, Returned Data

• Database Access
• Local access, Network access, Encrypted
• Monitoring Options
• S-TAPs, Network Taps, Span Ports

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

Guardium – Database Protection and Com pliance

• Compliance Workflow Automation
• Change Audit System (CAS)
• Entitlement Reports
• Vulnerability Assessments
• Database Discovery
• Classification

The Business & Technology Resource Group (BTRG) Proprietary & Confidential

BTRG PeopleSoft Vulnerability Assessm ent

• Augm ents Guardium Vulnerability Assessm ents
• To deliver new functionality to identify vulnerabilities specific

to PeopleSoft security and FSCM/ HCM suites

• PeopleSoft Vulnerability Assessm ent Areas
• Database Security
• PeopleSoft Security
• Segregation of Duties
• Business Process Controls
• Scans PeopleSoft tables and generates a vulnerability

assessm ent scorecard

The Business & Technology Resource Group (BTRG) Proprietary & Confidential