Oracle Data Integrator

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 processes in business intelligence systems.

History

Oracle purchased Sunopsis in October 2006[1] and re-branded it as Oracle Data Integrator (ODI). The aim of this acquisition was to enhance the Oracle Fusion Middleware 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. On 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/JSP application that enables access to the repository through a Web interface.
  • Lightweight Designer, a Web application 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 (SOA).
gollark: Imagine having no headphone jack. Imagine no µSD slot. Imagine being pointlessly large for no reason. Imagine using a proprietary connector for charging etc. Imagine running an OS which forces all apps to be downloaded through a proprietary store.
gollark: They are NOT very good still. They're unrepairable, uncustomizable, encourage lock-in, and in many cases have stupid flaws like just not having adequate cooling.
gollark: Well, in a very real sense, Apple products bad.
gollark: How is it meant to work, exactly, compare *every frame*?
gollark: People get it wrong EVERYWHERE and it's annoying.

References
  1. "Oracle Buys Sunopsis". oracle.com (Press release). Oracle. 9 October 2006. Retrieved 10 March 2020.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.