What is Oracle Data Integrator?

byAlooma Team
Updated Apr 3, 2018

Oracle Data Integrator (ODI) is a data integration software product. From the Oracle documentation: "A widely used data integration software product, Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique E-LT architecture (Extract - Load Transform), Oracle Data Integrator not only guarantees the highest level of performance possible for the execution of data transformation and validation processes but is also the most cost-effective solution available today."

Oracle Data Integrator architecture

The ODI architecture's central component is the Repository. It stores configuration information about the IT infrastructure, metadata of all applications, projects, scenarios, and the execution logs.

The repository is an absolutely open, comprehensive, and shared metadata database accessed by the applications responsible for transformation, project development, integration, and information redistribution. Other architecture components to note comprise the ODI Studio, including: the Designer, Security Manager, Operator, and Topology Navigators.

Designer Navigator is used to design data integrity checks and to build transformations like:

  • Automatic reverse-engineering of existing applications or databases
  • Graphical development and maintenance of transformation and integration interfaces
  • Visualization of data flows in the interfaces
  • Automatic documentation generation
  • Customization of the generated code

Operator Navigator is the production management and monitoring tool. Through Operator Navigator, IT production operators can manage interface executions in the sessions, as well as the scenarios in production.

Topology Navigator is used to manage the data describing the information system's physical and logical architecture. Use Topology Navigator to manage the topology of the information system, the technologies and their data types, the data servers linked to these technologies and the schemas they contain, the contexts, the languages and the agents, as well as the repositories.

Security Navigator is the tool for managing the security information in Oracle Data Integrator. Use Security Navigator to: create users and profiles, assign user rights for methods (edit, delete, etc.) on generic objects (data server, data types, etc), and fine-tune these rights.

Like what you read? Share on
Data IntegrationExtract, Transform, Load (ETL)

Further reading

What is CloverETL?
Alooma Team • Updated May 9, 2018
What is Talend Open Studio?
Alooma Team • Updated Mar 7, 2018
Take control of your data for free!
Sign up and get $500 worth of free credits to try Alooma.
Get started