PeopleSoft PeopleTools data management and upgrade handbook / Paula Dean, Jim J. Marion.

Format:

Book

Author/Creator:

Dean, Paula, author.

Marion, Jim J., author.

Series:

Oracle Press

Language:

English

Subjects (All):

PeopleSoft software.

Physical Description:

1 online resource (1 v.)

Edition:

1st edition

Place of Publication:

New York : McGraw-Hill, [2013]

Language Note:

English

System Details:

text file

Summary:

Master Oracle’s PeopleSoft PeopleTools Data Administration and Upgrade Toolset Maximize data integrity, maintain peak application performance, and keep your PeopleSoft environment up to date. PeopleSoft PeopleTools Data Management and Upgrade Handbook explains the latest techniques and provides best practices, case studies, and programming examples. Find out how to develop and deploy data mover scripts, audit database health, apply patches, and generate project comparison reports. This Oracle Press guide offers thorough coverage of Oracle’s PeopleSoft life cycle management tools. Understand PeopleSoft PeopleTools architecture Manage metadata using PeopleSoft Application Designer Create and execute PeopleSoft Data Mover scripts Learn how to use PeopleSoft Data Archive Manager Read best practices for applying updates, patches, and fixes Implement PeopleSoft change control features Build automated functional tests Plan and execute application and platform upgrades

Contents:

Cover

Title Page

Copyright Page

About the Authors

About the Developmental Editor

About the Technical Editor

Contents

Foreword

Acknowledgments

Introduction

What's Inside

Data Management

Change Management

Upgrades

Appendixes

PeopleTools Versions and Naming Conventions

Part I: Data Management

Chapter 1: Understanding Data Management

PeopleSoft Database Structure

Database System Catalog Layer

PeopleTools Layer

Application Data Layer

Application Data Layer Management Tools

Application Designer

Data Mover

Data Archive Manager

Data and Configuration Auditing Tools

Conclusion

Chapter 2: Data Management with Application Designer

Abstract Data Modeling

Field Definitions

Record Definitions

Indexes

Views

Managing DDL Models

Data and System Audits

DDDAUDIT

SYSAUDIT and SYSAUD01

Chapter 3: Understanding PeopleSoft Data Mover

What Is Data Mover?

Installing Data Mover

Configuration Manager

Security

Writing and Running Data Mover Scripts

Your First Data Mover Script

Running Scripts at the Command Line

Bootstrap Mode

Data Mover in the Upgrade Process

Creating Your Own Upgrade Data Mover Scripts

Chapter 4: Data Archive Manager

Running a Delivered Data Archive Manager Process

Archive Objects

Archive Templates

Archive Processing

Creating Your Own Archives

Archiving User Profiles

Archiving Process Scheduler Data

Extending Delivered Archive Definitions

Part II: Change Management

Chapter 5: Change Management Overview

PeopleSoft Update Package Types

Patching Strategies

Change Management Tools

Environment Management Framework

Change Assistant

Change Impact Analyzer

Change Control

Conclusion.

Chapter 6: Environment Management Framework

The EMF Hub

Configuration

Logging

Clearing the EMF Hub Cache

Configuring a Standalone EMF Hub

EMF Agents

Running the Agent

Using the EMF Viewer

Securing EMF

Database Cloning Considerations

Chapter 7: Change Assistant

Setting Up Change Assistant

Installing Change Assistant

Configuring Change Assistant

Applying Application Updates Through Change Assistant

Using the Gateway

Manual Discovery

Patching

Dealing with Errors

Creating Custom Change Packages

Creating Data Migration Scripts

Creating the App Designer Change Project

Chapter 8: Change Impact Analyzer

Setup, Installation, and Configuration

Installing a JDBC Driver

Preprocessing

PeopleCode and File Preprocessing

Analyzing Change

Workspaces

Full Analysis

Targeted Analysis

Analyzing Change Packages

Find In

Rules

Definition Name

Definition Print Name

Java Rule

Rule

Chapter 9: Change and Version Control

PeopleTools Change Control

Locking

History

Stamping

Configuring Change Control

Enabling Change Control

Using Change Control

Change Control Reporting

Managing Multiple Databases

Change Control with Upgrades

Version Control

File-based Version Control

Specialized Version Control Products

Part III: Upgrades

Chapter 10: Upgrade Overview

Does Change Require an Upgrade?

PeopleSoft Upgrades

Compare Reports

PeopleSoft Test Framework

Upgrade Tips and Techniques

Pain Avoidance

Chapter 11: Compare Reports

Our First Compare

Creating a Sample

Running the Compare

Interpreting the Compare Report

Interpreting Upgrade Flags

Selecting the Source.

Running a Compare and Report Against a Maintenance Pack

Filtering Results

Chapter 12: PeopleSoft Test Framework

Installing PeopleSoft Test Framework

Environment Prerequisites

Install PTF

My First Test

Creating a Profile

Troubleshooting Connections

Execution Profiles

Creating a Test

Reviewing Logs

Using PTF to Verify and Reset Configurations after Upgrade

Library Tests

Automated Test Suites

Creating Shell Tests

Test Case Reporting

Chapter 13: Upgrade Tips and Techniques

Planning the Upgrade

Upgrade Types

Upgrade Timeframe

Upgrade Team

Performing the Upgrade

Creating a New Demo Database

PeopleTools Upgrade

Virtualizing the Application Upgrade

Adjusting Upgrade Flags

Reconfiguring the Application

Part IV: Appendixes

Appendix A: Manually Applying Patches and Bundles

Download the Update

Extract the Update Archive

Apply the Update

Identify Maintenance Documentation

Follow the Instructions

Change Projects

Files

Binary File Considerations

Appendix B: Data Mover Commands and Syntax

Change_Access_Password

Create_Temp_Table

Create_Trigger

Encrypt_Password

Export

Import

Rename

Replace_All

Replace_Data

Replace_View

Run

Swap_Base_Language

SET Statements

Standard SQL Commands

Nonstandard SQL Commands

Meta-SQL Statements

Index.

Notes:

Includes index.

Includes bibliographical references and index.

Description based on print version record.

ISBN:

9781283688178

1283688174

9780071787932

0071787933

OCLC:

1024271599