Telecom giant saves millions with automated Teradata transformation to 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.
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.
Impact
The Impetus team used LeapLogic 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
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…