OAG Reduces Costs by Automating Data Transfer Operations

Overview

OAG receives data from the vast majority of airlines operating flights worldwide. This data, received in a variety of formats and with varying levels of consistency, needs to be cleaned, validated, stored, and redistributed to OAG's clients. The data was previously stored on a set of mainframes that ran custom-developed programs. OAG recently launched a migration program, to transfer the applications to DB2 RDBMS on IBM/AIX platforms. As part of its migration strategy, OAG decided to abandon proprietary technologies and custom scripts and to use an open system with an industry-standard RDBMS. The unique approach of Oracle Data Integrator [formerly called Sunopsis] is that it does not use a proprietary engine but rather relies on RDBMS engines to transform and process data.