The amount of data being produced is growing exponentially. As data ages, it loses its value but its cost and risk rise over time. Data storage and tracking can be costly and complicated without the right tools. In response, companies are turning to Information Lifecycle Governance and Data Archiving. Good archiving strategies are mainly about maintaining control of your data —knowing exactly what data you have, where you have it and keeping it in the right place, at the right time. Data archiving is becoming a critical business process but you ask which data archiving solution is right for you? Often we are asked to compare IBM InfoSphere OPTIM™ (Optim) and the PeopleSoft Data Archive Manager (DAM). How could two similar tools be so different.
InfoSphere Optim Archive is a market leading solution for data archiving. PeopleSoft’s Data Archive Manager is a “tool” to be used by developers to aid in archiving of select tables. Both solutions are PeopleSoft certified. PeopleSoft DAM requires customers to manually create each history table that will be used for archiving. Optim’s Metadata Driven Solutions provides the ability to build the tables in an automated fashion. OPTIM™’s delivered metadata provides all of the necessary tables and parent/child relationship structures necessary to successfully archive, without having to manually create each history table and its corresponding children.
With OPTIM™, you also receive instant access to data via” Transparent Data Access layer” while DAM offers no delivered access to the archived or history data.
Once the data is archived what can I do with it?
A key differentiation is the ability to save to an archive database. Optim has the ability to archive data to a separate on-line database while Data Archive Manager must archive within same database as the production system resulting in no saving of disk space within the application. In addition, Optim offers the ability to save to the file system, tape or other storage solution. PeopleSoft provides no additional storage options.
Optim comes with delivered templates that allow for rapid deployment of archive, delete and restore processes. These templates help ensure that referential integrity is built-In to the process Optim’s delivered metadata provides all of the necessary tables structures necessary to successfully archive, preventing end user corruption to the database and ensuring referential integrity throughout each delivered module. PeopleSoft fails to manually identify all of the table relationships between and within modules which if not managed properly can cause corruption to the production database or render the archive useless.
Archiving of Data is the backbone of a good Information Governance strategy. If your goal is to align data growth management principles with your business objectives to reduce costs, improve performance, and minimize risk, Optim is a big step towards achieving that goal.
When it comes to maintaining value from an archiving solution sometimes you end up with a real apples to oranges comparison.