Case Study

Automated Transformation of Complex Netezza Procedures to Hadoop

Automated Transformation of Complex Netezza Procedures to Hadoop

A leading US-based cable television company service provider wanted to minimize data storage and processing cost by transforming from Netezza to Hadoop-based system with minimum risk to ensure data integrity and quality. Client Overview In an effort to move from Netezza to a Hadoop-based system, the client wanted the following: Requirements • Convert Netezza procedures into Hive compatible scripts • Migrate relevant schema and data sets • Execute transformed procedures on Hive • Verify transformed procedures Impetus used the Workload Transformation Solution to automatically transforms data and procedures from Netezza to equivalent Hive compatible scripts. The following tasks provided end-to-end migration of data and transformation of procedures from Netezza to Hadoop using the I

Join for free to read