Case Study
The Problem
- Data warehouse containing 5 TB of production data, projected to grow to 20 TB within five years
- Requirement to retain very granular data (SAP BW PSA Data, ODS Objects and InfoCubes)
- Expected deterioration in query performance
- Maintaining multiple instances of data replication for mirroring, backup and disaster recovery had significant impact on SLA’s.
Results with SAND/DNA for SAP BI
- ROI in less than six months (immediately after production go-live) and savings of over 50% on related storage infrastructure thereafter
- About 95% compression for PSA Data, ODS Objects and InfoCubes
- Noticeable improvement in query performance
- Reduced data footprint eases replication / bandwidth issues
- Clear path for SAP BW growth
- Users can access data with no need for additional training.
About SAND Technology
SAND Technology provides Data Management Software and Best Practices for storing, accessing, and analyzing large amounts of data on-demand while lowering TCO, leveraging existing infrastructure and improving operational performance.
SAND/DNA solutions include CRM analytics, and specialized applications for government, healthcare, financial services, telecommunications, retail, transportation, and other business sectors. SAND/DNA has achieved "Certified for SAP NetWeaver" status and SAND Nearline Integration Controller has achieved "Powered by SAP NetWeaver" status.
SAND Technology has offices in the United States, Canada, the United Kingdom and Central Europe.
