Oracle Data Integrator (ODI) 12c
ETL Tools Training

Oracle Data Integrator (ODI) 12c

Apply to Course Now

About the Course

Oracle Data Integrator (ODI) is one of the leading data integration tools that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes. Oracle Data Integrator’s Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data – the approach that optimizes performance, scalability and lowers overall solution costs.

This course teaches how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms.

It also teaches usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, how you can create and manage ODI repositories which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

By the end of this course, you will be confident enough in the tool and ready to take your next professional challenge to implement a data integration project using ODI as your tool.


Who Should Attend

Oracle Data Integrator (ODI) course is designed to give you the knowledge and hands-on experience for you to be confidently start using the power of this tool to your benefit.

The only prerequisite is that you should have a fair understanding of data, SQL concepts. However, if you have a basic understanding of any ETL tool, you can do really well with this course and learn this tool faster!


Course Curriculum

Serial# Topic Description
1. Introduction Overview of ODI, Why ODI, ODI 11g architecture and comparision with ODI 12c, ODI Repositories and types of ODI agents. More on ODI Graphical interface etc.
2. ODI Topology Concepts Overview of ODI Topology, Data Servers and Physical Schemas, Defining the Physical Architecture, Defining the Logical Architecture, Mapping Logical and Physical Resources, Defining Agents, Creating Topology etc.
3. ODI Repositorie and Agent Administration Administrating ODI Repositories, Using RCU, Creating Repository Storage Spaces, Creating and Connecting to the Master Repository, Creating and Connecting to the WorkRepository, Managing ODI Agents, Creating a Physical Agent, Launching a Listener, Scheduler and Web Agent, Load Balancing and more.
4. ODI Logical and Physical Architecture Overview of Topology Manager, Creating Physical Architecture, Creating a Data Server, Testing a Data Server Connection, Creating a Physical Schema, Creating Logical Architecture, Overview of Logical Architecture and Context Views, Linking the Logical and Physical Architectures etc.
5. Working With ODI Projects Overview of ODI Projects, Creating a New Project, Using Folders, Organizing Projects and Folders, Understanding Knowledge Modules, Exchanging ODI Objects, Exporting and Importing Objects, Using Markers and practical assignments.
6. ODI Model Concepts Overview of ODI Model, Understanding Metadata in ODI, Reverse Engineering, Creating Models, Organizing Models, Creating Datastores, Using Constraints in ODI, Creating Keys and References, ODI Interfaces, Rules for Interfaces, ODI Mapping, Operators and transformations such as Joiners, Filters, Constraints and more.
7. ODI Interface Concepts Business Rules for Interfaces, Mappings in ODI 12c, Integration Process, Execution Location in ODI, Knowledge Modules (KM) with ODI Interface, Working with Interfaces and Mappings, Multiple Source Datastores, Creating Joins, Transformations, Overview of the workflow, Working with Knowledge Modules, Monitoring and Debugging, Using Operator, Viewing Sessions and Tasks, Troubleshooting and more.
8. ODI Advance Concepts I Using variables, User Functions, Substitution Methods, Modifying a Knowledge Module (KM), Writing Custom KM, Using RKM for Customized Reverse Engineering and more practical examples of using KMs. Working with Procedures, Adding Commands, Adding Options, Working with Packages, Error Handling, Controlling an Execution Path, Creating a Loop, Using Advanced tab, Working with Scenarios, Automating Scenario Management and much more.
9. ODI Advance Concepts II Overview of Data Quality, Enforcing Data Quality, Auditing Data Quality, Techniques of Changed Data Capture, Changed Data Capture in ODI, CDC Strategies in ODI, Practical examples of using CDC in ODI and much more.


I took classes on Data Modeling and I think I was amazed by depth of knowledge I received. Highly recommend Data Modeling classes from these awesome people!

Thank you for helping me learn Big Data and Hadoop platform at the time I needed this information when I was getting ready to start my career as Big Data architect. Especially grateful for support after classes were over. Thank you!

I wanted to learn SQL and PL/SQL and took classes. This was the best investment I made in myself. Truly, self-education is the best thing to do and with help is SmartBIExperts group, it was great experience.


Have Some Questions?

We believe in offering the highest quality courses, created by industry experts who share our commitment to excellence in teaching and learning, both online and in the classrooms.  Use the form below to ask your question.

Contact Us Today

Your email address will not be published. Required fields are marked *