Mô tả

Join the most comprehensive and popular Oracle Data Integrator (ODI) 12c Developer Course on Udemy, because now is the time to get started!

From basic concepts about Data Integration, IntelligenceArchitecture, ODI  Components, Project Development to Migration and Support, this course covers it all you need to know to become a successful ODI Developer

But that's not all! Along with covering all the steps of ODI developer functions, this course also has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry-standard batch integration in Oracle Data Integrator.

This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!

Why ODI?

Oracle Data Integrator (ODI) is the integration tool every enterprise need. The key technical capabilities like

  • Extract-Load-Transform (ELT) approach, 

  • Near real-time data integration capability through Change Data Capture(CDC), 

  • Declarative design with fully modifiable Knowledge Modules, 

  • SOA capable through web-services

  • Integration of structured as well as unstructured data

exists only in ODI. It's Oracle's flagship, High-performance bulk data movement and transformation tool. Oracle is investing a lot in this tool.

  • ODI is a built-in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tools with ODI.

  • The Extract-load-transform(ELT) approach of ODI with a knowledge module based modular approach makes it the most complete and scalable batch integration tool.

If you are looking for a thriving career in data integration and analytics, this is the right time to learn ODI.

Get a very deep understanding of ODI Developer activities

Every new ODI version is coming with added features. The success of ODI implementation and its performance depends on the ODI developer. 

Pay once, benefit a lifetime! This is an evolving course! ODI12c development and later future versions will be covered in this course.  You won’t lose out on anything! Don’t lose any time, gain an edge, and start now!

Bạn sẽ học được gì

From basic concepts to advanced level ODI hands-on projects.

ODI Development Lifecycle from real life OID implementation projects.

ODI Architecture. Role of different ODI Components like Repository, Fusion Middleware, Agents. Data, Integration, Information and Intelligence derivation.

ODI 12c Virtual Machine installation.

ODI Studio and it's components: Security, Topology, Designer, Operator.

Implement practice projects.

Projects covering the ODI Lifecycle components.

Integration between Complex file (with XML Schema) and RDBMS.

Customization of built-in knowledge module and development of new knowledge modules.

Real time integration through Changed Data Capture (CDC) and Journalizing (JKM)

JDK, Repository, ODI Domain, Weblogic Server, Node Manager, Standalone Colocated Agent, and JEE Agent on you own machine.

Execute project on ODI installed on your own machine.

Topology for a File System and Oracle Database connection, Reverse engineering the Models, Mapping to transfer data from files to Oracle database tables.

ODI integration with Big Data

ODI components migration through Smart Export and Smart Import

Yêu cầu

  • You should be able to use a PC
  • You should be able to work on operating systems like Windows
  • You should know how to use browser and such operating system tools
  • You should have basic knowledge of SQL and relational database

Nội dung khoá học

18 sections

Welcome

3 lectures
Introduction
06:03
Why Data Integrator?
02:30
Quiz: ODI Basics
3 questions

ODI Architecture

5 lectures
Development Process Flow
03:23
ODI Data Flow Architecture
02:35
ODI Repositories
02:53
ODI Agents
06:22
Quiz: Architecture
2 questions

ODI 12c Virtual Box

7 lectures
ODI 12c VM-Introduction
04:20
Oracle Virtual Box
01:41
7zip download
00:06
ODI 12c Virtual Appliance
06:08
VM Network Configuration
03:08
Sharing folder between Host Machine and Virtual Machine
04:35
Start ODI 12c VM
03:32

ODI Studio

5 lectures
ODI Studio -Introduction
02:20
ODI Studio- Introduction, Model & Mapping
06:40
ODI Studio-Procedure
02:41
ODI Studio-Package
05:43
Quiz: ODI Studio
4 questions

Project 1: Customer Data Integration

7 lectures
Project 1: Introduction and Importing Flat Files
03:47
Project1- Lookup
04:11
Project1-Join
03:50
Project1-Target Expression
04:24
Project1-Event Based Target Expression
03:14
Project1-Knowledge Modules
06:27
Quiz: Mapping
6 questions

Project 2- Sales Data Integration

4 lectures
Project2-Introduction
02:41
Project2-Filter
04:24
Project2-Aggregate
06:32
Project2-Knowledge Modules
06:19

Project3: Data Quality Control

2 lectures
Data Quality Control- Introduction
06:26
Data Quality Control - Implementation
08:11

Project 4: Package and Scenario

3 lectures
Package
09:40
Scenario
04:10
Package and Scenario
2 questions

Scenario Scheduling

4 lectures
Schema Upgrade (optional)
00:32
Standalone Agent
07:38
Logical Agent
01:07
Scenario Scheduling
04:01

Project 5: ODI Variables

5 lectures
Introduction-ODI Variable
06:38
Create FTP Server
07:46
Create ODI Variables
08:18
Create Package with Variable
10:03
Variable as Scenario Parameter
02:18

Project 6: Complex File

7 lectures
Complex File: Introduction
04:13
Data flow from complex file to data store
01:44
XML Schema Definition (XSD)
16:46
Physical and Logical Schemas
02:50
How to Unhide Technology in Topology
00:15
Reverse Engineer XML Schema Tables
06:31
Review Model Data
04:13

Project 7: Knowledge Module Customization

5 lectures
Built-in Knowledge Modules
07:16
Knowledge Module Usage
08:23
Substitution API & Substitution Method
14:20
Create Knowledge Module
07:50
Quiz: Knowledge Modules
1 question

Project 8: Change Data Capture & Journalizing Knowledge Module

7 lectures
Welcome to CDC and JKM
01:41
CDC and JKM Explanation-1
02:34
Change Data Capture Subscribers
01:51
Enabling Change Data Capture
00:43
Enable CDC and Journalizing on Model and Table
13:35
Data Flow in CDC
08:31
CDC Quiz
2 questions

Project9: ODI and Web Services (REST API)

2 lectures
Welcome to section
00:45
Restful Services
16:54

ODI with Hadoop Big Data

8 lectures
Big Data Introduction
07:58
Big Data and ODI
07:53
Big Data Lite Virtual Appliance
04:00
Project Introduction
02:38
Start Services
01:40
HIVEQL through SQL Developer
10:27
HIVE Technology in ODI Topology
01:38
ODI Mapping with Data from Hadoop
07:29

Project 10: Load Plan

3 lectures
ODI Load Plan Introduction
10:22
Load Plan Creation
11:39
Load Plan Execution Monitor
05:41

Component Migration

3 lectures
ODI Component Migration Introduction
01:37
Export the components from source instance
07:16
Import in Target Instance
04:13

Completion

1 lectures
Congratulations!!
00:06

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.