Data Lake Modernization Using Snowflake for German Energy Conglomerate

Client

Our client is a German multinational conglomerate corporation and the largest industrial manufacturing company in Europe

Challenges 

• Assess if Snowflake is the best-fit alternative to their existing Complex SAP HANA data lake.
• If automation could be leveraged to accelerate migration by eliminating the risk of non-adherence of exit timelines enforced on curving-out of the parent group
• Achieve near real-time SAP data insights

Solution

• Initiated a pilot migration program for one of the most complex and business-critical applications
• Created a detailed technical report to summarize the pain points, inventory analysis, migration strategy, platform gaps, and interventions.
• Setup near real-time replication of SAP ECC data using HVR
• Smart lift & shift migration of the existing SAP HANA tables, calculation views, stored procedures, and functions, by adopting an accelerated migration to Snowflake leveraging LTM PolarSled.    

Key Benefits

• 100% data match between SAP HANA & Snowflake using SmartValidate validation framework
• Four weeks end-to-end migration of profit center accounting application with Snowflake platform setup
• 70%+ automation object migration from SAP HANA to Snowflake using LTM PolarSled
• Assessed the current technology landscape and understood the current technological limitations
• Selected Snowflake as the ideal choice alternative to moving Enterprise Data Lake on Snowflake Cloud as a core data platform