At zData Inc. our Professional Services team recognizes the complexity and risk inherent in a migration to Greenplum – Greenplum Database Migration. Regardless of the source platform, whether it is DB2, Netezza, Teradata, or Oracle Exadata, a comprehensive inspection of current state architecture components (ETL, BI, etc.) and database related objects (DDL, SQL, PL/SQL, and so on) must be performed. Layered on top of that must be all of the traditional steps to reliably execute a migration and deliver it to its business on time and within budget. These steps include concise project management, analysis, development, testing, and user acceptance. At project inception, discovery sessions with both IT staff and key business stakeholders must be performed to devise an incremental approach to deployment that is aligned with business objectives/priorities.
As part of the pre-sales process, zData Professional Services provides our customers with visibility to a comprehensive migration effort. As business priorities dictate, phases will be allocated that allow Greenplum capabilities to be deployed incrementally, reducing the risk of attempting a ‘big bang’ migration approach. Called out within each phase are major categories of activities, including project management, Discovery and Assessment, tactical conversion of target database objects to Greenplum, ETL and Reports code conversion if needed, and testing which includes unit testing, system testing, and user acceptance testing.