Why Purge & Archive?
Preserving historical data is important, but sooner or later available disk space or system performance becomes a subject of concern. A choice has to be made between increasing the disk space or removing the data from the production database. While it is always possible to store an increasing amount of information, as more data is kept on the live system, more time is required for processing. It is important to find the balance otherwise storage space and your processor size have to be continually increased.
Why purge your data?
- Your databases are growing at an uncontrollable rate.
- System performance is affecting the efficiency of your business.
- It is expensive to upgrade hardware.
- To speed up migrations by reducing the volume of data to convert.
- To ensure agility in your disaster recovery plan.
Facts to consider
Legal requirements usually determine how long you must keep your data records accessible. In addition, contractual agreements with your customers, or your internal management rules e.g. credit control, can also be determining factors. Even if you are not required to keep the data in the production database, it is necessary to find a compromise between reducing the size of the production database and the ease and speed of access to archived data.
- Legal constraints can be applicable across the board or specific to certain industries within a country.
- Contractual constraints are generally tied in to either contracted or verbally agreed service agreements with your customers.
- The integrity of your financial data and the ease of auditing your accounts.
The gains from purging and archiving aren’t just limited to reducing the costs of buying disks, but can be extended to the overall response times of the system, the speed of saving and restoring, reducing down-time, reducing time spent on analyzing errors in the database, reducing time required for week, month and year-end closure together with time for consolidating the information.
The overall reduction of the size of the production database allows a greater flexibility when choosing backup tools, a reduction in their cost and, at the same time, making the database easier to use.
Why Choose ARCTOOLS?
- Developed with the ERP Vendor
ARCTOOLS was developed in collaboration with JD Edwards and extensively tested at several JD Edwards sites.
- Compatible with both JD Edwards World and EnterpriseOne
The set up for ARCTOOLS takes into account the differences between World and EnterpriseOne, for example in Accounts Receivable.
- Compatible with the following platforms:
- Windows → Oracle
- Windows → SQL/Server
- Unix → Oracle
- IBM iSeries → DB2
- Tried and tested
There are now over 300 JD Edwards customers using ARCTOOLS. The broad and varied customer base gives the assurance that the rules defined in the JD Edwards module are tried and tested.
- Easy to use
ARCTOOLS can be installed in just a few hours and configured to suit your JD Edwards database in a few days.
ARCTOOLS provides a proven and efficient purging ‘engine’. An intelligent ‘front end’ allows ARCTOOLS to be set up without the user needing in-depth JD Edwards technical knowledge.
- Choice of purge parameters
ARCTOOLS allows the user to select the records they wish to purge. The software allows the user to choose how the purges are managed, either by carrying out purges in one run while users are on the system or by breaking the purge into multiple smaller purges. This effectively reduces the resource impact of the purge on the system.
- Run purges over other databases
ARCTOOLS can be used to purge any database whether it is JD Edwards or another ERP system. Additional custom files can easily be added to the existing JD Edwards purge rules.
- Restore purged data
In the unlikely event that the archived data needs to be put back into production, a reverse purge can be run.