Ask the Experts - 101
Ask the Expert Comment from our reader
Rama Krishna – Submitted on 2009/09/21 at 1:36pm
I am looking for Archiving of old data in peoplesoft. Did Peoplesoft Data Archive Manage is good or not? Which is the best way to Archive and how to use? I am very new to Archiving. Any inputs regarding the same will be appreciated.
Analysis for the Peoplesoft Data Archiving
It depends on what are you trying to achieve. Are you trying to archive old data for reducing database storage? I assume so. If then, as per my knowledge, for database archiving, our customers do not use Peoplesoft Archive Manager for many reasons because the historical data is stored inside the same Peoplesoft Database.
Assuming that you are planning to archive old data to free up space and gain more performance, there are other options. The industry leading Enterprise Data Management solutions are with IBM’s Optim or HP’s DBArchive. As per my knowledge both supports Peoplesoft Database along with Upgrades. Please check their respective product websites.
One important thing to remember is what will happen to the archived data during the application upgrade. While archiving historical data, we should make sure we will be able to upgrade them as part of the Peoplesoft upgrade. Also, it should free up storage costs to minimize the cost for the customers…