Oracle Data Integrator Odi 12c Developer

Development Process Flow Preview 03:23

This lecture explains the development process flow in ODI. You will understand the components you need to develop.

ODI Data Flow Architecture Preview 02:35

This lecture explains 

• ODI components and how it moves data from source to target
• Knowledge Modules
• Role of ODI Admin in projects

ODI Repositories Preview 02:53

This lecture explains ODI Repository.

• Master Repository
• Work Repository
• Development Repository
• Execution Repository

ODI Agents Preview 06:22

In this lecture you will learn about ODI Agents.

• Role of ODI Agent
• Type of ODI Agents -> Standalone, JEE, Colocated
• Architecture
• Compare and contrast between these agents

Quiz: Architecture

Test your knowledge of ODI Architecture.

ODI 12c VM-Introduction Preview 04:20

This lecture will explain you ODI 12c Virtual Machine.

Oracle Virtual Box Preview 01:41

In this lecture, you will download and install Oracle Virtual box.

7zip download Preview 00:06

In this lecture you will understand how and from where to download 7 zip files.

ODI 12c Virtual Appliance Preview 06:08

In this lecture, you are going to install ODI12c Virtual Appliance!

https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html

VM Network Configuration Preview 03:08

In this lecture, you will enable NAT network on your VM, so that you will be able to connect to the internet through your VM.

Sharing folder between Host Machine and Virtual Machine Preview 04:35

This lecture will show you how to share folder between host machine and virtual machine.

Start ODI 12c VM Preview 03:32

In this lecture you will go through the steps to start the ODI 12c VM and ODI Studio.

ODI Studio -Introduction Preview 02:20

This lecture is introduction to the section on ODI Studio. The lecture explains ODI Studio, it's components and roles using those components.

ODI Studio- Introduction, Model & Mapping Preview 06:40

This lecture explains ODI Studio, Models and Mappings

ODI Studio-Procedure Preview 02:41

In this lecture you will learn about Procedures in ODI Studio.

ODI Studio-Package Preview 05:43

This lecture explains ODI Studio and ODI Package with all the ODI toolboxes in ODI Package.

Quiz: ODI Studio

ODI Quiz testing ODI Concepts

Project 1: Introduction and Importing Flat Files Preview 03:47

In this lecture you will import the flat files SRC_AGE_GROUP and SRC_SALES_PERSON into ODI Repository.

Project1- Lookup Preview 04:11

In this lecture, you will understand what is ODI Mapping and Lookup. You will create ODI Mapping and Lookup.

Project1-Join Preview 03:50

In this lecture, you will understand what is ODI Join and how to create it,

Project1-Target Expression Preview 04:24

In this lecture you will understand what is Target Expression. You will create several target expressions.

Project1-Event Based Target Expression Preview 03:14

In this lecture, you will understand and develop event based target expression.

Project1-Knowledge Modules Preview 06:27

In this lecture, you will understand the role of Knowledge Modules in mapping and change the Knowledge Modules wherever appropriate.

Quiz: Mapping

Test your knowledge of Mapping and it's components like Filters, Lookups, Aggregates, Knowledge Modules and others.

Project2-Introduction Preview 02:41

Welcome to your second project on ODI! In this project you are going to create  Sales Administration data mart which will have sales quantity and amount summarized by customer and product.

Project2-Filter Preview 04:24

In this lecture you will implement ODI filter in you project!

Project2-Aggregate Preview 06:32

In this lecture, you will incorporate ODI Aggregate feature in your project.

Project2-Knowledge Modules Preview 06:19

In this lecture your will review the Knowledge Modules, how data flows through knowledge modules and how to select appropriate knowledge module in your mapping.

Data Quality Control- Introduction Preview 06:26

This lecture explains Data Quality Controls and how they are implemented in ODI. You will understand how to implement data quality control through ODI Constraints like Static Control and Flow Control.

You will understand business requirements behind the project you are going to implement in this section.

Data Quality Control - Implementation Preview 08:11

In this lecture you will implement Condition and Reference type ODI constraints.

Package Preview 09:40

In this lecture you will create ODI Package

Scenario Preview 04:10

In this lecture you will create ODI Scenario.

Package and Scenario

Quiz to test Package and Scenario concepts

Schema Upgrade (optional) Preview 00:32

Before you start installing the Standalone agent you should check whether or not the PROD_STB schema needs an upgrade. Go through the steps in this document. If you skip these steps and your schema needs an upgrade you will encounter a CFGFWK-64219 error in the next lecture.

Standalone Agent Preview 07:38

In this lecture, you will configure a standalone ODI Agent.

Logical Agent Preview 01:07

In this lecture, you will create a logical agent and assign it to a physical standalone agent created in the previous lecture.

Scenario Scheduling Preview 04:01

In this lecture, you will schedule the ODI scenario.

Introduction-ODI Variable Preview 06:38

Welcome to this lecture on ODI Variables. In this lecture you will learn about ODI Variable and project you are going to work on.

Create FTP Server Preview 07:46

This is optional lecture. This lecture will explain you how to install FTP server. You need to go through lecture in case you do not have a ftp server.

Create ODI Variables Preview 08:18

In this lecture you will create ODI Variables, Refresh their value and explore ODI Variable History setting.

Create Package with Variable Preview 10:03

In this lecture you will create package containing ODI variables.

Variable as Scenario Parameter Preview 02:18

In this lecture you will learn how to use ODI variable as parameter to scenario.

Complex File: Introduction Preview 04:13

Welcome to this project, where you will import complex file in ODI. This lecture will take you through a sample complex file and explain you how it is structured. The file contains different sections with data involving different delimiters, terminators, and surrounding characters.

This is going to be a very interesting project!

Data flow from complex file to data store Preview 01:44

In this lecture you will understand how data flows from complex file to ODI data stores. You will understand how data flows from complex file to XM File, XML schema, Relational table and eventually into ODI data store through reverse engineering.

XML Schema Definition (XSD) Preview 16:46

In this lecture you will define the XML Schema (XSD) , which will convert the complex file in XML file with XML tags.

Physical and Logical Schemas Preview 02:50

In this lecture you will create Physical and Logical ODI Schema for the XML Schema.

How to Unhide Technology in Topology Preview 00:15

This lecture shows how to unhide a technology in Topology.

Reverse Engineer XML Schema Tables Preview 06:31

In this lecture you will create ODI Model and reverse engineer the XML schema tables into that model. You will review  hierarchy and relationships among imported tables.

Review Model Data Preview 04:13

In this lecture you will review data in ODI Data stores from Complex file.

Built-in Knowledge Modules Preview 07:16

Welcome to this lecture. It's time to take deeper dive into Knowledge Modules. In this lecture you will learn about key roles played by below knowledge modules.

1. Reverse Engineering Knowledge Module (RKM)
2. Load Knowledge Module (LKM)
3. Integration Knowledge Module (IKM)
4. Check Knowledge Module (CKM)
5. Journalizing Knowledge Module (JKM)
6. Service Knowledge Module (SKM)

Knowledge Module Usage Preview 08:23

In this lecture you will understand 

• How and where the built-in knowledge modules are used. 
• What are knowledge modules options and how change them.

Substitution API & Substitution Method Preview 14:20

In this lecture you will understand substitution API and substitution method used in ODI.

• Learn about java class odiReference and instance odiRef.
• Learn about java methods like odiRef.getTable and others.
• Learn about getTable("L", "INT_NAME", "A") in integration knowledge module

You will also learn about below integration types

• Incremental Update
• Control Append
• Slowly changing dimension

Create Knowledge Module Preview 07:50

In this lecture you will learn how to create new knowledge module.

Quiz: Knowledge Modules

Test your knowledge of ODI Knowledge Modules.

Welcome to CDC and JKM Preview 01:41

Welcome to this section on Change Data Capture (CDC) and Journaling Knowledge Module (JkM).

CDC and JKM Explanation-1 Preview 02:34

In this lecture, you will learn about Change Data Capture (CDC) and Journalizing Knowledge Module (JKM).

Change Data Capture Subscribers Preview 01:51

In this lecture you will learn about CDC subscribers.

Enabling Change Data Capture Preview 00:43

In this lecture, you will note down steps for enabling a table for change data capture (CDC).

Enable CDC and Journalizing on Model and Table Preview 13:35

In this lecture you will

1. Import Journalizing Knowledge Module
2. Create Subscriber
3. Enable Journalizing on Model
4. Add a table to CDC
5. Start Journalizing a table

Data Flow in CDC Preview 08:31

In this lecture you will insert new data in source table and review its replication through CDC and Journalizing in J$ tables and JV$ views.

CDC Quiz

Test your knowledge on Change Data Capture (CDC)

Welcome to section Preview 00:45

Welcome to this section. In this section you will learn how ODI can get data through Web Services.

Restful Services Preview 16:54

In this lecture you are going to get data from Google Finance website through GET Restful Services (REST API).

Big Data Introduction Preview 07:58

In this lecture, you will understand what is Big data and how it is different from other data types based on velocity, volume, and variety.

Big Data and ODI Preview 07:53

In this lecture, you will learn how ODI integrates with Hadoop Big Data using Hive.

Big Data Lite Virtual Appliance Preview 04:00

In this lecture, you will download and import Big Data Lite Virtual Appliance.

Project Introduction Preview 02:38

Introduction of the project you are going to working in this section.

Start Services Preview 01:40

In this lecture, you are going to start HDFS, Hive and Oracle Database services.

HIVEQL through SQL Developer Preview 10:27

In this lecture, you are going to set up SQL Developer to work with Big Data. You will run HIVEQL on SQL Developer and inquire into Big Data tables.

HIVE Technology in ODI Topology Preview 01:38

In this lecture, you will review the Hive technology and JDBC connection details in ODI topology.

ODI Mapping with Data from Hadoop Preview 07:29

In this lecture, you will create a mapping using data sources from Hadoop using Hive.

Load Plan Creation Preview 11:39

In this lecture you will create ODI load plan.

Load Plan Execution Monitor Preview 05:41

In this lecture your will execute and monitor a load plan.

ODI Component Migration Introduction Preview 01:37

In an ODI Implementation project, you will develop components in a development instance, then test developed components in a test instance and finally migrate successfully tested components to the Production instance.

In this section of the course, I take you through the steps of migrating ODI components seamlessly using  Smart Export and Smart Import

Export the components from source instance Preview 07:16

In this lecture, you will learn how to export ODI components from source instance using ODI Smart Export.

Import in Target Instance Preview 04:13

In this lecture, you will learn how to import ODI components in the target instance using ODI Smart Import.

Congratulations!! Preview 00:06

Congratulations, you completed this course!

Considering this as a beginning to your ODI journey. If you have any question, I am just a message away.