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

Reducing the footprint of BW on HANA systems When running a SAP Business Warehouse, one of the first-choices for integrating SAP with Big Data is NLS (Nearline Storage). NLS is a way to move data out of the primary database and store it in a more cost efficient, but slower ...
Archiving and Decommissioning
Business Warehouse
Cloud
Data Management
Datavard OutBoard
Goetz Lessmann
Goetz Lessmann
Data growth remains one of the top challenges of SAP systems administrators. Our experience in working with various SAP environments shows that even up to 40% of your system can be freed up by archiving or deleting temporary data. For the best results, follow our 5 Principles of Lean ...
Avatar
Jan Meszaros
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
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
With Mobile BI apps, data can be accessed at any time through your mobile device or tablet. The Webinar covers topics like - Preparation of Mobile optimized Reports and Dashboards, Best Practices and tips to build Mobile Dashboards, Walkthrough/Demo of the Apps and Limitations of the App.
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
Session 6: Partner talk with Nikhil Kothari, Global Technology Partnerships, Google Cloud, Google Alexa Milewski, Strategic Partner Manager of the Americas at Datavard, and Gregor Stoeckler speak to Nikhil Kothari, responsible for global technology partnerships, Google cloud at Google. They cover the current status and how data analytics have changed, ...
Speaker: Alexa Milewski,
Speaker: Nikhil Kothari
Session 5: How to approach a BW/4HANA migration successfully What’s stopping you from starting your transformation today? Jan Meszaros demonstrates what Datavard Fitnesstest can now do with the newly patented Heatmap in preparation for a migration to BW/4, as well as in other transformation scenarios. WATCH THE INTERVIEW NOW Your Speakers Others also ...
Session 4: Partner talk with Daniel Schenzer, Microsoft Petra Pirron welcomes Daniel Schenzer, Cloud Solution Architect from Microsoft. They will talk about new and old data problems, the importance of scalability and the advantages of the cloud vs. on premise. They will also take a look at options to integrate ...
Speaker: Daniel Schenzer
Session 3: Customer use cases – the importance of data detox regardless of whether you stay or you go First hand insights into what Achmea is planning in regards of preparing their Data Warehouse for the future. Learn why cleaning up your system is so important, regardless of your strategy ...
Speaker: Roderik Vrijmoed,
Speaker: Tom Hardeman
Session 2: Why SAP BW/4 and not something else – suggestions, customer examples & best practices Tara Callaghan talks to SAP's Global Vice President SAP Data Warehouse Product Management & Strategy, Mohamed Abdel Hadi about why SAP BW/4HANA is the platform of choice for your future data warehouse. WATCH THE INTERVIEW ...
Speaker: Tara Callaghan
Session 1: Data Warehouse Transformation – a 360° view from strategy to execution Gregor Stoeckler and Swisscom's Tjarko von Lehsten discuss what role SAP plays in the data warehouse stack. How important is cloud? And how exactly does Hybrid work? We look at why building a solid data foundation and ...
Speaker: Tjarko von Lehsten
As part of 'Collaboration', we deep dive into various ways of how you can share Reports and collaborate within your team, using the two Analytic Tools - SAP Analytics Cloud and Microsoft Power BI. The Webinar includes the following topics: • Comments feature, Portals • Sharing, Publishing and Collaboration of Reports • Bookmarks
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
Geo Maps have enabled better visual data analysis by providing an instant answer to the “Where” in your data. Helps to quickly see patterns or trends in your Geographical data and can help in many use cases like store capacity forecast and population density analysis. Business Analysts see a growing ...
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
Today, with the advent of BI technologies, dictated by data-driven culture in the companies, businesses can identify insights for immediate decisions. The ability to work faster and stay agile, gives organizations a competitive edge, they did not have before. This is possible with the effective data visualizations and analysis ...
BI and Analytics
SAP and Big Data
Speaker: Svenja Honselmann,
Speaker: Nishtha Matta
How to systematically - and securely - integrate all your data in your SAP universe with Pyramid and Datavard Glue July 28th | 4:00 pm CEST | 3:00 p.m. BST | 10:00 a.m. MDT Effective analysis requires data from multiple systems. But is it truly possible to consolidate an SAP-based infrastructure ...
BI and Analytics
Datavard Glue
SAP and Big Data
Speaker: Dave Henry,
Speaker: Richard Osbourn,
Speaker: Tara Callaghan
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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.