ODI Basic Theory

Oracle Data Integrator provides a fully unified solution for building, deploying, and managing complex data warehouses or as part of data-centric architectures in a SOA or business intelligence environment. In addition, it combines all the elements of data integration—data movement, data synchronization, data quality, data management, and data services—to ensure that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) features an active integration platform that includes all styles of data integration: data-based, event-based and service-based. ODI unifies silos of integration by transforming large volumes of data efficiently, processing events in real time through its advanced Changed Data Capture (CDC) capability, and providing data services to the Oracle SOA Suite. It also provides robust data integrity control features, assuring the consistency and correctness of data. With powerful core differentiators - heterogeneous E-LT, Declarative Design and Knowledge Modules -Oracle Data Integrator meets the performance, flexibility, productivity, modularity and hot-pluggability requirements of an integration platform.

Traditional ETL tools operate by first
E
extracting the data from various sources,
T 
transforming the data in a proprietary, middle-tier ETL engine that is used as the staging area, and then
L
loaring the transformed data into the target data warehouse or integration server. Hence the term
ETL

represents both the names and the order of the operations performed.

User Interfaces:

  Administrators, Developers and Operators use the Oracle Data Integrator Studio to access the repositories. This Fusion Client Platform (FCP) based UI is used for administering the infrastructure (security and topology), reverse-engineering the metadata, developing projects, scheduling, operating and monitoring executions. Business users (as well as developers, administrators and operators), can have read access to the repository, perform topology configuration and production operations through a web based UI called

Oracle Data Integrator Console

  This Web application can deployed in a Java EE application server such as Oracle WebLogic.ODI Studio provides four Navigators for managing the different aspects and steps of an ODI integration project.

Topology Navigator:

Topology Navigator is used to manage the data describing the information system's physical and logical architecture. Through Topology Navigator you can manage the topology of your information system, the technologies and their data types, the data servers linked to these technologies and the schemas they contain, the contexts, the language and the agents, as well as the repositories. The site, machine, and data server descriptions will enable Oracle Data Integrator to execute the same interfaces indifferent environments.

Designer Navigator:

Designer Navigator is used to design data integrity checks and to build transformations such as for example:

• 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.

Operator Navigator:

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

Security Navigator:

Security Navigator is the tool for managing the security information in Oracle Data Integrator. Through Security Navigator you can create users and profiles and assign user rights for methods (edit, delete, etc) on generic objects (data server, datatypes,etc), and fine-tune these rights on the object instances (Server 1, Server 2, etc).