Performance Archiving for

The Right Data Management Strategy

 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.

Ready-to-Run Modules

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.

  • Predefined relationships among most tables comprising each business transaction
  • Complete business rule definitions to determine data eligibility and status
  • Installable run-time modules that are ready to run in PeopleSoft environments
  • Project file definitions for importing into infoCorvus Designer to perform data analysis, customizations, and testing
  • 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.

    A Complete Platform

      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.

    Customization Support

    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.

    Archive Access

    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.

    Policy Compliance

    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.

    Application and Data Integrity

     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.

    The infoCorvus Advantage

    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/

    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

    Let's work together

    Begin your digital transformation journey now! Partner with us and put your business on the right track to success!