Data validation – a complex and costly necessity

The validation of data is an extremely important but often neglected step in the process of reorganizing SAP system landscapes. Extensive testing enables top quality releases and satisfied users. In addition, expensive bugs, unplanned downtimes or production downtimes can be avoided. In a recent survey, 83 percent of respondents said they had too few resources for testing and validation. They also complained that validation is complex and time-consuming and often delays the go-live of a project. The solution? Automated Test Validation.

A paradigm shift with Datavard Validate

With Datavard Validate, the entire process works the way it should – IT automatically validates data across the entire system and provides a consolidated view of results and potential issues to the business unit. With complete and reliable results, a go-no-go decision can be made. In this way, responsibility remains with IT (where it should be) and IT can prove the migration / change is complete and correct.

Reduce the workload and ensure data is reliable.

SAP HANA brings many significant changes for SAP systems. Migration to HANA, structural changes through HANA functions, migration to the cloud, transformation to SAP S/4HANA are just a few of them. Every change must be tested to ensure the correctness of the data. To validate the data quality, a comparison of the before and after image of the millions of data records must be made. It is actually a simple exercise, but due to the amount of data it is manually a lengthy and time-consuming exercise. And project managers have a hard time finding volunteers for it. Typically, you have two options:

  1. Data and performance validation is done manually by IT
    Because there are major constraints on what can be done in the given time and budget, only random checks are performed – less than 1% of the total scope is validated. This bears a high risk. Often errors creep into the production system which are very difficult to solve later.
  2. Data validation is carried out by the user department.
    However, some aspects of a HANA migration are purely technical and have no real “value” for the business department. Therefore the test budgets are limited.

Test automation vs. data validation

Why you need another test automation tool

Traditional test automation covers the area of functional testing: User steps are recorded as test scripts and can be automatically re-executed with different parameters and conditions.

The question Datavard Validate answers is data validation in addition to the proven method of functional testing – “Is the data correct? This requires a completely different approach to testing and test automation, as conventional methods do not answer this question. The good news is that Datavard Validate can be used to automate the data validation process very efficiently.

95% of customers who have tried Datavard Validate would never want to test manually again!

Supported scenarios

  • Transformation to SAP S/4HANA
  • Migration to HANA and BW/4HANA
  • Release change
  • Migration to the Cloud
  • Unicode upgrade
  • Structural changes during migration, both technically and from the point of view of business units (for example, merging company codes)

Key Features

  • Automated data validation in SAP systems (also cross-system and comparison to non-SAP systems, e.g. when migrating data from legacy systems)
  • Before/after data validation with storage of the results
  • Source/target system validation with storage of the results
  • Automated test creation and documentation
  • Integrated test case management
  • Integration with HP Quality Center

Key Benefits

  • Securing data quality in migration projects
  • Reduction of the data validation effort
  • Relief of the technical testers and thus more time for functional testing

Do you have any questions? Let us know and we will get in touch with you at your convenience

Please use our callback service so we can reach out to you at your preferred time

Others also read

Recent years have brought about an amazing uptick in international mergers and acquisitions, divestitures and companies going through major reorganizations or restructurings. But what often is a blessing for shareholders quickly turns into a nightmare for the SAP business applications. After all, major changes must be mirrored in the ...
Transformation & SLO
Goetz Lessmann
Goetz Lessmann
In my last blog post I presented an overview of System Landscape Optimization (SLO) and how it supports business transformation. I walked through some of opportunities and potential benefits of using SAP LT (Landscape Transformation) including flexible golive dates, conserving the integrity of SAP data, and minimizing the impact of a ...
Transformation & SLO
Goetz Lessmann
Goetz Lessmann
In this fourth installment of my blog series about SLO (System Landscape Optimization), I will describe  how to handle organizational changes using the Company Code Merge approach.  So far, I’ve discussed the use and benefits of using SLO tools and methods for carve-outs and carve-ins when companies are involved in Divestitures or Mergers ...
Transformation & SLO
Goetz Lessmann
Goetz Lessmann
Datavard US Adds Formbit Founders to Leadership Team Heidelberg, Germany – September 19, 2019 – Datavard, a recognized global leader in data transformation and solutions with a history of 20 years in SAP landscape transformation, today announced it has acquired Formbit, a leading expert in SAP-certified System Landscape Optimization (SLO) ...
SLO
Heidelberg, September 27, 2019 – Datavard yesterday received the “Employer of the Year” award at the Women in IT Awards in Berlin The Award was won for outstanding commitment to promoting gender parity. The award was presented this year for the first time in Europe The Women in IT Awards have ...
Life at Datavard
Google launches a global “Cloud Acceleration Program”. The aim is to support SAP user companies, to make their journey to the cloud a success. Heidelberg-based software company Datavard – together with selected global consulting and innovative technology providers from the SAP ecosystem – is one of the participating companies in ...
Cloud
Datavard Glue
Google Cloud Platform
Learn how Datavard Glue can open your SAP system to modern advanced analytics. Make big data informed decisions for your business strategy "Tomorrow". Understand why you need a data driven strategy Key challenges of SAP data integration Example Use Case Watch the webinar on demand right away Others als read
BI and Analytics
Big data integration
SAP and Big Data
Speaker: Tara Callaghan
Date: Wednesday, April 8th, 2020 Time: 11:00 - 11:45 CET   Data is one of the most valuable resources for organizations. High-quality data ensures that processes run smoothly and is key to developing products, better serving customers or making strategic business decisions.  The vast amount of data that companies need to ...
BI and Analytics
Big data integration
SAP and Big Data
Speaker: Barrett Conway
Microsoft's Cloud Solution Architect, Roman Broich, talks to Datavard about motivations and possibilities for moving your SAP system to the cloud. Gain greater agility and benefit from better integration of SAP with other services in the cloud. Watch the interview now and learn about: cloud benefits - this is a ...
Cloud
Speaker: Roman Broich
Many customers have made the switch to BW 7.5 on HANA and are now facing the somewhat daunting leap to BW/4HANA. This leap is not an upgrade, but a migration. In our series of espresso sessions on the subject of BitesizeBW find out how you can achieve success in 3 ...
BI and Analytics
Big data integration
Business Warehouse
BW/4HANA
Speaker: Declan McNeela
Many customers have made the switch to BW 7.5 on HANA and are now facing the somewhat daunting leap to BW/4HANA. This leap is not an upgrade, but a migration. In our series of espresso sessions on the subject of BitesizeBW find out how you can achieve success in 3 ...
BI and Analytics
Big data integration
Business Warehouse
BW/4HANA
Speaker: Declan McNeela
Many customers have made the switch to BW 7.5 on HANA and are now facing the somewhat daunting leap to BW/4HANA. This leap is not an upgrade, but a migration. In our series of espresso sessions on the subject of BitesizeBW find out how you can achieve success in 3 ...
BI and Analytics
Big data integration
Business Warehouse
BW/4HANA
Speaker: Declan McNeela
Six-week project reveals housekeeping potential The DÜRR Group is one of the world’s leading companies in the field of mechanical and systems engineering. Dürr's SAP business warehouse was slowly reaching its 1 TB limit. Due to the high capacity utilization, performance problems with queries became more and more frequent and the ...
Shell and Datavard succeeded in the direct migration between two NLS solutions Energy provider Shell runs one of the biggest BW systems in the world, used for storing and reporting on commercial and financial data. Because some data must be kept for 10 years and longer for legal reasons, Shell ...
Telstar is a company with a diverse global reach. Providing high-tech equipment and project solutions to the pharmaceutical industry and research facilities worldwide, the company’s business spans everything from design and manufacturing of process equipment to engineering, construction, consultancy and validation services. After a formal process of divestment of part ...

Datavard Blog Newsletter
Stay informed

Subscribe to our free blog newsletter and receive valuable tips, tricks, and expert knowledge about SAP transformations, SAP data management, cloud migration, TCO reduction, data lifecycle management, and more.