Technical Documentation

Small and large companies are increasingly using an information system to support their decisions. These information systems have certain characteristics: various types of sources and various types of targets. In recent years there has been an increase in mergers and incorporations between national and international companies and very often the need to conglomerate structures and information emerges after these processes have taken place.

For this reason, companies that use Oracle Warehouse Builder (OWB) find themselves in the situation of having to manage ETL flows whose targets are not only Oracle databases or files but also DB2, MSServer etc, etc, which is not possible with OWB. Oracle recently proposed another of its ELT applications, called Oracle Data Integrator which, unlike OWB, provides the possibility of using a wide range of products both as source and target of data flows. Note that as supported targets, there are not only database objects, but a large amount of files are supported, including CSV and Excel.

Migrating from Oracle Warehouse Builder to Oracle Data Integrator, however, is not so straightforward. The only solution currently available is a manual migration, where a team must reimplement the OWB mappings with the different ODI logic. All this entails a high expenditure of time, human and economic resources for the company, as well as an initial phase necessary for learning how the new tool works.