Many companies with PeopleSoft Enterprise wait far too long to
implement data management strategies for their application databases.
Reactive approaches are typically much more costly and difficult to
implement. The proper data management strategy in your Oracle
environment can help you with application performance, long-term
compliance, manageability, application retirement, and infrastructure
The Structured Data Manager platform is delivered with Designer,
a powerful tool for rapidly creating new archive modules that
may be unique to your PeopleSoft environment or for extending
any of the infoCorvus prebuilt modules. In either case,
Designer provides robust capabilities to accelerate your
PeopleSoft application archiving implementation and manage the
ongoing deployment. Designer project files are pre-engineered
for PeopleSoft business areas and delivered in a “locked” state
to allow customization tracking.
You can add custom tables by simply locating the table in the schema browser and dragging onto the Designer canvas. The table can automatically be labeled and documented as a custom table. In addition, you can place customization rules on standard PeopleSoft or custom tables and are enforced during the archive process. If PeopleSoft business rules are too restrictive or do not match your business process, they can be turned off. Any standard rules and/or tables that are removed from the archive process remain in the visual model and marked as deleted so customizations can be tracked and documented.
Designer allows you to use Preview to query the database directly to test sample data sets for eligible and ineligible status. This provides rules and customization checking before running archive jobs on the server. You can also customize the archive jobs to meet your requirements. In Designer, Business Flows provide a visual diagram of the job steps to be executed. Custom job steps or actions can be placed in or around the delivered Business Flows. For example, you may want an archive job to pause after the archive selection step or call on an external program.
The success of any archive project can be directly linked to
the level of archive access provided. Higher levels of
access result in higher volumes of data to archive. However,
if archived data is not accessible, typically only the oldest,
least useful data is archived, which reduces the performance
benefits of archiving. Maintaining an inaccessible archive all
but guarantees that only extremely old data (e.g., older than
10 years) can be archived. Structured Data Manager helps
balance these approaches to help you meet your unique business
needs by offering a range of access options to configure your
application archiving environment with retention and access
levels that work for you.
Data can be archived to an archive database. Figure on left shows the access options with Structured Data Manager. Data that is archived to a secondary archive database remains accessible from standard PeopleSoft reports as well as custom reports/queries. You can also take advantage of Combined Reporting to allow viewing of current and archived data from a single page or report. This leverages your investment in PeopleSoft and requires little or no user retraining.
Because archived data is available for query and report
access, you can set retention policies accordingly. Structured
Data Manager is designed to provide a flexible, configurable
interface for setting up data retention policies and
enforcement during the archival process. For example, your
company policies may mandate retaining financial (General
Ledger) data for the current and past years in the production
database. Closed (fulfilled) purchase orders only need to be
retained for the past six months.
Through strict adherence to PeopleSoft Enterprise processes and data manipulation guidelines, the infoCorvus application archiving solution certifies that relationships between data and applications remain intact. The delivered archive modules are defined with the same business and functional constraints as the PeopleSoft application. Each module undergoes rigorous testing to verify that data relocation does not affect application functionality or the end-user experience. In addition, the Structured Data Manager solution has undergone PeopleSoft Integration Validation testing and has received approval that data integrity is preserved throughout the archiving process.
In addition to providing ready-to-run archive modules,
deployment time is accelerated through the use of
configuration parameters that allow you to optimize data
management processes to match the specifics of your
application and database environment.
Configuration parameters can be easily adjusted in the management console without coding. Simply adjust the configuration parameters to meet your environment-specific situation, according to the PeopleSoft modules deployed. For example, you can define the PeopleSoft modules deployed along with
data retention policies simply by inputting or overriding parameter values.
Because it is often necessary to reuse archived data, Structured Data Manager provides built-in reload capabilities to safely relocate archived data by individual transactions or complete batch runs to the production database. Audit trail information is automatically updated to reflect the reload.
Structured Data Manager for PeopleSoft Enterprise helps you to
proactive data management strategies. We deliver a broad range of coverage with “readyto-run” archiving modules. Data distribution and growth analysis reports can help identify the right mix of archive modules for your PeopleSoft environment. Structured Data Manager key differentiators:
Begin your digital transformation journey now! Partner with us and put your business on the right track to success!