You are here

Solix EDMS Database Archiving

Data Needs Management
Data is the life blood of any organization, but too much data can slow application and reporting performance and tax IT resources. Experts agree that as much as 80% of data in enterprise production databases for core applications such as ERP, CRM, and corporate financials is no longer in active use and slows application performance by as much as 50%. Much of this data, however, needs to be retained for compliance and business needs such as decision support and trend analysis.

As a result, many IT organizations are experiencing explosive data growth, forcing them to spend scarce CapEx funds on expensive Tier 1 storage and larger servers, harming application performance, and blocking effective data governance and application portfolio management and retirement of obsolescent applications, which Gartner and other experts agree is a key to efficient IT operations.

The key that unlocks the data growth problem is data archiving. But archiving is not just a matter of chopping off all data before a specific date, copying it to tape and deleting it from the production database. Data divorced from its metadata and context often becomes meaningless, particularly with datasets from complex applications such as CRM and ERP systems. And data that may not be in daily use still needs to be accessible; it cannot simply be copied to tape and forgotten. It must be archived to appropriate tiers in the storage architecture, which for some data may be Tier 2 disk, and even after it moves onto inactive media it still needs to be managed to ensure it can be recovered when needed. This requires advanced database archiving solutions that enforce data archiving best practices.

Solix EDMS Database Archiving

Solix EDMS Database Archiving provides leading-edge database archiving technology including:

  • The Solix Enterprise Metadata Manager, which manages the metadata for all data types from multiple applications independent of the database platforms through an extensible metadata framework, ensuring that the context of complex ERP, CRM and other enterprise application datasets is preserved.
  • Designed-in ability to be easily configured to work with custom and home-grown applications and custom data architectures, including legacy mainframe applications.
  • Simultaneous or transparent access to archived data from native applications
  • Policy-based data archiving to support enterprise data retention and records management policies
  • Support for long term archiving to various archiving platforms which includes: Relational databases, Tape, WORM devices, File Systems, Content Repositories and Solix Secure Archive

Solix EDMS Database Archiving is designed specifically to unlock the doors to effective information lifecycle management (ILM) without fear of losing vital information. Fully integrated as part of the SOLIX EDMS Database Archiving component applies customizable business rules built on application-specific meta-data to drive database archiving.

Solix EDMS provides an out-of-the-box Application Awareness model that is available for a list of major enterprise applications, ensuring that all data is archived with full metadata to preserve the context of each piece of information. The resulting archive can be integrated with production data to be viewed and analyzed by the original or native application. Because archive is in a read-only format, it can help to meet compliance requirements for preservation of data in a guaranteed unalterable state. And archived data can be residing on lower cost storage, cutting down the storage costs and improving efficiencies around business continuity. . The Solix EDMS Application-Awareness framework can be easily extended to work with home-grown custom applications and Data Warehouse data. Solix EDMS Application Awareness is available to support:

  • Oracle E-Business Suite Archiving,
  • PeopleSoft Enterprise Applications Archiving,
  • Siebel Archiving,
  • JD Edwards Archiving,
  • BaaN Archiving.
  • Oracle Universal Banking Application
  • Oracle Transportation Management

Solix EDMS Database Archiving technology ensures that data integrity remains relationally intact, even after upgrades. The result is a highly stable production environment and streamlined performance that leads to higher productivity and a positive impact to the organization's bottom line.

List of Validated Integrations from respective vendors for the following products:

  • Oracle E-Business Suite R 12.1
  • PeopleSoft R 9.0
  • JD Edwards Enterprise One R 8.12
  • Siebel CRM 8.1
  • Hitachi's HCAP
  • EMC Centera
  • NetApp FlexClone
  • IBM DR 550

Solix EDMS Components

The Solix EDMS includes:

  • Solix EDMS Database Archiving, which enforces business policies for classifying, tiering, archiving and managing the lifecycle of structured data for pre-packaged applications such as Oracle E-Business Suite, PeopleSoft, Siebel, JD Edwards, BaaN or custom applications or data warehouses from a single console.
  • Solix EDMS Test Data Management, which manages database cloning and subsetting for automated creation of databases for testing, development,QA, and other non-production applications while reducing infrastructure costs and improving development cycles.
  • Solix EDMS Data Masking, which ensures data security and compliance by masking sensitive data in test databases using several masking algorithms and at the same time maintaining referential integrity of the data to keep the application testing process seamless.
  • Solix EDMS Application Retirement, which empowers application portfolio management by automating the process of retirement of obsolete applications while archiving vital data, thereby allowing companies to reassign expensive IT staff and shut down or recycle servers and storage systems while guaranteeing integrity of all data archived.

At the core of the Solix EDMS is the Solix Enterprise Metadata Manager, which manages the metadata for all data types from multiple applications independent of the database platforms through an extensible metadata model framework. This guarantees the relational integrity of all data managed via Solix EDMS, regardless of where it is physically or logically in the tiered system, specifically including data archived from retired applications. That ensures that data remains searchable, readable, and understandable.


  • Archiving optimizes storage to improve application performance by as much as 50% or more, helping IT to meet SLAs while decreasing total cost:
    • It trims production databases by offloading inactive datasets that are no longer in daily use.
    • It removes inactive data from production and all copies to reduce disk and tape requirements.
    • It creates a tiered data architecture based on business rules, providing a baseline for tiering data protection and disaster recovery/business continuity.
  • By reducing the size of production databases significantly it:
    • Makes tiered storage a reality,
    • Improves business agility,
    • Decreases the risk from change management including installation of new software versions and migration to new hardware,
    • Reduces the resources required for application maintenance, and,
    • Decreases times for backups and for DR, should that become necessary.
  • The Solix EDMS flexible architecture and robust feature set eases implementation:
    • Multiple options allow companies to deploy the right method for each application.
    • It provides a single tool for managing standard and custom archiving across multiple applications, reducing maintenance and overhead costs.
    • It leverages existing investments in database technology and archiving platforms.
  • Its metadata-based approach separates business logic from technical implementation:
    • As technologies change, retaining ILM policies at the metadata level eases underlying infrastructure transitions.
    • It leverages metadata for multiple projects beyond archiving, secure cloning, subsetting, data masking and application retirement.
  • It cuts the cost of storage by decreasing the amount of data on expensive Tier 1 disks significantly.
  • It meets compliance requirements by preserving data in a read-only format while supporting data visualization through standard reporting tools.
  • It mitigates risk by reducing the amount of data exposed to potential problems.
  • It improves business continuity by cutting the active data that requires backup and potential restoration by as much as 80%, decreasing backup windows significantly