ODI 12C All Steps - Become a ODI/ETL Developer

Find out how to become an Expert Data warehouse and ETL life cycle with ODI 12C
2.3 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
549 students enrolled
62% off
Take This Course
  • Lectures 28
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2016 English

Course Description

Would you like to be a ODI/ETL Developer with  ODI 12C Training? ODI 12C is a last version of Oracle's integrator tool.  In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of the theorical informations to provide a better education.

After obtaining these informations, you’ll learn ODI objects/new components and design new packages/mappings. . In this training, all of the abilities that a ETL and ODI developers  must have will be explained.  You’ll be able to have a wide range of informations over the topics listed bellow:

ODI (Oracle Data Integrator) 12C

  • Introduction to Oracle Data Integrator 12C
  • ODI Studio Components
  • ODI Repositories
  • Creating Master Repository
  • Creating work Repository
  • Overview of Topology Navigator
  • Creating Physical Architecture
  • Creating a Data Server
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • New features in ODI 12C
  • using new components in ODI 12C 
  • Overview of Logical Architecture and Context Views
  • Linking the Logical and Physical Architecture
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Overview of ODI Projects
  • Creating a New Project
  • Introduction to Knowledge Modules
  • Types of Knowledge modules
  • Creating a Basic Interface
  • Designing an Interface
  • Integration knowledge module (IKM) overview
  • Using Knowledge Modules (KM) with ODI Interface
  • Executing the interface
  • Operator Overview
  • Viewing the session log in operator
  • Exploring the code in operator
  • Creating simple mappings
  • Setting knowledge module option Truncate to True
  • Join Transformations
  • Set Operators Transformations
  • Creating Packages in ODI

Why you should have this course?

This is not a theorical education. All of  lessons are implemented in my machine. You can find all steps that you need to know when you want to develop a project in ODI 12C. I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the real projects.

With various documents and end-of-chapter quizes, I aim to reinforce the topics.

As being more than 6 years in the sector and being an instructor in companies that have big DWH structures, I provide this course.

You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.

What are the requirements?

  • Internet Access
  • Basic knowledge about SQL

What am I going to get from this course?

  • In the end of the course, you’ll be able to develop and design all kind of ODI jobs(Packages, Schedules, ETL cycle, etc..)
  • Development Jobs with using ODI 12C new components, new mapping
  • Understand Knowledge Module structures
  • Create Topology and understand installation logic
  • Step by Step ODI 12C Components and Structures
  • Load Tables with different Knowledge Modul
  • Mapping Designing

Who is the target audience?

  • Students
  • Developers and Analysts
  • Private company employees
  • Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
  • Data Scientists
  • Those who wants to learn ODI product and develop themselves in this subject

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction

About Course

Section 2: Preparing Database Environment and ODI 12C

We'll download Oracle that we need.


We'll install Oracle step by step.


You can find all step in here ODI and Database.

Section 3: Topology &Middleware setup

Installation master and work repository in ODI 12C. 


We'll create and design  Physical and Logical Schema. Everything that you will need about topology in this section.

Section 4: Design and Development

We can say Interface from ODI 11g, we will see its name as Mapping.


Importing tables that we will use them into Mapping and Package.


We can start developing sample projects.


Importing some important knowledge modules and you can meet knowledge module.


Using Joing between more then one tables and some filters.


Hardcode data that is mean what we want to see in our target table, we need to enter manually.


Performing sequence in a target table.


We have created a few mapping and we can use them into a package.


Using a variable in a package. Variable has a value that can be string , number or date. in this section you will learn using string and number.


Scenario that is like a snapshot of mapping or package. 


A date variable can be used lots of projects. 


Lookup tables has some values, they are usually description of a value. 


The components are new features in ODI 12C. And we will see using Join Component in this section.


Union combines more than one results. But we shouldn't forget all scripts have same column number and character types. 


Sorting Data over a number column using Sort component. it is new feature in ODI 12C.


Distinct component is used for checking dublicate rows. it is a new feature in ODI 12C.


When we want to use "not in" or "in" or equal with other column that is in other table we can use subquery component. it is a new feature in ODI 12C.


continuing with subquery component


Expression component can be used for heaping some results. We will see it.


Aggregate component is a new feature in ODI. we can use it for using "SUM", "COUNT" or any math formulas.


For seperating datas over some cases we need to use split component. This is new feature in ODI.


We will see how to use a reuseble mapping. And understand why it is used.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mustafa Aksoy, DWH Architect & Data Scientist

After graduation from university I started to work as a DWH-ETL Developer in the telecommunication company. I am a data warehousing and ETL specialist having over 5+ years of experience in telecommunication and banking Industry.

Now, I am here to share my Know-how, experience and advantages of working Data Warehouse and ETL projects with them who want to plan students' career in DWH-BI and for them who want to learn about these technologies and discover further.

good luck!

Instructor Biography

Yusuf Arslan, DWH/Business Intelligence & Big Data Architect

For 10 years of my work life, I’m continuing to work as an architect of Business Intelligence & Data Warehouse. I’ve realized projects over Data Warehouse and Business Intelligence in different technologies (Oracle, IBM, Teradata, Microsoft, SAP). Since 8 years, I’ve been giving trainings over Data Warehouse,SQL, Database and Business Intelligence.

Also I provide to training Companies, students and worker about BI, DWH, Reporting Tools etc.. in IT Sector.

Finally, My specialities are Modelling of DWH, ETL Development, Design of Reporting,Data Replication, Data Migration, Master Data Management, Metadata Management, Big Data.

Thanks - Good Luck!

Ready to start learning?
Take This Course