Man holding a table with the word Automation displaying

Before/After: Test data automation at an insurance company

The fully automated provision of test data not only saves time, but also simplifies processes in general and thus relieves the development department and project teams.

There are fewer delays in software testing and the continuous development of applications runs more smoothly. So what are the practical implications? Below we outline how this might play out at a large insurance company.

 
Before: semi-automatic test data provisioning
 

As is usual with many banks and insurance companies, in our example all the essential applications were developed in-house, e.g. for claims management, task management, contract management, and so on. All this is developed on z/OS with a Db2 database. The test data required for these applications was extracted from various levels by an in-house developed application and compiled semi-automatically.

This in-house application some ISPF panels with which various functions could be controlled, e.g. to transport the data for customer number x from environment A to environment B.

The ISPF application was not specifically developed for testing and it could (and should) only be used by a few experienced developers. Therefore, an e-mail interface was set up.

If a developer or tester required a test case, e.g. a certain contract with all its attached information, then he/she sent the order by e-mail to a group mailbox.

The incoming orders were processed one by one by three experts. To manage these requests, they had built themselves some Excel spreadsheets. This procedure is a rather time consuming and labor intensive approach.

 
After: Uncomplicated and automated test data provisioning
 

Together with the insurer, a web portal was created as a central entry application. Behind this are the corresponding applications of the UBS Hainer TDM Suite for automated test data procurement.

Where appropriate, the rules or patterns of the previous processes were integrated into the new solution. Test data can now be obtained via the portal that cover all essential areas, such as customers, contracts, damages, events, sales opportunities, etc.

Today, agile iterative testing is used. The structure provides for three layers: Firstly, there is the production layer. Secondly, there is an integration layer with development and test environments involving different constraints. The third layer is the development environment with five to six environments that are updated at different times. This layer defines when and how deployment takes place and according to which rules the data is handled.

The UBS Hainer TDM Suite was used to optimize the initial situation. This had two advantages:

  1. All required test case data – in production quality – can now be accessed at any time by each individual developer and tester via a central web portal.
  2.  At the same time, the entire system is gradually being converted from a mainframe to a distributed database – in this case from Db2 to Oracle.

Conclusion: Together with UBS Hainer, the insurance company gained a high degree of independence, a massive increase in speed of development turnover, and in the process took an important step towards more flexible, future-oriented technologies.

CURRENT POSTS

TDM Solution – Make or Buy?

The TOP5 ARGUMENTS why developing your own test data management solution is no longer profitable today. TDM has become a complex issue. For this reason, there are experts today who offer mature TDM solutions to the market

Read more »

Test data procurement – Three basic options

In the process of software development, tests need to be performed repeatedly. Depending on the stage of development, various test data, from individual test case data to bulk data, is required. There are three basic options for obtaining this test data: The manual creation of test data, the creation of synthetic test data and the conversion of productive data into test data

Read more »

Bulk data for system and release tests

Best-Practice: Test data procurement in the context of continuous software development (PART 3/3). Before the new or modified applications go live, system, release, load or performance tests are applied. For this purpose, no fine-grained customized test case data is needed, but production-related data in larger quantities is required. These tests are

Read more »

Customized test case data for functional, component and regression testing

Best-Practice: Test data procurement in the context of continuous software development (PART 2/3). The further development of an application usually means that different features or even bug fixes need to be implemented. Ideally, each feature gets its own environment. This environment contains only the relevant data for that particular case.

Read more »

Green light for automated
Test Data Management

Take advantage of our free initial consultation to quickly and easily determine your optimal and individual options!

Green traffic light