So we are back with new lessons for beginners to learn ODI. They are free to study and grasp the knowledge. Do share your feedback in comments below.
So coming to ODI…Now a days its a niche skill and best optimised Oracle supported tool for ELT process. I hope my friends who are reading further , understand the difference between ETL and ELT tools. Its not only the full form that differs, but the full architecture of the data integration project changes.Proceeding further, refresh your basics upon ETL vs ELT tools by clicking here.
What is ODI ?
As per the Oracle documentation available online, ODI provides a fully unified solution for building, deploying, and managing complex data warehouses or as part of data-centric architectures in a SOA (Service oriented) 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.
So basically, 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. 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.
To learn ODI graphical interface, please click here.
We have many images available online for ODI, so posting here will not make any new diffference. We as beginner need to understand that ODI Arch have 4 main components:
- Repository : ODI has 2 type of repositories, Master repository and the Work repository. ODI is metadata driven model where everything is stored in these 2 mentioned repositories. The Master repository contains information about security Navigator (users, profiles, etc), topology (data connections, contexts, physical/logical schemas), and ODI versions. Each Master repository can be linked to one or more Work repositories. but each work repository must be and can be linked to only 1 master Repo. Work repositories is basically for developer to code. It can be of 2 different types: development & execution. In a Development Work repository you’ll find all of the design objects (mappings, packages, procedures, etc) and datastore metadata. Once Development is over , we move to its Execution phase where Execution Work repository only stores the execution objects, Scenarios and Load Plans, and there is no development capability.
- Agents : Whatever code the developer generates, are retrieved by the run time agents. They connect to Data servers and run the code scenarios in mentioned context. It also retreives the log information along with error code and execution messages.We have two types of agents namely :
a) Stand alone Agent
b) Java EE Agent.
Will describe them in my further tutorials. click here.
- ODI studio :As per Oracle documentation, Oracle Data Integrator Studio is a developer’s interface for configuring and managing ODI. It provides four navigators for managing the different aspects and steps of an ODI integration project namely below. Click here to read more on ODI Studio
- JEE Components: ODI has many JEE components to handle servers, security , administration, monitoring etc. Below mentioned are few JEE components deployed along with ODI server:
a) Enterprise manager
b) ODI console
Click here to go to Lesson 2 of learning ODI 🙂
stay Tuned !!