Oracle Data Integrator (ODI) 12c Developer Course at UDEMY Overview
Duration | 13 hours |
Total fee | ₹2,499 |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Student Reviews
Oracle Data Integrator (ODI) 12c Developer Course at UDEMY Highlights
- Certificate of completion
- 6.5 hours on-demand video
- 5 articles
- 2 downloadable resources
- Access on mobile and TV
- 30-Day Money-Back Guarantee
- Full Lifetime Access
Oracle Data Integrator (ODI) 12c Developer Course at UDEMY Course details
- This course is for aspirants who wants to become ODI developer
- Manager who wants to understand ODI development
- Project Managers who wants to understand and plan ODI development
- 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
- 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
Oracle Data Integrator (ODI) 12c Developer Course at UDEMY Curriculum
Welcome
Introduction
Why Data Integrator?
Quiz: ODI Basics
ODI Architecture
Development Process Flow
ODI Data Flow Architecture
ODI Repositories
ODI Agents
Quiz: Architecture
ODI 12c Virtual Box
ODI 12c VM-Introduction
Oracle Virtual Box
7zip download
ODI 12c Virtual Appliance
VM Network Configuration
Sharing folder between Host Machine and Virtual Machine
Start ODI 12c VM
ODI Studio
ODI Studio -Introduction
ODI Studio- Introduction, Model & Mapping
ODI Studio-Procedure
ODI Studio-Package
Quiz: ODI Studio
Project 1: Customer Data Integration
Project 1: Introduction and Importing Flat Files
Project1- Lookup
Project1-Join
Project1-Target Expression
Project1-Event Based Target Expression
Project1-Knowledge Modules
Quiz: Mapping
Project 2- Sales Data Integration
Project2-Introduction
Project2-Filter
Project2-Aggregate
Project2-Knowledge Modules
Project3: Data Quality Control
Data Quality Control- Introduction
Data Quality Control - Implementation
Project 4: Package and Scenario
Package
Scenario
Package and Scenario
Scenario Scheduling
Schema Upgrade (optional)
Standalone Agent
Logical Agent
Scenario Scheduling
Project 5: ODI Variables
Introduction-ODI Variable
Create FTP Server
Create ODI Variables
Create Package with Variable
Variable as Scenario Parameter
Project 6: Complex File
Complex File: Introduction
Data flow from complex file to data store
XML Schema Definition (XSD)
Physical and Logical Schemas
How to Unhide Technology in Topology
Reverse Engineer XML Schema Tables
Review Model Data
Project 7: Knowledge Module Customization
Built-in Knowledge Modules
Knowledge Module Usage
Substitution API & Substitution Method
Create Knowledge Module
Quiz: Knowledge Modules
Project 8: Change Data Capture & Journalizing Knowledge Module
Welcome to CDC and JKM
CDC and JKM Explanation-1
Change Data Capture Subscribers
Enabling Change Data Capture
Enable CDC and Journalizing on Model and Table
Data Flow in CDC
CDC Quiz
Project9: ODI and Web Services (REST API)
Welcome to section
Restful Services
ODI with Hadoop Big Data
Big Data Introduction
Big Data and ODI
Big Data Lite Virtual Appliance
Project Introduction
Start Services
HIVEQL through SQL Developer
HIVE Technology in ODI Topology
ODI Mapping with Data from Hadoop
Project 10: Load Plan
ODI Load Plan Introduction
Load Plan Creation
Load Plan Execution Monitor
Component Migration
ODI Component Migration Introduction
Export the components from source instance
Import in Target Instance
Completion
Congratulations!!
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?