Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Oracle Oracle Data Integrator

Oracle Data Integrator (ODI) 12c Developer Course

Oracle Data Integrator (ODI) 12c Developer Course
Rating: 4.2 out of 54.2 (779 ratings)
2,920 students
Created by Sanjay Singh
Last updated 3/2021
English
30-Day Money-Back Guarantee

What you'll learn

  • From basic concepts to advance level ODI knowledge with hands-on practice
  • 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 i.e. Security, Topology, Designer, Operator. Take a deeper dive on Designer and understand how to develop Models, Projects, Mapping, Procedures, Knowledge Modules, Packages and Scenarios in ODI studio. Various ODI toolboxes available during package development is also explained.
  • Implement practice projects.
  • Projects cover the ODI Lifecycle components i.e. Models, Mapping ( with transformation like Lookup, Filters, Joins, Aggregates, Knowledge Modules), Variable, Procedure, Data Quality Controls, Packages, Scenario, Complex Files, Load Plans and other 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)
  • Install ODI with all its components i.e. 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.
  • Project covers Setting up Topology for a File System and Oracle Database connection, Reverse engineering the Models, Creating Mapping to transfer data from files to Oracle database tables.
  • ODI integration with Big Data
  • ODI components migration through Smart Export and Smart Import

Requirements

  • 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

Description

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, Intelligence, Architecture, 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!

Who this course is for:

  • 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

Course content

21 sections • 85 lectures • 7h 40m total length

  • Preview06:03
  • Why Data Integrator?
    02:30
  • Quiz: ODI Basics
    3 questions

  • Preview03:23
  • ODI Data Flow Architecture
    02:35
  • ODI Repositories
    02:53
  • ODI Agents
    06:22
  • Quiz: Architecture
    2 questions

  • ODI 12c VM-Introduction
    04:20
  • 7zip download
    00:06
  • Changes to ODI12c VM
    00:17
  • Install ODI12c Virtual Machine (VM)
    04:15
  • VM Network Configuration
    03:08
  • Sharing folder between Host Machine and Virtual Machine
    04:35
  • Start ODI 12c VM
    03:32

  • Preview02: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: 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

  • Preview02:41
  • Project2-Filter
    04:24
  • Project2-Aggregate
    06:32
  • Project2-Knowledge Modules
    06:19

  • Data Quality Control- Introduction
    06:26
  • Data Quality Control - Implementation
    08:11

  • Package
    09:40
  • Scenario
    04:10
  • Package and Scenario
    2 questions

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

  • Preview06:38
  • Create FTP Server
    07:46
  • Create ODI Variables
    08:18
  • Create Package with Variable
    10:03
  • Variable as Scenario Parameter
    02:18

Instructor

Sanjay Singh
Data and Machine Learning Professional
Sanjay Singh
  • 4.1 Instructor Rating
  • 1,748 Reviews
  • 6,158 Students
  • 12 Courses

Hi, 

I am Sanjay from Sanrusha!

I have a curious mind that keeps me busy exploring possibilities with new technologies.

With more than two decades of IT experience and successful project implementations around the world, teaching is my passion.

When I am not busy consulting big enterprises, I like writing and teaching IT technologies. I feel great to mention that my students are working in Fortune 500 companies.

Enjoy the courses, and I look forward to a wonderful association with you!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.