Customer Success

Implementing a Data Archiving Strategy

The Company
Large heavy truck manufacturer

The Problem
The database was 1.2 TB and had a fast rate of growth. Performance was slowing, and system maintenance costs were escalating. The business required long-term access to detailed information and was reluctant to remove any information from the database.

The Dolphin Solution
Dolphin helped this company with their archiving strategy blueprint and implementation. Dolphin’s analysis of the database provided the necessary details for planning an efficient archiving strategy for the long term. The result was to migrate high-volume transactional data records in finance, costs accounting, profit centre accounting, profitability analysis and legal older than 24 months, and the Basis module after 90 days, from the SAP database to IBM CommonStore. This reduced the existing data volume by 50%, and long-term growth was slowed by more than 80%.

PBS archive add-ons were implemented to allow users to transparently access both online and archived date with screens identical to standard SAP transaction displays. In addition, PBS index information was used in customer-specific reports for efficient reporting on archived information.

The Results
The solution resolved the immediate performance and system administration issues as well satisfied the business need to fast, transparent access to information.