Oracle Data Integrator Essentials
4.5 (2 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.
16 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Data Integrator Essentials to your Wishlist.

Add to Wishlist

Oracle Data Integrator Essentials

Develop, deploy, and maintain your own data integration projects with a clear view of Oracle Data Integrator essentials
4.5 (2 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.
16 students enrolled
Created by Packt Publishing
Last updated 12/2014
Current price: $10 Original price: $85 Discount: 88% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Get to know the difference between ETL and ELT
  • Find out how to make the best use of ODI objects such as joins, datasets, filters, and sequences
  • Build workflows based on packages to execute a process
  • Define your strategy with Knowledge Modules and adapt these module to your needs
  • Create reusable pluggable procedures for recurring tasks
  • Perform your daily tasks such as administration, maintenance, and deployment easily
  • Understand how the architecture of ODI can be set up and how and where ODI stores its metadata
  • Comprehend the use of scenarios as the smallest deployments units in ODI
  • Discover how solutions are used to resolve dependencies between different ODI objects
View Curriculum
  • A practical guide bursting with tips and real-world best practices to get you on your way with Oracle Data Integrator and help you make the most of this tool.

Oracle Data Integrator (ODI) is Oracle’s strategic tool covering all your data integration requirements. ODI lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI as a powerful tool for data integration solutions, it’s time you started making the most of it. This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements. Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules. First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions. By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.

Who is the target audience?
  • If you are a database administrator or data warehouse developer wanting to broaden your skills in data integration tasks and transformations using Oracle Data Integrator, this is the course for you.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
The ODI Core Concepts
6 Lectures 24:15

Understand the use of ODI as a tool to make your data integration tasks easier.

Preview 02:53

Avoid ETL, let the database work and use ELT.

Differentiating between ETL and ELT

Familiarize yourself with the graphical interface of ODI Studio.

Exploring the Graphical UI

Knowing the ODI basics helps you know where you can find what you need to find in ODI.

ODI Basics

Strategy is contained in Knowledge Module (KM); so, what are these KMs?

Preview 02:53

ODI uses temporary objects but where to store them is the question. We'll answer it in this video.

The ODI Staging Area
Developing in ODI – the Core Objects
4 Lectures 21:48

Here you'll get to know when you need to use a project and when you need to use a folder.

Organizing Your Project

The basic element of your transformation is the interface. Get to know what are the components of this interface.

Creating an Interface

Objects are necessary to develop projects properly in ODI. Learn how you can make the best use of these objects.

Using Joins, Data Sets, Filters, and Sequences

For some data transformation tasks, it's mandatory to cascade your interfaces by using temp interfaces. In this video, you'll understand how to use these interfaces.

Using Temporary Interfaces and Lookups
Your Data Transformation Strategy – Knowledge Modules
3 Lectures 11:06

You need to adjust KMs so that they fit to your strategy by learning how to adapt them.

Adapting Knowledge Modules to Your Needs

You always need agents for ODI to be able to execute in ODI Interfaces.

Executing Data Transformation in an ODI Interface

Execution locations have huge impacts on transactions. In this video, you will learn how to execute a mapping on other locations.

Executing a Mapping on Your Source
Workflows in ODI
4 Lectures 19:08

You need to execute a process which contains dependencies by learning how to create a workflow in ODI.

Creating a Workflow in ODI

Reusability is needed especially if you have a recurring task. Procedures help you with this.

Reusable Workflows: Procedures

If you need to have enhancements to your KMs, user functions can be really useful. Learn how to use them.

User Functions as Useful Functions

The function of one use case should differ from another use case. This is where customization comes into action.

Customize Development Objects in ODI
Data Quality and Delta Detection
4 Lectures 15:08

DQ is very important and in this video you will learn how to use different data quality tools.

Oracle Data Quality Products

Get to know how to use data integrity controls and how you can embed data quality in ODI with the help of packages.

Using Data Integrity Controls and Integrating Data Quality in ODI

Understand how to run EDQ with the help of an example.

Preview 02:54

Learn how to load only delta, which is the data that is changed in ODI.

Delta Detection via CDC
Version Management and Deployment
4 Lectures 13:06

All the ODI versions are stored in the master and the actual version is stored in the work repository. In this video, we will see what can be versioned in ODI.

Version Management

Smallest deployment units are scenarios. In this video, you'll learn what can be deployed to become a scenario.

Preview 04:02

Dependencies between different ODI objects need to be resolved. We'll see how "Solutions", which are release bundles, can be used to resolve this.


How do you do that in ODI?

Export and Import
Operating and Maintenance
3 Lectures 12:51

Sometimes you have load dependencies, for which you need to know how to use loadplans to build the process for loading data.


Some of the ODI metadata is not displayed in the GUI, but you can get it from the ODI repository tables.

ODI Repository Tables

In ODI, you can grant generic or nongeneric privileges. Get to know how you can do this.

Additional Supporting Functions
3 Lectures 11:11

Many of the tasks in ODI are recurring. Learn how you can use some scripting in ODI to generate similar objects.

Preview 04:29

To estimate future changes, impact and data lineaging is important. Know how this is done.

Impact and Data Lineaging

ODI Studio is the main place where ODI developers work. Familiarize yourself with its additional features.

ODI Studio Enhancements
About the Instructor
Packt Publishing
3.9 Average rating
8,109 Reviews
58,391 Students
686 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.