Test Data Managment header background image

Test data management

Test Data Management: How to Provide Test-Relevant Data

I just came across one of the most essential and useful courses I ever have ever taken: Test Data Management. Test Data Management (TDM) stores and modifies the data you need while testing, so that you can (as an example), use the TDM tool like a Buffer to provide synthetic test data. The tool itself is organized into tables with columns, where every row is an object.

The course starts within the Database: With your Test Sheet, you select the Filter in the TDM column and tick all the attributes you want to be a column. After selecting all the necessary attributes, right click the Test Sheet and select “Create Schema for TDM”. The following notification shows you which tables and columns have been created, but take care! It will also show entries which already exist.

By right clicking a folder in the Tosca Commander, you can enter the TDM section by selecting “Show TDM ObjectEditor”. In the TDM window you can select a table in the drop-down menu and see your data there. Nothing shows up? Perhaps you haven’t created it, or forgot to use the TDM Save module after inserting the data. Don’t worry if you forgot – this is one of the most common mistakes and everybody has to learn it by hard.

It is important to keep in mind the way you name objects when creating Data in the TDM tool. For example, you might name an object from a customer’s perspective and give it an individual ObjectName, like My_Customer, which is only necessary to identify this object within this TestCase. The object is now locked until you save with the TDM Save module, and the data will only be written when you execute the module.

Another example is, all our tests are done in the comfort of a lab setting where we get good signal, bandwidth and few interruptions during our testing. When we do our mobile tests for, we are not running to catch a flight, shopping at a store or playing games on the device and talking or listening to the music and trying to use the app. Most of the time these factors are ignored during testing.

We also know that power outages and other type of disruptive events can take our application down, yet we don’t test for these types of things on a regular basis.

To use data which is stored in the TDM tool, you need to select one object (which is done by the TDM Find Single Object module and can be searched by a TQL Query). If you have the data in the cache, you can access it by using this term: {TD[TDMTable.Column]}.

The rest of the training course is about Business Test Cases and Execution Lists, which are not for execution, but for displaying business relevant processes within a Test Case. The mindset of an End-to-End Test Case is provided as well.

Before starting my challenge I want you to know, that I am doing all these trainings for the first time along with you, and do not tick wrong answers just to get a “not-perfect” result.

That being said, take the course and try to beat me again! Here’s your challenge: