ArcTools Enterprise Manager (AEM®) is a rule-based / parameter-driven Purging/Archiving Solution, designed in such a way as to allow for maximum configuration flexibility.

It has two primary technical components:

The database component, which because of its close proximity to the database and your data, ensures effective management of large data volumes. The rules and the relationships for the JD Edwards Module are contained within a control database and the engine which interprets/transforms these rules into dynamically generated procedural SQL statements is developed in PL/SQL (for Oracle) or TSQL (for MS SQL Server).

The front-end component, which can be installed on the database server, a separate application server or simply on a client machine, was written in html/javascript/jsp/servlets based on the MVC pattern. All administration tasks for AEM® are made easy by this user friendly interface.

Features of ArcTools Enterprise Manager (AEM ®)

• The product has a built in understanding of the rules and relationships which underlie the JD.Edwards EnterpriseOne database, ensuring that data is purged in a reliable and accurate manner without compromising database integrity.
• The option of proof/test mode enables the user to validate results before performing the actual purge.
• Total control over each step in the archive/purge cycle is ensured, and the ability to rollback purged data if the need arises.
• The activation/deactivation of rules, the inclusion of bespoke tables or indeed the creation of new Purge Modules is easily managed by our product.
• AEM® has a built in scheduler which enables users to purge proactively and automate the purging process.