The increased size
and unmanaged growth of data
in production databases can create a range of issues, from
slowing down your responsiveness to increasing costs. With
infoCorvus® Structured Data Manager software for Oracle
e-Business Suite, you can manage your production and related
non-production databases that support the Oracle e-Business
Suite environment to make sure that your business can remain
responsive while keeping costs under control and meeting data
retention and compliance requirements.
A common scenario, many
organizations that use Oracle
e-Business Suite wait too long to implement archiving and data
management strategies for their application databases. Taking
this sort of reactive approach can be much more costly and
difficult to implement after the business begins to experience
issues. With the right data management strategy in your Oracle
environment, you gain benefits in a range of areas, including
application performance, long-term compliance, manageability,
and infrastructure costs.
Structured Data Manager software for Oracle e-Business Suite
is delivered with complete, ready-to-run archive modules
corresponding to the major Oracle business applications.
Structured Data Manager software ready-to-run modules address
the major business areas in the Oracle e-Business Suite
including, but not limited to, human resource management,
financials, manufacturing, supply chain management, sub-ledger
accounting, and CRM.
Structured Data Manager
provides a complete data
management platform for databases supporting PeopleSoft
Enterprise environments with design-time and a run-time
environment, each optimized for their distinct functions.
Designer provides a visual modeling environment to rapidly
define and customize table relationships and refine business
rules for data eligibility
The run-time
environment consists of data
movement engine and job control environments with support for
Linux and Windows operating environments. The database server
can run on a separate platform. The server run-time
environment also provides native database archiving
integration and is highly scalable to meet demanding high
volume Oracle environments.
With Structured Data
Manager software, you have the
flexibility to move data from database to database, or
database to files (in XML, CSV, or JSON format), or both in
sequence depending on your data-aging strategy, retention
policies, and long-term compliance requirements.
The platform also
enables rapid installation
and configuration to streamline testing, data movement, and
archive access capabilities. The management console gives you
one place to configure and tune the environment settings for
performance and scalability, without coding.
Additional
platform capabilities include
automated restart/recovery, pause/failure consistency, job
monitoring, job launching, and repository logging for audit
trail purposes.
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
directly linked
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
values.
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.
One of the key
challenges of archiving
application data is understanding the nature of the data
itself. Data may be “stuck” in the system even though it is
old enough and appears eligible for database archiving.
Complex inter-relationships in application data can make it
difficult to discover root causes. To address this issue,
infoCorvus provides Eligibility Analytics which includes a
robust framework to discover eligible and ineligible business
transactions as well as any inter-related transactions,
sometimes known as chains.
Eligibility
Analytics reporting shows
transaction details that allow business users to respond from
within the PeopleSoft application and update transaction
statuses accordingly. These are invaluable capabilities for
data cleanup efforts and to drive up the archival eligibility
“yield” for application transactions.
infoCorvus also provides Oracle patch and upgrade support for database-to-database archiving deployments. In rare cases, Oracle patches can alter tables that are managed by archive processes. Structured Data Manager software has built-in mechanisms to detect schema changes and synchronize the production and archive schemas. infoCorvus also provides upgrade support as Oracle introduces major versions of Oracle e-Business Suite. infoCorvus provides database archiving tools and services to migrate archive data to the next version of Oracle e-Business Suite. This enables you to leverage your current Oracle release for both production and archive access and reduces the cost of managing legacy Oracle.
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.
Combined access to archive and current data in a single
report/
query
Integration with Oracle e-Business Suite security using
specialized archive responsibilities
Transparency layer generation and management
Ability to archive while users are on the system
Reload of data back to production tables as required
Begin your digital transformation journey now! Partner with us and put your business on the right track to success!