loading

Business Impact

  • Conforming reports into the new data lake

  • Setup ETL pipelines without impacting ongoing business

  • Reduced the execution time for faster results

  • Reduced cost with at scale capabilities for business growth

Customer Key Facts

  • Location : North America
  • Industry : Insurance

Problem Context 

The customer leveraged Teradata on-premise, which acts as the data service layer for downstream sales operations & analytical reporting applications to host major components of their enterprise data platform. They wanted to move to a modern Snowflake-based Cloud Data Warehouse. The client also sought to migrate the BI/ Reporting and adopt the SAP BusinessObjects BI platform to the new DWH environment while reconciling the data at various stages while in the move to ensure high data quality.

Challenges

  • 60+ DBs aggregated for Single Version of Truth
  • ~1000 ETL mappings adopted
  • ~5000 DB Objects Migrated
  • Around 200 SAP BI Reports pointed to the new Data Lake.

Technologies Used

Teradata
Snowflake
AWS
SAP ERP, BusinessObjects BI

Solution

Quantiphi enabled swift Migration of SAP, Teradata DWH, and BI reports to Snowflake without impacting ongoing business functions and reconciliation available at every step.

Results

  • Created high-performing yet highly cost-efficient Data Lake on the cloud.
  • Shifted from systems like Teradata, stopped recurring license costs, and salvaged the infrastructure.

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk