3M designs and executes cross-functional, automated tests for SAP applications that boost quality and accuracy for order-to-cash, sales, materials management, and finance operations.
False failures caused by bad test data and delays caused by a lack of test data significantly impact release schedules. And these are problems that is only heightened as the number of tests that need to be run increases and testing cycle times decrease. Unfortunately, there are no simple and easy answers when it comes to getting the test data needed to support end-to-end business process tests.
Enterprise landscapes are highly complex and interrelated. To get good data, referential and logical integrity must be preserved, and not all relationships are explicit. Data has to be correlated across the end-to-end test. The business process needs to have the context of the job to be done – a positive versus a negative test, standard orders versus out-of-stock orders, etc. Without correlating the data with the business process being validated, the end-to-end test will fail. Most test data management tools on the market generate data based on a single set of functional requirements and lack the ability to correlate data across a horizontal end-to-end business process test.
Worksoft offers users a simple and self-maintainable solution to generating test data for end-to-end business process tests. By using Certify, you can create automated processes that generate the data needed for tests. For example, if a sales order will consume inventory, and an inventory purchase will create it, then the inventory purchase process should be scheduled before the sales order process. Using this technique, you can construct valid end-to-end test process execution cycles that also assist in maintaining the test data environment. The data generated by the test case can then be stored as recordsets to be used for testing.
Certify recordsets are Excel-like table mechanisms (rows and columns of information) that contain data values used in data-driven testing. This data in turn is stored in the Certify SQL server central repository, removing the need to save and pass data to remote running tests. The stored recordsets enable users to take a single test scenario and drive it with variations of data, such as different user details/security roles, or different values to represent different inputs such as account details and contract ID numbers.
Allowing for test data to be created and then used by tests dynamically in the same run allows for flexibility when authoring horizontal end-to-end tests and prevents test-case sprawl. With Certify, there is never a need to create multiple versions of the same test case to accommodate different data. Worksoft Business Process Procedure (BPP) reports will document the data used while testing the application. Multiple rows of data in a recordset consumed by one test will generate a separate BPP report for each row of data in the recordset, enabling easy defect identification.
The tests with all the various data scenarios can be executed from Certify or scheduled for unattended execution via Certify Execution Manager.
Certify includes a simple-to-use data utility that automatically identifies and extracts representative SAP data so it can be directly used in Worksoft Certify. The utility maintains the most accurate business data by performing managed data updates. Simply extract relevant data directly from SAP to support business process validation by clicking on the desired fields – you can extract one record, a hundred, or thousands. Because data is extracted from live systems, it is representative of your business and has logical and referential integrity.