Business Challenge:
One of the pain points of the customer was that there was no way of checking the correctness and integrity of the data that was stored in the database. Although there were tests to check if the functionality was working, there was a need to have a one-stop solution to compare a huge amount of data stored in multiple tables in the database against the data that was entered in the UI.
Customer Location’s:
USA
Solution Overview:
The NetServ hybrid automation framework integrated the MSSQL database into it thereby providing a failproof way of comparing data input in the UI against what is stored in the database. This exercise has been done with 170 test scenarios which increases testing throughput by 83% as compared to using a manual execution.
Our Approach:
- Our engineers broke down the problem into two streams.
- Test data input was entered into application.
- A data comparison was conducted to determine what input in the first step went against what was stored in database.
- The data comparison happened across 15-20 different tables and close to 300 database columns.
- We used the open source extent report and modified it in a way that shows the customer what was entered and what was finally stored in the database.
- Testing was extremely thorough in a way that any small differences in the data was identified and the test step had failed.
Services Delivered:
- Planning and Estimation
- Design and Scripting
- End-to-end Testing
Benefits:
The below chart illustrates the comparative difference between executing the data tests manually versus executing the same using automation scripts. It is clear that the amount of time taken to execute the tests is far less.
In addition to the time saved, the number of data points compared are exponentially greater than what could have been accomplished through a manual effort.
Business Challenge:
One of the pain points of the customer was that there was no way of checking the correctness and integrity of the data that was stored in the database. Although there were tests to check if the functionality was working, there was a need to have a one-stop solution to compare a huge amount of data stored in multiple tables in the database against the data that was entered in the UI.
Customer Location’s:
USA
Solution Overview:
The NetServ hybrid automation framework integrated the MSSQL database into it thereby providing a failproof way of comparing data input in the UI against what is stored in the database. This exercise has been done with 170 test scenarios which increases testing throughput by 83% as compared to using a manual execution.
Our Approach:
- Our engineers broke down the problem into two streams.
- Test data input was entered into application.
- A data comparison was conducted to determine what input in the first step went against what was stored in database.
- The data comparison happened across 15-20 different tables and close to 300 database columns.
- We used the open source extent report and modified it in a way that shows the customer what was entered and what was finally stored in the database.
- Testing was extremely thorough in a way that any small differences in the data was identified and the test step had failed.
Services Delivered:
- Planning and Estimation
- Design and Scripting
- End-to-end Testing
Benefits:
The below chart illustrates the comparative difference between executing the data tests manually versus executing the same using automation scripts. It is clear that the amount of time taken to execute the tests is far less.
In addition to the time saved, the number of data points compared are exponentially greater than what could have been accomplished through a manual effort.