PEOPLESOFT DATA MANAGEMENT

This Upgrade and Data Management Rel 8.50 course will teach you to manage customizations, apply application updates and upgrade a PeopleSoft application.

  • Course Contents :
  • 1. Course Overview
    • Course Objectives
    • Course Agenda
  • 2. Technology Overview
    • Describing Data Management Tasks
    • Describing Data Management Tools
    • Describing PeopleSoft Database Tables
    • Describing Change Assistant
    • Describing Application Updates
    • Describing Application Upgrades
  • 3. Examining PeopleSoft Databases
    • Describing PeopleSoft System Components
    • Describing Structure Versus Content
    • Tracking Definition Changes
    • Describing Customizations
    • Defining Upgrade Terminology
    • Identifying a Database
  • 4. Building and Altering Tables
    • Identifying PeopleTools Tables That Affect the System Catalog
    • Configuring Data Definition Language (DDL) Parameters
    • Using the Build Process
    • Altering Tables
    • Creating Views, Indexes, and Triggers
    • Running Database Integrity Reports
  • 5. Identifying PeopleTools Tables
    • Examining PeopleTools Tables
    • Securing PeopleTools Tables
    • Running SYSAUDIT Reports
  • 6. Merging Projects
    • Documenting Changes and Customizations
    • Printing Definitions
    • Searching for Strings in PeopleCode
    • Determining How Definitions Are Related
  • 7. Using Change Control
    • Identifying Change Control Components
    • Administering Change Control Options
    • Setting Workstation Preferences
    • Locking and Unlocking Definitions
    • Copying Locked Definitions
  • 8. Using Projects to Migrate Customizations
    • Describing the Migration Process
    • Creating Upgrade Projects
    • Copying Projects to Databases
    • Validating and Reusing Projects
    • Adjusting Definitions
    • Merging Projects
    • Copying Projects To and From Files
  • 9. Using the Compare and Report Process
    • Describing the Compare Process
    • Running Compare and Report
    • Setting Upgrade Options
  • 10. Viewing and Analyzing Compare Reports
    • Viewing Compare Reports
    • Analyzing Compare Reports
    • Entering Overrides in Upgrade Projects
    • Comparing and Merging Text Definitions and Files
    • Running PeopleCode Diff/Merge
    • Comparing and Merging Pages
  • 11.Moving Data with Data Mover
    • Listing Data Mover Commands and Syntax
    • Exporting Data
    • Importing Data
    • Using Additional Set Commands
    • Encrypting Passwords with Data Mover
    • Renaming Records and Fields
    • Running Data Mover in Command Line Mode
  • 12. Creating a Change Package
    • Describing Change Packager
    • Creating a Change Project
    • Creating File Reference Definitions
    • Creating a Change Package in Application Designer
    • Updating a Change Assistant Template
    • Finalizing a Change Package
    • Testing the Change Package
  • 13. Configuring Change Assistant for Updates
    • Describing Applying Change Packages
    • Preparing the Environment
    • Setting Up the Environment Management Framework
    • Using the Environment Management Viewer
    • Setting Change Assistant Options
  • 14. Applying Change Packages
    • Applying a Change Package
    • Correcting Errors in Change Assistant Job
    • Reviewing Change Assistant Logs
  • 15. Comparing, Testing, and Deploying Updates
    • Describing Update Deployment
    • Reapplying Customizations
    • Migrating a Change Package
  • 16. Applying Application Updates
    • Listing the Change Assistant Update Steps
    • Searching for Updates
    • Downloading Change Packages
    • Applying Change Packages
    • Reapplying Change Packages
  • 17. Planning Your PeopleSoft Application Upgrade
    • Describing PeopleSoft Upgrade Types
    • Describing Application Upgrade Process
    • Gathering Upgrade Documentation
    • Identifying Upgrade Planning Tasks
    • Describing the Software Install
    • Configuring Change Assistant for Upgrades
    • Creating an Environment
    • Creating an Upgrade Job
  • 18. Preparing the Database
    • Preparing Databases for Upgrade
    • Comparing Customizations
    • Describing a Database Compare
    • Identifying Customizations
    • Preparing the Copy of Production Database
    • Preparing for the Application Upgrade
  • 19. Applying PeopleTools Changes
    • Describing PeopleTools Changes
    • Explaining the Steps in a PeopleTools Upgrade
  • 20. Running and Reviewing Compare Reports
    • Preparing for Application Changes
    • Running New Release Compare Reports
    • Reviewing New Release Compare Reports
    • Reviewing the Non Compare Project
  • 21. Applying Application Changes
    • Customizing the New Release
    • Running New Release Upgrade Copy
    • Modifying Database Structures
    • Running Data Conversion Programs
    • Finalizing the Database Structures
    • Loading Data to Complete the System Setup
  • 22. Completing Database Changes and Moving to Production
    • Reapplying Customizations
    • Setting Up Security
    • Stamping the Database
    • Testing the Database
    • Testing the Move to Production
    • Developing a Test Plan
    • Preserving Queries, Trees and Tree Structure

QUICK ENQUIRY