Daimler Trucks: Getting Business Buy-in for Data Archiving

oil&gas

Daimler Trucks, formerly Freightliner, is the largest heavy-duty truck manufacturer in North America and a leading producer of medium-duty trucks and specialized commercial vehicles. When Freightliner originally came to Dolphin several years ago, their database was 1.2 TB and had a fast rate of growth. Performance was slowing and system maintenance costs were escalating. However, the business required long-term access to detailed information; they were very reluctant to remove any information from the database. Solution Dolphin helped the company with their archiving strategy blueprint and implementation. In the workshop phase, we brought technical, functional and business users together to learn. From the business we learned about access and retention requirements as well as residency periods. We were also able to assist in getting the business buy-in for continuous archiving going forward. 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 center 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 data 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. Results The solution resolved the immediate performance and system administration issues and satisfied the business need for fast, transparent access to information.

  • 50 million financial accounting documents archived during initial go-live
  • Users take as little as 1 second to access archived information
  • Database volume was decreased by 50%
  • Reduced long-term database growth by more than 80%
  • Satisfies audit, legal, regulatory mandates
Dolphin has since implemented data archiving and multiple PBS retrieval modules in a second SAP system with similar results. They are now archiving on an on-going basis. Recently they started doing catch-up data archiving on a go backward basis to be completed before upgrading to ECC 6.0 per their company policy. Dolphin also recently added another PBS solution, PBS ContentLink. ContentLink is a lightweight content management alternative to traditional content management systems (CMS). It enables archiving to meet legal requirements and supports Information Lifecycle Management. During that project we also helped Daimler move from writing to EMC disk, which was taking two days, to a NetApp worm device that will significantly speed their catch-up data archiving process. Estimated completion for catch-up is early 2011. Download_PDF

Back to Resource Library

Daimler Trucks: Getting Business Buy-in for Data Archiving

Daimler Trucks, formerly Freightliner, is the largest heavy-duty truck manufacturer in North America and a leading producer of medium-duty trucks and specialized commercial vehicles. When Freightliner originally came to Dolphin several years ago, their database was 1.2 TB and had a fast rate of growth. Performance was slowing and system maintenance costs were escalating. However, the business required long-term access to detailed information; they were very reluctant to remove any information from the database.

Solution
Dolphin helped the company with their archiving strategy blueprint and implementation. In the workshop phase, we brought technical, functional and business users together to learn. From the business we learned about access and retention requirements as well as residency periods. We were also able to assist in getting the business buy-in for continuous archiving going forward.

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 center 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 data 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.

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

  • 50 million financial accounting documents archived during initial go-live
  • Users take as little as 1 second to access archived information
  • Database volume was decreased by 50%
  • Reduced long-term database growth by more than 80%
  • Satisfies audit, legal, regulatory mandates

Dolphin has since implemented data archiving and multiple PBS retrieval modules in a second SAP system with similar results. They are now archiving on an on-going basis. Recently they started doing catch-up data archiving on a go backward basis to be completed before upgrading to ECC 6.0 per their company policy.

Dolphin also recently added another PBS solution, PBS ContentLink. ContentLink is a lightweight content management alternative to traditional content management systems (CMS). It enables archiving to meet legal requirements and supports Information Lifecycle Management. During that project we also helped Daimler move from writing to EMC disk, which was taking two days, to a NetApp worm device that will significantly speed their catch-up data archiving process. Estimated completion for catch-up is early 2011.

Download_PDF