Download PDF
Lufthansa: Real-time Flight Planning with Fivetran
Technology Category
- Analytics & Modeling - Real Time Analytics
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Aerospace
Use Cases
- Real-Time Location System (RTLS)
- Time Sensitive Networking
The Challenge
Lufthansa Systems, a division of Lufthansa Airlines, is a leading provider of IT services in the airline industry, serving around 300 airlines worldwide. One of its offerings is Lido/FPLS (flight planning services), which optimizes flight routes in terms of cost, fuel, and time, generating millions of dollars in extra profits for its customers each year. The challenge was that creating these optimized flight plans required massive amounts of data, including up-to-date weather reports, air traffic data, and airline-specific data such as flight schedules, payload, operational conditions, and contracted petrol prices. Lufthansa Systems needed a solution that would allow its central data repository to receive continuous updates from these data sources and distribute optimized flight plans and other data to each customer's site.
About The Customer
Lufthansa Systems is a division of Lufthansa Airlines and is one of the world’s leading providers of IT services in the airline industry. It serves roughly 300 national and international airlines, which is more than one-third of all airlines worldwide. Among its many offerings, Lufthansa Systems offers Lido/FPLS (flight planning services), which determine the most effective flight routes in terms of cost, fuel, and time. By optimizing flight routes, Lido/FPLS generates millions of dollars in extra profits for its customers each year.
The Solution
Lufthansa Systems uses Fivetran to provide bi-directional replication between its central data repository and hundreds of global customer data warehouses. Fivetran's extreme data compression and pipelined architecture maximize throughput over slow, restricted network links. Several of Lufthansa System’s customers have also used Fivetran to create a hot-standby database for Lido/FPLS in their own data centers to ensure high availability and to create additional data warehouses for reporting. Over the more than 15 years Lufthansa airlines has been using Fivetran, the product has successfully met changing requirements. For example, Lufthansa Systems originally relied on Ingres, but over time it has gradually migrated to Oracle. Fivetran has easily accommodated this change.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Airbus Soars with Wearable Technology
Building an Airbus aircraft involves complex manufacturing processes consisting of thousands of moving parts. Speed and accuracy are critical to business and competitive advantage. Improvements in both would have high impact on Airbus’ bottom line. Airbus wanted to help operators reduce the complexity of assembling cabin seats and decrease the time required to complete this task.
Case Study
Aircraft Predictive Maintenance and Workflow Optimization
First, aircraft manufacturer have trouble monitoring the health of aircraft systems with health prognostics and deliver predictive maintenance insights. Second, aircraft manufacturer wants a solution that can provide an in-context advisory and align job assignments to match technician experience and expertise.
Case Study
Aerospace & Defense Case Study Airbus
For the development of its new wide-body aircraft, Airbus needed to ensure quality and consistency across all internal and external stakeholders. Airbus had many challenges including a very aggressive development schedule and the need to ramp up production quickly to satisfy their delivery commitments. The lack of communication extended design time and introduced errors that drove up costs.
Case Study
Developing Smart Tools for the Airbus Factory
Manufacturing and assembly of aircraft, which involves tens of thousands of steps that must be followed by the operators, and a single mistake in the process could cost hundreds of thousands of dollars to fix, makes the room for error very small.
Case Study
Accelerate Production for Spirit AeroSystems
The manufacture and assembly of massive fuselage assemblies and other large structures generates a river of data. In fact, the bill of materials for a single fuselage alone can be millions of rows of data. In-house production processes and testing, as well as other manufacturers and customers created data flows that overwhelmed previous processes and information systems. Spirit’s customer base had grown substantially since their 2005 divestiture from Boeing, resulting in a $41 billion backlog of orders to fill. To address this backlog, meet increased customer demands and minimize additional capital investment, the company needed a way to improve throughput in the existing operational footprint. Spirit had a requirement from customers to increase fuselage production by 30%. To accomplish this goal, Spirit needed real-time information on its value chain and workflow. However, the two terabytes of data being pulled from their SAP ECC was unmanageable and overloaded their business warehouse. It had become time-consuming and difficult to pull aggregate data, disaggregate it for the needed information and then reassemble to create a report. During the 6-8 hours it took to build a report, another work shift (they run three per day) would have already taken place, thus the report content was out-of-date before it was ever delivered. As a result, supervisors often had to rely on manual efforts to provide charts, reports and analysis.
