A leading US-based cable television company was looking to reduce their data storage and processing costs by transforming Netezza workloads to a cloud-compatible big data platform.

They wanted to:

• Get an advanced blueprint of the target architecture through a data-driven workload assessment
• Convert Netezza procedures into Hive compatible scripts
• Migrate relevant schema and datasets
• Verify transformed procedures
• Ensure data integrity and quality
• Leverage their existing investments in line with business goals
• Ensure business continuity and risk-free migration

LeapLogic, an Impetus product for automated workload transformation transformed the client’s data and procedures from Netezza to equivalent target compatible scripts on a cloud-compatible big data platform.

Leveraging a repeatable, verifiable methodology, LeapLogic automated schema and data migration, data migration quality checks, SQL scripts and procedures transformation, and code optimization to comply with their production SLAs.

Some Highlights:

• Provided schema optimization recommendations for partitioning, clustering, and number of buckets based on the dataset
• Migrated the existing dataset onto Hive
• Successfully automated and achieved 88% logic transformation of Netezza procedures into Hive compatible scripts
• Executed transformed procedures in the Hive environment
• Auto validated the transformed procedures against Netezza results

LeapLogic enabled the cable television company to enhance programmer and quality analyst productivity by automatically transforming 88% of queries into equivalent HiveQL. Our intelligent automation technique helped the client achieve:

• Risk-free migration with zero business disruption
• 50% cost and effort savings compared to manual migration
• Reuse of existing investments
• Faster time-to-market
• Informed data-driven decision making
• Data integrity through validation and quality checks
• Optimized performance in the target environment