MigrationWare, a Cape Town based IT-company, has completed a project assisting the Denmark-based Scandinavian Airlines (SAS) Nordic to migrate its data warehouse suite of applications off its mainframe to a Windows hardware platform.
João de Oliveira, MigrationWare Sales Director, says the SAS IT team faced the challenge of resource conflicts between transactional systems and data analysis applications on the mainframe. As a result, the performance of analysis applications accessing the data warehouse was often impeded because priority was given to transactional systems.
“Data analyses on the mainframe could take as long as six hours to perform which meant that reports were only delivered the next day to analysts. This prevented the timeous access to data, slowing up the business’ ability to make decisions,” he says.
One of the options available to SAS was to re-write all the mainframe applications for a modern platform, built around Windows Server 2003 and SQL Server. However, de Oliveira says the cost implication of this as well as the time it would have taken meant this was simply not viable. MigrationWare, together with its UK based partner, Micro Focus, provided a “lift and shift” solution, migrating the data warehouse suite of applications to a Windows hardware platform.
Micro Focus products were chosen to capitalise on existing Cobol programming expertise. Micro Focus’ Revolve analysis tool was also used to map out the viability of the migration from the mainframe to the Windows environment.
“MigrationWare was able to take SAS’s data warehouse applications and modify them where needed to ensure they functioned in a Windows environment. It also provided the technology to emulate mainframe behaviour to ensure that the data warehousing applications functioned optimally in their new environment,” de Oliveira says.
Furthermore, the 500 Cobol programs and 250 DB2 tables were migrated without any significant modifications to the applications.
Per Petterson, System Manager: Enterprise Data Warehouse at SAS, says migrating SAS’ data warehousing applications off the mainframe into a Microsoft environment not only saved us the cost and time of re-writing the applications, but gave our programmers the flexibility of a Windows environment.
“This opened up the use of Business Intelligence (BI) tools to the business for the analysis of data and gave SAS the ability to quickly analyse trends within the business and make business decisions based on the data,” he says.
De Oliveira says the results of the migration included a reduction in associated mainframe costs, while lowering cost of ownership of the company’s hardware.
“Reports that had previously taken six hours to perform now could be done in two hours, allowing analysts to have more timeous access to data in order to make critical business decisions,” he says.
The self-help environment for SAS business analysts now allows them to quickly design their own queries and reports to respond to competitor action and market trends as opposed to waiting for an external vendor to create the reports, as happened previously, de Oliveira adds. This flexibility enabled SAS to improve its relationships with its customers and increase per-customer revenues.
Petterson says SAS can now respond far quicker to market trends.
“Detailed analysis of customer behaviour, such as Internet reservations and check-ins, call centre interactions can now be performed. The impact of flight delays and cancellations on SAS customers has also been reduced. And the migration into a Windows environment has resulted in a 50 percent reduction in the total data warehousing cost,” he says.