Large Natural Gas Service Provider Migrates Years of Historical Data to Snowflake; Unlocks Deeper Analysis, Eliminates Audit Risk, & Reaps Data Storage Savings Ten-Fold
Data Transformed by the Numbers
Platforms & Systems
Overview
A large natural gas supplier’s legacy SAP Oracle system struggled to provide access to years of historical data for tax audit purposes. It was also increasingly costly to maintain.
By migrating its historical data from the outdated Oracle database into Snowflake, the new Modern Cloud Data Architecture eliminated the company’s tax audit risk, enabled a deeper level of year-over-year analysis, reduced data storage costs by 10X, and saved $6M in data access costs.
Challenges
The utilities company’s historical data were stored in an outdated SAP Oracle system which was significantly limited in capacity and unable to handle the years of historical data required for tax audit.
The legacy data environment was costly to access and fraught with obsolete hardware issues.
Solutions
Armeta successfully migrated large amounts of historical data from the company’s legacy SAP Oracle system to Snowflake, making years of data accessible and enabled the company to perform never-before-possible, advanced Year-over-Year analysis.
Armeta used its proprietary Cloud Migration Accelerator™ to move 12TB of historical data to Snowflake in a fraction of the time compared to our benchmark competitors.
Results
- 10X in data storage costs savings.
- $6M saved in data access costs.
- Tax audit data risks resolved.
- Accelerated time to value operating in Snowflake.
- Advanced and more granular analytics unlocked.
The company can perform never-before-possible, advanced year-over-year analysis with their historical data.
Featuring Armeta
The star of the show, Armeta’s proprietary tool, Cloud Migration Accelerator™ moved 12TB in just 2 weeks from SAP Oracle to Snowflake and eliminated the legacy on-premises data storage environment.