Oracle Data Integrator (ODI) is an Extract, load and transform (ELT) (in contrast with the ETL common approach) tool produced by Oracle that offers a graphical environment to build, manage and maintain

data integration Data integration involves combining data residing in different sources and providing users with a unified view of them. This process becomes significant in a variety of situations, which include both commercial (such as when two similar companies ...

processes in

business intelligence Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis and management of business information. Common functions of business intelligence technologies include reporting, online analytical p ...

systems.

History

Oracle purchased Sunopsis in October 2006 and re-branded it as Oracle Data Integrator (ODI). The aim of this acquisition was to enhance the

Oracle Fusion Middleware Oracle Fusion Middleware (FMW, also known as Fusion Middleware) consists of several software products from Oracle Corporation. FMW spans multiple services, including Java EE and developer tools, integration services, business intelligence, c ...

offering, which required broad support to heterogeneous sources and targets. After the purchase Oracle continued to offer separately ODI as well as its former ETL product

Oracle Warehouse Builder Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems. Features The primary use for OWB is consolidation ...

. In January 2010 Oracle announced their intention to merge them into a single product (Oracle Data Integrator Enterprise Edition).

Components

Oracle Data Integrator comprises the following components: * The Modular Repository, made up of a master repository and of one or several work repositories to store metadata about the data integration process. These repositories can be installed on any database engine that supports ANSI ISO 89 syntax. * The graphical interface modules (topology manager, designer, security manager, operator) and the execution agents (agent). These are entirely built with Java components that give access to the repository in client/server mode. * Metadata Navigator, a

Servlet A Jakarta Servlet (formerly Java Servlet) is a Java software component that extends the capabilities of a server. Although servlets can respond to many types of requests, they most commonly implement web containers for hosting web application ...

/ JSP application that enables access to the repository through a

Web interface In the industrial design field of human–computer interaction, a user interface (UI) is the space where interactions between humans and machines occur. The goal of this interaction is to allow effective operation and control of the machine fr ...

. * Lightweight Designer, a

Web application A web application (or web app) is application software that is accessed using a web browser. Web applications are delivered on the World Wide Web to users with an active network connection. History In earlier computing models like client-serv ...

to view and edit objects in the repository through a Web browser. * Oracle Data Integrator Public Web Services, which allow users to leverage Oracle Data Integrator features in a

Service-oriented architecture In software engineering, service-oriented architecture (SOA) is an architectural style that focuses on discrete services instead of a monolithic design. By consequence, it is also applied in the field of software design where services are provide ...

(SOA).

References

{{reflist

External links

Overview of Oracle Data Integrator

Oracle Data Integrator and Oracle Warehouse Builder Statement of Direction
Extract, transform, load tools Oracle software