AP Data Manager (APdm) Product Summary

Why is there a need for AP Data Manager?

• Your businesses data is one of the most valuable assets that it possesses. But what happens when your hardware engine begins to downgrade in performance simply because there is too much data stored on your live environment.
• Business environments that utilise applications that store vital data such as WMS, ERP, TMS and CRM are often caught suffering from slow opening windows, extended search periods and sluggish interactive response times. Many businesses spend large amounts of money on hardware upgrades that may, in fact, be unnecessary.
• AP Data Manager brings to your business the capability to efficiently purge unwanted data as well as archive the data that is crucial to your business in an easy to install and simple to administer format.

Overview - AP Data Manager

• AP Data Manager integrates with existing technologies and enables schedule-based automation to simplify administration of database table volumes. Simply set up the Archive and Purge control tables with data retention periods by table name and AP Data Manager will do the rest.
• AP Data Manager archives active online data and moves it to offline repositories without user intervention, thus alleviating business disruptions.
• AP Data Manager is portable across your entire business topology. It is designed to allow you to run archiving and purging for any application existing on an Oracle (8i and above) or SQL Server Database (Version 7 and above). Once the AP Data Manager is installed on the host server you will be directed via a series of drop-down boxes to initiate the server and database schema for which archiving and purging rules are to be established.
• AP Data Manager uses a front-end user interface to set up the control and business rules that will be used by the server components to either archive or purge your data. The interface may be installed on any Windows platform that has a network connection to your database. The user is required to enter the names of the parent tables and their related child tables. The interface also allows you to filter the data by specifying business rules that will be applied before archiving or purging the tables. This information will be stored in the AP Data Manager control tables and can be modified at any time.
• Data is archived or purged based on a retention date. AP Data Manager allows you to derive the retention date based on several optional time periods:- number or days, number of calendar years, number of financial years, number of semesters, or simply specify a date.
• The server component has been designed to utilise the power of the native database procedures. This capability maximises performance because the code is interpreted and executed on the more powerful back-end servers where the actual RDBMS database resides. All SQL code has been optimised and tuned for extremely high throughput, minimizing system resources and allowing you to concurrently run AP Data Manager with host applications.
• AP Data Manager is also capable of scheduling the archive or purge process within the database engine. Optionally, the same scheduling procedure can be set up using the operating system of the database server.
• AP Data Manager will record the number of rows archived or purged so you may view this information after each run to verify that no errors occurred and all data volumes for each table balance against expected and actual deleted rows.