Automated testing in Oracle's and SAP BO's BI-Migration projects according to Microsoft SQL Server

Bolt Data Solutions supported the life insurer by data warehouse and business intelligence area in migration. In agile project has BiG EVAL‘s testautomation been used, which now ensures data quality even in productive operation.

The Challenge

As part of Swiss Life’s private customer segment product life cycle, the insurance company decided to replace its existing SAP BusinessObjects system with a reporting and analysis system based on Microsoft SQL Server 2016 and Excel.

Bolt Technology Consulting assisted Swiss Life with the design and subsequent implementation of the new system, as well as with the migration of the company’s existing reports.

The Solution with Microsoft SQL Server 2016

The existing Data Warehouse in Oracle and Data Mart has been replaced for a Microsoft SQL Server 2016 Data Warehouse and provided to a Azure Stack cloud.

From the perspective of analysis the Microsoft SQL Server Analysis Services developed a tabular model, which mirrores the logic of SAP Business Objects universes. This in-memory model is now available for both standardized reports and ad-hoc analysis with PowerBI, Microsoft Excel and Sharepoint.

Automated testing ensured Data quality

One of the project management’s key objectives was to maintain consistently high data quality. In order to accomplish this, they utilized Bolt Technology Consulting’s BiG EVAL test suite. 

With the help of BiG EVAL, a variety of regression tests were implemented for the database loading process. These tests regularly check the system for various sources of error, both known and unknown.

With BiG EVAL, testing can be done both in the development/testing environments and in the operational environment. The latter allows for the early identifi cation of problems and for appropriate measures to be taken before users end up making decisions on the basis of a faulty database.

About Swiss Life AG

The Swiss Life Group is a leading European provider of comprehensive pension and financial solutions. Through its own agents as well as distribution partners such as brokers and banks, Swiss Life offers comprehensive individualized advice and a broad selection of proprietary and partner products to its private customers and corporate clients in its core markets of Switzerland, France and Germany.

Nikola PerićSwiss Life AG – Data Analytics Testautomation