Headquartered in Stockholm, Sweden, Scandinavian Airlines (SAS) is the largest airline in Scandinavia. It flies to 150 destinations, employs 32,000 staff, and carries 40 million passengers annually. The mainframe data warehouse had become expensive to run and maintain and it was becoming difficult to deliver the Business Intelligence vital to competing within the airline industry in a timely manner. SAS chose to migrate to Windows, achieving improved customer satisfaction, faster time-to-market, reduced costs and increased revenue per customer.
TLeading the Evolution
Case Study: Scandinavian Airlines
Scandinavian Airlines
modernize Business
Intelligence capabilities
while lowering costs
by re-using existing
applicationsCase Study | Scandinavian Airlines
Scandinavian Airlines (SAS) modernize Business Intelligence capabilities while lowering costs by re-using existing applications
The CustomerChallenge Headquartered in Stockholm, Sweden, SAS need to provide better business Scandinavian Airlines (SAS) is the largest intelligence reporting and improved airline in Scandinavia. It flies to 150 adhoc analysis capabilities by providing real time data access while destinations, employs 32,000 staff, and carries reducing costs. 40 million passengers annually.
Solution The ChallengeApplication Modernization: Business Intelligence (BI) is vital to competing Micro Focus StudioT within the airline industry. However, at SAS, Micro Focus ServerT the mainframe data warehouse had become expensive to run and maintain and it was Customer Benefits becoming difficult to deliver the BI in a timely manner. an Intel server running Windows.Better Business Intelligence (BI)Increased revenue per customer The BI data warehouse was hosted on the MigrationWare, a strategic Micro Focus partner, was chosen to undertake the Improved customer satisfaction same mainframe as other critical business processes, so applications supporting BI migration of the COBOL/DB2 applications Faster time to market were treated as a lower priority. This meant and the associated Job Control that was the Reduced costs the BI batch processes could take as long as backbone of the BI environment.six hours to complete, severely impacting SAS used the Micro Focus' Revolve® analysis the timely delivery of BI reports to business tool to map out the viability of the migration analysts. from the mainframe to Windows and ensure SAS realised it had to dramatically modernize they adequately scoped the project.its BI capabilities to deliver near real time Micro Focus StudioT and Micro Focus ServerT scenario for reporting and analysis. SAS were used to enable the existing COBOL and needed a data warehouse with desktop JCL to be re-used with minimum change "By re-using our existing data tooling that did not have to compete for and to capitalise on existing COBOL/JCL warehousing applications in mainframe resources and which analysts programming expertise.could use to quickly customize reports, rather a Windows environment we SQL Server was selected as the new data than SAS having to rely on an expensive delivered the new system much warehouse repository and Microsoft Active external vendor.faster than if we had attempted Directory® was utilized to implement SAS initially looked to write new applications appropriate security over the network.a re-write. At the same time we to run on a Windows Server utilizing were able to provide a better MigrationWare undertook the actual project Microsoft® SQL ServerT 2005 but cost development environment to move the mainframe applications to implications, time to market and risk involved Windows including the conversion of VSAM for our programmers and meant this was simply not viable. This is when data files and the migration of all the relevant enable our business analysts to SAS turned to Micro Focus. mainframe DB2 data to SQL Server. In ddition, exploit contemporary Business MigrationWare provided technology to ease Intelligence tools to make more The Solution the application migration by emulating the informed decisions based on up behaviour of standard DB2 utilities against SAS approached Micro Focus as it offered a to date data." SQL Server.variety of low risk approaches to Application Per Petterson Modernization. After discussing the options, System Manager: Enterprise Data Warehouse, SAS SAS decided to modernize the BI capability by reusing its existing mainframe applications on Case Study | Scandinavian Airlines
Scandinavian Airlines (SAS) modernize Business Intelligence capabilities while lowering costs by re-using existing applications
The Result Reduced costs'MigrationWare used a mixture Better BI The migration to Windows has resulted in a 50 of technology and expertise to percent reduction in annual costs associated Batch processes that had previously taken six ensure the data warehousing with the data warehouse and applications hours to complete... [download for more]