Thinking About Cutting the Cord on Netezza and Moving to the Cloud? It’s as Easy as Three Steps
Now more than ever, Netezza customers are exploring migration options to the cloud. Since June 2019, when IBM discontinued support for a variety of Netezza versions, the once “premium state-of-the-art’” data appliance became no longer critical for large business databases.
However, Teradata, once pioneers in the Relational Database Management System (RDBMS) space, is now deemed as legacy. Organizations with ambitions of moving to cloud-native environments for data warehouse and advanced analytic capabilities are shackled to the legacy Teradata world, including high licensing costs, inability to perform advanced analytics, and their complex library of functions and commands. These include BTEQ, FastLoad, MultiLoad, TPT, and various others. Cloud-native vendors do not have support for these functions, which simply put, block organization’s cloud migration ambitions.
Our SHIFT™ Migration Suite was developed with Netezza in mind, and is the perfect solution to address customer’s end-to-end challenges when seeking a migration path to the cloud. With the SHIFT™ Migration Suite, we’ve helped customers accelerate their migrations by 60% versus traditional manual migration methods.
How do we do it? In three core steps.
1. Automating Planning & Assessment Activities
In the legacy Netezza world, when businesses look to consume data for analytics or reporting, they are dependent on a number of pre-processing steps. This could include complex mappings or transformations just to create a dataset in a format their reporting application requires. This pre-processing usually amounts to around 80% of customer’s time when preparing a report or dashboard. When planning for migration, the core issue is further pronounced – no one knows what’s happening inside of Netezza, or which workloads to prioritize for migration.With SHIFT™ CRAWLER, and SHIFT™ ANALYZER, planning and assessment can be simplified and accelerated, to provides answers to questions like, “how long will the migration effort take? And where should I start?
- SHIFT™ CRAWLER can identify the workloads within the Netezza environment that are migration candidates, including the lineage and data dependencies, in order to define the most appropriate migration path. SHIFT™ CRAWLER will also provide a lineage view for the data pipelines feeding Netezza, to develop the migration plan for repointing those pipelines to the cloud target.
- SHIFT™ ANALYZER will scan the Netezza applications to identify the complete code inventory, complexity of objects, and "x-factors" that will require custom solutions when moving to the cloud.
2. Automating Code TranslationTranslating the code base within Netezza is the second step. Automating the code translation for all workloads identified during planning accelerates the end-to-end migration timeline and avoids manual development and refactoring efforts.
- SHIFT™ TRANSLATOR will automatically translate all Netezza SQL and Stored Procedures to the target cloud syntax, with accuracy of at least 95% out of the box. Further, our Professional Services team leverages a vast knowledge base of solutions to help address common Netezza to cloud implementation scenarios.
3. Managing and Accelerating Cut-Over
- SHIFT™ TESTER will automate key aspects of code and data validation testing when completing the migration project, in order to accelerate end-to-end testing efforts. This ensures all translated code compiles and executes with the expected results in the cloud target.
- SHIFT™ CRAWLER will identify dependencies and "consumption lineage" to downstream applications (like analytics and reporting tools) in order to define the appropriate migration approach while identifying optimization and consolidation opportunities along the way.