Case Study

Telecom giant saves millions with automated Teradata transformation to data modern data platform

Released 20% Teradata capacity by migrating 1000 BTEQ scripts containing 16,000 queries, 750 mLoad, TPT, and FExp scripts


Challenge

A leading wireless communications service provider was struggling to maintain Teradata costs within the projected scope of investments and wanted to move to a modern data platform. However, the key challenge was to work on the highly sensitive Teradata production environment without affecting business continuity. Their earlier in-house migration efforts were unsuccessful, as migrating Fact tables with terabytes of records was difficult.

 

Assessed entire Teradata footprint with 35 active nodes, 1300+ users, and 50+ databases with 700 TB data

 

Discovery

As the first step, transforming legacy Teradata workloads to modern platforms involved the identification and transformation of costly and resource-consuming ETL, analytical, and reporting workloads.

The wireless communications service provider was looking for a solution that would simplify and accelerate the transformation process with reliability. They wanted an automated solution to assess, identify, and recommend workloads to offload to a modern platform and free up the Teradata capacity.

 

Offloaded 10+ applications/users, 15 databases with 100+ TB data, and 1000+ tables

 

Impact

The Impetus team used the Workload Transformation (WT) toolkit to identify the top resource consumers. Resource-intensive Teradata workloads like BTEQ, mLoad, TPT, FExp, shell scripts, and associated tables were automatically identified and migrated to the modern platform, thereby offering expanded capabilities and opportunities for data exploration and analytics.

 

Workload identification

Schema replication and data migration

Logic transformation

Workload validation and execution

Analytical data moved to EDW

 

Released 20% Teradata capacity by migrating 1000 BTEQ scripts containing 16,000 queries, 750 mLoad, TPT, and FExp scripts

 

Impetus delivered an end-to-end production-ready solution with multiple utilities for:

  • Log analysis for data ingestion, processing, orchestrating, and auditing
  • Split data ingestion workflow to avoid performance bottlenecks
  • Identification of reports execution time, job run status, and highest query execution time

You may also be interested in…