Architecture of Oracle Data Integrator

The Oracle Data Integrator architecture is organized around a modular repository, which is accessed in client-server mode by components such as the ODI Studio and execution Agents that are written entirely in Java. The architecture also incorporates web-based components such as the Management Pack for Oracle Data Integrator which integrates with the Oracle Enterprise Manager Cloud Control infrastructure or the ODI Console which enables users to access metadata information through a Web interface.

Oracle Data Integrator Studio :

ODI Studio provides four graphical Navigators for managing ODI artifacts: Designer, Operator, Topology and Security. ODI Studio offers an easy to use graphical user interface and can be installed on various platforms such as Microsoft Windows or Linux. 
ODI Studio
ODI Studio Navigators are as follows:
  • Designer defines declarative rules for data transformation and data integrity. All project development takes place in this module; this is where database and application metadata are imported and defined. The Designer module uses metadata and rules to generate data integration scenarios or load plans for production. This is the core module for developers and metadata administrators.
  • Operator manages and monitors data integration processes in production. It is designed for operators and shows execution logs with error counts, the number of rows processed, execution statistics, the actual code that is executed, and so on. At design time, developers can also use the Operator module for troubleshooting purposes.
  • Topology defines the physical and logical architecture of the infrastructure. The infrastructure or projects administrators register servers, database schemas and catalogs, andagents in the master repository through this module.
  • Security manages user profiles, roles and their privileges. Security can also assign access authorization to objects and features. Security administrators generally use this module. All modules store their information in the centralized repository.

VirtualNuggets 2137674064600865899

Post a Comment


Home item

Popular Posts


Random Posts

Flickr Photo