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?
Just use our callback service.

We´ll reach out to you at your preferred time.

Others also read

Heidelberg, Germany and West Chester, PA – July 1, 2019 – Datavard, a recognized global leader in data transformation and solutions with a history of 20 years in SAP landscape transformation, will join SAP and to form its inaugural SAP S/4HANA Selective Data Transition Engagement Workgroup. The workgroup brings together ...
Migrations
S/4HANA
Transformation
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
Webinar On-Demand How to handle organizational changes in your SAP landscape As business grows, your system landscape also grows due to new applications, expansion to other regions, or new systems from an acquisition. This also entails changes in business requirements that can include legal changes, re-organizations, and remodeling of your entire landscape. ...
Carve-Outs and Divestitures
Data Management
Migrations
Transformation
Transformation & SLO
Speaker: Kees Van Turnhout
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
Datavard Glue
SAP and Big Data
Speaker: Tara Callaghan
Data is one of the most valuable resources for organizations. However, the vast amount of data that companies need to handle daily comes with high storage costs.  In times of perpetual data growth and new technologies, a future-oriented, data management strategy is vital. Accurate data management lowers storage costs, improves ...
BI and Analytics
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 ...
Business Warehouse
BW and BW/4HANA
Migrations
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 ...
Business Warehouse
BW and BW/4HANA
Migrations
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 ...
Business Warehouse
BW and BW/4HANA
Migrations
Speaker: Declan McNeela
Webinar on Demand Self-Service Analytics on All of Your SAP Data using Pyramid Analytics and Datavard. Discover what challenges and opportunities are facing SAP customers when it comes to analytics. Take a deep dive into the Pyramid Analytics capabilities with a product demonstration and learn how Pyramid Analytics have partnered up ...
BI and Analytics
Data Management
SAP and Big Data
Speaker: Dave Henry,
Speaker: Richard Osbourn
Ever wondered how one of the world's largest building materials companies tackles data management? What are the challenges they are facing and how do they overcome them? We talked to Michael Seifert, Enterprise Solution Architect about his experiences at HeidelbergCement in the following topics: Data management challenges facing HeidelbergCement Data ...
Archiving and Decommissioning
BI and Analytics
Business Warehouse
Cloud
Data growth and TCO
Data Management
Speaker: Barrett Conway,
Speaker: Michael Seifert
Are you finding it difficult to find the right BI tools on the market to suit your needs? Watch the kick off session of our webinar series on the Analytics Lifecycle. It will take you through a SWOT analysis of Microsoft Power BI versus SAP Analytics Cloud by looking into a ...
BI and Analytics
Speaker: Svenja Honselmann,
Speaker: Andreas Laux
Ever wondered how one of the largest suppliers of financial services in the Netherlands handles data management? What data strategies does the number one Dutch service provider in mail and logistics have? We talk to Roderik Vrijmoed, SAP BW/HANA Consultant at Gaan Consulting in the Netherlands about his experience whilst ...
Archiving and Decommissioning
BI and Analytics
Business Warehouse
BW and BW/4HANA
Cloud
Data growth and TCO
Data Management
Datavard OutBoard
Speaker: Barrett Conway,
Speaker: Roderik Vrijmoed
The first step towards a successful data management and analytics strategy is to identify data sources which gives a holistic view of all your business processes and aids you to realise insights from the generated data.  In this century of data dominance, companies store and use data from different sources – Data warehouses, ...
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
Data is the lifeblood of modern businesses, and we are generating more of it than ever. And this huge amount of data alone is not enough for generating meaningful insights for your business. Organizations are generating data from various sources – Finance, Sales, Procurement, HR, Social media and so ...
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
With over 130 years of experience, KCA Deutag is one of the world’s leading drilling and engineering contractors working onshore and offshore with a focus on safety, quality and operational performance. We talk to Euan Davidson, Group Head of IT at KCA Deutag in Aberdeen, Scotland about his experience of ...
Data Management
Speaker: Barrett Conway,
Speaker: Euan Davidson
Ever wanted to know how one of the world's leading service providers is dealing with data management, and in particular large amounts of private data? Established in 1811, today Achmea is the largest insurance provider in the Netherlands. It has brands serving around 10 million people with health, life and ...
Archiving and Decommissioning
Data Lake
Data Management
Speaker: Barrett Conway,
Speaker: Tom Hardeman
Data visualization is useful for data cleaning, exploring data structure, detecting outliers and unusual groups, identifying trends, patterns, and clusters, and presenting results in a meaningful manner. In this webinar we would like to introduce to you the SUCCESS formula of the International Business Communication Standards (IBCS), founded by ...
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
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 ...
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 ...
TELSTAR

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.