Moving to Cloud? Do you have the right data integrity testing strategy?.

Whether your strategy is to leverage public, private, hybrid or "bring the cloud to you" model for the migration of ECC/BW/BPC applications over to #SAPS/4HANA on HCP or migration of your current #OracleEBS applications to #OracleFusionCloud applications or your current HR applications to #SAPSuccessFactors - A well-thought-out data integrity, completeness validation approach is the key to successful implementation of cloud migration, on-time, on budget and to reap the benefits of the cloud migration sooner.

Qualtiy is everyones responsibiltiy. -Edwards Deming

Yes, the quality is not just QA team's responsibility. The "Cloud Migration Quality Testing & Validation Framework" shown below, covers the testing and validation activities for the end to end system landscape and outlines the responsibilities spanning across the entire project team and end-users/product owners.

The testing activities for cloud migration can be classified into the following two broad categories, they are "Application Testing" and "Data Quality, Integrity Testing, and Validation".

Application Testing

The application testing includes the functional testing, business process testing, security, upstream/downstream connectivity testing etc. For the scope of this article, I will not go into details of this type of testing. Most of the organizations are matured in this competency by harnessing tools like #HPQC, #Workday, #Selenium etc.

Data Quality, Integrity Testing and Validation

The "data quality, integrity testing and validation" is one of the most time-consuming, tedious and error-prone activity (when its done manually) of the cloud migration initiative. Based on the framework suggests, there is a need for data testing before migration and after migration for several cycles and phases of testing. Often times project team uses manual or custom developed solutions to handle this need. Leveraging data integrity and quality assurance tool is a great way to independently vet that what was migrated correctly correlates to the legacy.

A structured data testing strategy includes:

1. Business rule adherence validation of converted data
2. Reconciliation of data between legacy on-premise system to the cloud
3. Up-stream and down-stream data integration points validation
4. Parallel production validation

Our product #RightData and the services we offer are designed to help organizations improve their effectiveness and efficiency of the cloud migration initiatives, thereby reducing the cost of implementation, improve user adaption and eliminate the risk of project failures or delays due to data integrity and quality issues.