The Structured Data Manager application archiving software
platform is delivered with Designer, a powerful tool for rapidly
creating new archive
modules that may be unique to your Oracle environment or for extending any of the infoCorvus pre-built modules. In both cases, Designer
provides robust capabilities to accelerate your Oracle archiving implementation and manage the ongoing deployment.
Project files—Designer project files are pre-engineered for Oracle business areas and delivered in a “locked” state to allow customization tracking. Custom tables are added by simply locating the table in the schema browser and dragging onto the Designer canvas. New custom tables are automatically labeled and documented as a “custom” table.
Customization rules—Customization rules can be placed on standard Oracle or custom tables and are enforced during the archive process. If Oracle business rules are too restrictive or do not match your business processes, they can be turned off. Any standard rules and/or tables that are removed from the archive process remains in the visual model and marked as deleted, so customizations can be tracked and documented.
Preview—infoCorvus Designer allows you to use Preview to query the Oracle 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. The archive jobs can also be customized to meet your requirements.
Business Flow—In Designer, Business Flow provides a visual diagram of the job steps that will execute. 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 to call
an external program.
The success of any application archiving project can be
to the level of archive access provided. Higher levels of access result in higher volumes of data that the business is able to archive.
When archived data is not accessible, there is the tendency to only
allow the oldest, least useful data to be archived, which reduces the
performance benefits of archiving.
Structured Data Manager software provides a range of access options to configure your archive environment with the appropriate retentions and access levels. Data can be archived to an archive database or to files (XML, CSV, or JSON).
Data that is archived to a secondary archive database remains accessible from standard Oracle screens and reports as well as custom reports/queries.
Structured Data Manager also provides Combined Reporting to allow
viewing of current and archived data from a single screen or report.
This improves your Oracle investment and requires little or no end-user retraining. XML/CSV/JSON data also remains accessible through SQL access using enterprise reporting tools that support ODBC/JDBC.
Because archived data is available for query and report
access, retention policies can be set accordingly. Structured
Data Manager software 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 (GL) data for
the current and past years in the production database
while closed (fulfilled) Purchase Orders may only need to
be retained for the past six months. With Structured Data
Manager software and Combined Reporting maintaining access to
your data is easy
Through strict adherence to Oracle e-Business Suite processes and
data manipulation guidelines, the infoCorvus database archiving solution makes sure that relationships between data and applications remain intact. The delivered archive modules are defined with the same business and functional constraints as the Oracle application. Each module undergoes rigorous testing to make sure that data relocation does not affect application functionality or the end-user experience.
In addition to providing ready-to-run archive modules,
deployment time is accelerated through the use of
configuration parameters that allow optimization of data
management processes to the specifics of your application and
database environment. Configuration parameters are easily
adjusted in the management console without coding. You can
simply adjust configuration parameters to work for your unique
environment, according to the Oracle modules deployed. The
Oracle modules deployed are defined along with data retention
policies simply by inputting or overriding parameter
To enable your organization to manage through situations where you
need to re-transact on archived data, infoCorvus provides built-in reload capabilities to safely relocate archived data by individual transactions or complete batch runs to the production Oracle database. To verify consistency, audit trail information is automatically updated to
reflect the reload process.
infoCorvus Structured Data Manager software for Oracle
e-Business Suite helps customers seamlessly implement proactive
data management strategies. infoCorvus provides a broad range
of coverage with “ready to run” archive modules. Data
distribution and growth analysis reports can help identify the
right mix of archive modules for your Oracle environment.
Begin your digital transformation journey now! Partner with us and put your business on the right track to success!