Test Data Management for SAP Testing

Software testing 101

Test Data Management for SAP Testing

Test data management (TDM) is one of the critical capabilities that helps an organization evolve automated tests to continuous tests. It’s impossible to achieve a mature Continuous Testing process unless you have an effective, tightly-integrated way to create, manage, and provision the data required for your tests. A successful TDM strategy is required for both end-to-end regression testing as well as load testing (covered later in this chapter).

However, obtaining and applying appropriate test data has always been challenging. It’s especially tricky when you’re testing complex scenarios—for example, when an account must be in a certain state before you can exercise some core functionality, or when order status changes multiple times throughout the course of a single transaction. And the more frequently you run tests (think of testing integrated into CI), the more difficult it becomes to ensure that the tests have access to the necessary range of fresh, unexpired test data.

Now, data privacy regulations like GDPR are further complicating an already-complex situation by forcing companies to abandon the most common test data management approach: using test data extracted from production environments.

SAP solutions typically require huge amounts of personalized data, not only in production but also for testing. How can you rapidly get the data you need for SAP testing—especially now that GDPR means any extracted production data must be masked? 

Test Data Management for SAP Testing [Lightning Talk]

In this lightning talk—recorded at SAP SAPPHIRE 2018— Andreas Guentherexplores TDM challenges endemic to SAP testing, and presents strategies for overcoming those challenges. 

Key Takeaways on SAP Testing Test Data Management

  • Studies have shown that 50-70% of a testing teams’ manual testing efforts are consumed by obtaining and preparing test data. To remove the greatest amount of manual efforts, look for a test data management solution that can span the entire process—from the request for test data, to the provisioning of test data, to injecting the proper test data into the test cases
  • There are a number of ways to access production data from SAP systems. 1) Access and generate test data via the modern oData protocol (SAP API) 2) Directly extract data from SAP tables via the RFC protocol 3) Invoke SAP BAPIs and function modules 4) Extract data from SAP queries 5) Extract SAP BW objects (BEx queries) 6) Using Batch Input techniques for background processing / data generation
  • If those don’t work, you can use the native interface to the underlying database. However, that does not ensure that the SAP system functions are always maintained.
  • Today’s business systems don’t stop at SAP—they include mainframes, mobile, APIs etc. It’s critical to have a test data management solution and SAP testing tools that ensure consistent test data across the complete environment.

Software Testing Tool Comparison

See Gartner’s comparison of the top software testing tools: HPE, IBM, CA Technologies, Micro Focus, Microsoft, Ranorex, SmartBear, TestPlant, Tricentis, Parasoft, Selenium, Appium, SoapUI. Read more.

SAP Testing

Try a new approach to SAP testing. Learn how the most advanced SAP test automation technology on the market lets you effortlessly detect impacts to your core end-to-end business transactions. Read more.

Test Data Management – The Underestimated Pain

Find out how Tricentis Tosca can help you to lower the maintenance effort of your test data and operating costs of your test environment while building an efficient test data management strategy. Read more.

SAP Test Automation: Key Considerations For Selecting An Automated Testing Tool

To help you choose a SAP testing tool that best suits your organization’s specific needs, this article outlines some key points to consider as you evaluate and compare tools. Read more.

SAP Testing Tools Comparison: Key Considerations

Researching SAP testing tools? Ask the following questions to compare SAP testing tools and decide which tool best suits your organization’s specific needs. Read more.

How GDPR Impacts Test Data Management

Strategies for getting the exact test data you need without putting your organization at risk of violating the GDPR. Read more.