Fivetran Case Studies Lufthansa: Real-time Flight Planning with Fivetran

Edit This Case Study Record

	Lufthansa: Real-time Flight Planning with Fivetran Fivetran

Lufthansa: Real-time Flight Planning with Fivetran

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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 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.

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.

Impact #1	The use of Fivetran has allowed Lufthansa Systems to ensure that its airline customers have the optimized flight plans they need, when they need them. The bi-directional replication between its central data repository and hundreds of global customer data warehouses has been highly efficient. Fivetran’s extreme data compression and pipelined architecture have maximized throughput over slow, restricted network links. The solution has also proven to be highly flexible, scalable, and robust, successfully meeting changing requirements over the more than 15 years that Lufthansa airlines has been using Fivetran.

Impact #1

The use of Fivetran has allowed Lufthansa Systems to ensure that its airline customers have the optimized flight plans they need, when they need them. The bi-directional replication between its central data repository and hundreds of global customer data warehouses has been highly efficient. Fivetran’s extreme data compression and pipelined architecture have maximized throughput over slow, restricted network links. The solution has also proven to be highly flexible, scalable, and robust, successfully meeting changing requirements over the more than 15 years that Lufthansa airlines has been using Fivetran.

Benefit #1	not mentioned
Benefit #2	not mentioned
Benefit #3	not mentioned

Benefit #1

not mentioned

Benefit #2

not mentioned

Benefit #3

not mentioned

Download PDF Version

Overview

Lufthansa: Real-time Flight Planning with Fivetran

Operational Impact

Quantitative Benefit