Oracle Data Integrator Essentials

Develop, deploy, and maintain your own data integration projects with a clear view of Oracle Data Integrator essentials

Last updated 2022-01-10 | 3.7

- 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

What you'll 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

* Requirements

* 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.

Description

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 this course is for:

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.

Course content

8 sections • 31 lectures

The ODI Core Concepts 6 lectures

Key ODI Concepts Preview 02:53

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

Differentiating between ETL and ELT Preview 01:42

Avoid ETL, let the database work and use ELT.

Exploring the Graphical UI Preview 04:38

Familiarize yourself with the graphical interface of ODI Studio.

ODI Basics Preview 08:00

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

Defining Your Strategy Preview 02:53

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

The ODI Staging Area Preview 04:09

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

Developing in ODI – the Core Objects 4 lectures

Organizing Your Project Preview 03:07

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

Creating an Interface Preview 10:29

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

Using Joins, Data Sets, Filters, and Sequences Preview 04:50

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

Using Temporary Interfaces and Lookups Preview 03:22

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.

Your Data Transformation Strategy – Knowledge Modules 3 lectures

Adapting Knowledge Modules to Your Needs Preview 05:34

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

Executing Data Transformation in an ODI Interface Preview 03:07

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

Executing a Mapping on Your Source Preview 02:25

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

Workflows in ODI 4 lectures

Creating a Workflow in ODI Preview 07:18

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

Reusable Workflows: Procedures Preview 03:53

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

User Functions as Useful Functions Preview 03:32

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

Customize Development Objects in ODI Preview 04:25

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

Data Quality and Delta Detection 4 lectures

Oracle Data Quality Products Preview 05:15

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

Using Data Integrity Controls and Integrating Data Quality in ODI Preview 02:28

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

Running EDQ Preview 02:54

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

Delta Detection via CDC Preview 04:31

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

Version Management and Deployment 4 lectures

Version Management Preview 03:34

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.