Dynamic Data Comparison for Automated Regression Testing

The Client

An international investment management firm

The client and its affiliates serve as investment adviser to more than 450 separate and commingled institutional accounts and more than 80 stock, bond, and money market funds.

The Challenge

The client was undergoing a project to upgrade its operational systems to a newer version. In the course of developing this new version, the vendor had split the system into two different products, resulting in two different databases.

The client was concerned about possible data integrity issues, and wanted an efficient method to validate the results of their existing Business Objects reports without having to manually verify them.

The Solution

Altek Solutions designed and developed a software package that allowed the client to perform automated regression testing. The application accurately and efficiently captured data discrepancies between the two versions of the Business Objects reports, and provided detailed supporting documentation.

The Benefits

Maximized testing throughput by enabling comparisons to run unattended 24x7x365

Reduced risk of human error probable in manually comparing data between reports

Met demanding release schedules with shortened test cycles

Software in place for future version migrations

Tools & Technologies

Business Objects SDK

Microsoft Visual Basic

ADO

Sybase Stored Procedures