UK Oracle User Group

Book review - PeopleSoft PeopleTools Data Management and Upgrade Handbook

Peoplesoft People Tools Data Management and Upgrade Handbook

18 September 2013

UKOUG members, Daron Wild of University of Cambridge, Daniel Boxhall of Steria and Kathiravan Udayakumar of Cognizant Technology Solutions review this handbook on behalf of other UKOUG members

Each year McGraw Hill offer our members free books in return for an honest review of the content.

One of the books available to our members for review this year was PeopleSoft PeopleTools Data Management and Upgrade Handbook by Paula Dean and Jim J. Marion.

Read our members' reviews of this book below to decide whether or not it will be worth your investment in this title.

Daron Wild of University of Cambridge gave the book 4 out of 5 stars

Having completed a couple of Maintenance Pack upgrades and monthly migrations of our developer changes into production, I have often thought - surely there must a be a better way of doing this!
So I was very interested in seeing this book become available.

In summary for me, I realise I am not making full use of all the tools that Peoplesoft provide.

This book is a mixture of items relating to the DBA side of things, some things for the Developer, and some beginner basics.

Chapters 2 and 3 I would say are the basics ( building records, fields, indexes. Using Data Mover Scripts )

Chapter 4 is about Archiving data, which is new to me, so I found that interesting to read.

Chapter 6 is for the DBA really, for setting up the Environment Management framework. Went a bit over my head.

Chapter 7 is for the Developer - Using the Change Assistant. For some reason, we do our migrations manually. Having read this chapter I want to explore using this tool more.

Chapter 8 is the Change Impact Analyzer. I had tried installing and running this a year or so ago, but couldn't get it to work. Not even Oracle support team could help. Having read this chapter, I think I can see where my problem was. I have not tried it yet, but the notes here look pretty good.

Chapter 9 is back to basics. It covers locking objects. Same with Chapter 11, this time talking about the Compare reports

Chapter 12 covers testing the changes made, using the Test Framework tool. Again, not a tool I have used. We have to provide unit test reports of our developer changes prior to handing over to the testing team. This may be an alternative method to reporting the changes - there seem to be comprehensive notes here to get started.

Chapters 1, 5, 10 ,13 and Appendix A do not hold any content worth mentioning.
Appendix B does have a full list of Data Mover commands, but I'm sure I can find the same list in the Oracle Peoplebooks.

It is a pretty good book. But for the number of pages, it is currently very expensive. (Nearly £50 at the time of writing.)

Daniel Boxhall of Steria gave the book 4 out of 5 stars

I was very pleased with this book after I read it. It is an excellent go-to reference book for anyone who is tasked with PeopleSoft implementations and upgrades. You do not necessarily need to go through the book in order; you can easily jump to the chapters that are of interest.

It covers all the important areas at a fairly high level without presenting too much detail.

It's well laid out, easy to search and the examples are clear and concise. The authors also offer their recommendations and best practices along the way.

Kathiravan Udayakumar of Cognizant Technology Solutions

This is a well written book for PeopleSoft Administrators or Developers in role of Data Management for PeopleSoft Applications. It covers from very basic tool such as Data Mover to advanced EMF (Environment Management Framework).

I'd like to highlight some of key chapters that might benefit the readers 

Data Management

Chapter 3: Understanding PeopleSoft Data Mover: This chapter covers the key data management activities performed in PeopleSoft Application. Right from copy the data from one environment to other and advanced Bootstrap mode.

Chapter 4: Data Archive Manager: An Extensive chapter on Data Archive techniques available in PeopleSoft. It covers the DAM Architecture, DAM Administration and explains the key steps in creating custom Archival packages.

Change Management

Chapter 5 - 9: Key Change Management Activities and Tools are covered from Chapter 5 to 9. Change Assistant, Change Analyser, EMF and Change Control methods are explained in detailed with practical scenarios.


Chapter 10 - 13: This section of the book will be quite useful for all PeopleSoft Administrators in executing PeopleSoft Upgrades. Essential Tools such as Upgrade Assistant, Compare Reports, PeopleSoft Test Framework Setup are explained in detail in this section. Book also provide some key upgrade tips and techniques that would come handy in executing PeopleSoft Upgrade. 

Data Mover commands added to the Appendix of this book will be good and quick reference for DM Script Developers and PeopleSoft Administrator   

"In-short, it is a must have handbook in PeopleSoft Administrator's bookshelf"


To see other reviews of this Oracle title on Amazon, please go here

If you're a UKOUG member and would like to review Oracle books on behalf of other UKOUG members, then keep your eye on this page of our website for future available book review opportunities. We'd like to thank McGraw Hill for giving our members the opportunity to do this and a huge thanks also goes to Daron and Daniel for taking the time to review the content of this book. We hope you'll find their insights helpful.

We'd love to get your feedback on this; you'll need a UKOUG login to provide it, so if you don't have one, please click on 'create a web profile' first.