Benefits | Solution
Archiving software contains a rich array of features that fall into the following categories:-
Archive Access
- SQL access to archive – ability to use standard SQL and enterprise reporting tools to access archive data.
- Transparent application access - connects business users to archive data using their standard application interface.
- Manage Archived Versions.
- Extraction of selective data that can be purged or archived.
- Scheduler integration - ability to schedule any of the archiving activity.
Platform
- Oracle database support - native Oracle support for all major releases.
- SQL Server support - native SQL Server 2000/2005 support.
Compliance
- Audit trail - provides details of all the executed actions such as Executed Archives/Purge/Restore/Copy.
- Long-term/survivable data store (XML) - ability to archive to a neutral industry standard format for long-term archiving.
- Password encryption - any passwords required for operations are stored in an encrypted format to ensure compliance with security standards
Data Movement
- Bulk data movement (includes source table reorganization) - fast archiving of data when source tables have high eligibility of data.
- Database to database archiving - relocates data from production, without altering the format of the data.
- Database to XML archiving - relocates data from production and other data stores in open standard XML format.
Designer
- Define definition(s). Ability to use archive templates or definitions to set all the business rules to precisely define the data.
- Define Relationship(s). Ability to define new relationships or work with already defined relationships.
- Define Business Rule(s). To manage these complex relationships, the solution helps in applying business rules across various parameters.
- Import/Export archive definitions to an XML format.
- Perform Compile Archive, Run Archive, Compile Purge, and Run Purge or Resume a paused action.
- Maintain Archive history, Purge history and Restore history.