All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
3 days left at this price!

This plan includes

  • Limited free courses access
  • Play & Pause Course Videos
  • Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Email & Chat Support
Get Unlimited Learning Access
$29
3 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • Gain expertise in Oracle Data Integrator (ODI) and its architecture
  • Master the use of variables, packages, and workflows for effective data integration
  • Learn to work with diverse databases, including MySQL, Microsoft SQL Server, Oracle Database
  • Understand handling flat files and integrating file data in ODI
  • Learn to work with Slowly Changing Dimension (SCD) techniques in ODI
  • Explore real-time ETL through Change Data Capture (CDC) and Oracle GoldenGate
  • Acquire practical skills for building ETL mappings, monitoring operations, using ODI for comprehensive data integration

The "Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration" course is designed for individuals aspiring to excel in data integration and ETL processes. Throughout the course, participants will explore ODI's robust features, enabling them to create and manage ETL mappings efficiently. They will learn to define schemas, work with contexts, and reverse-engineer metadata into ODI models. Practical demonstrations will cover variable usage, package creation, and working with Knowledge Modules (KMs) for optimized data processing.

The course includes a detailed exploration of working with specific databases such as MySQL, Microsoft SQL Server and Oracle Database, along with integrating file data seamlessly. Participants will master the intricacies of creating workflows, including packages and load plans, ensuring streamlined ETL processes. Furthermore, the course provides a comprehensive understanding of Slowly Changing Dimensions (SCD), a crucial aspect of data warehousing.

A key focus is on real-time ETL using Change Data Capture (CDC) and Oracle GoldenGate. Participants will gain hands-on experience with CDC configurations and leveraging Oracle GoldenGate for real-time data replication. This comprehensive curriculum ensures that learners develop a proficiency in orchestrating end-to-end ETL processes, making them adept in data integration tasks across diverse database environments. Upon completion, participants will possess the skills to implement efficient and real-time data integration solutions, positioning them as valuable professionals in the realm of data management and analytics.

  • Basic knowledge of databases and SQL
  • Familiarity with data integration concepts
  • Understanding of ETL (Extract, Transform, Load) processes
  • Access to a computer with Oracle Data Integrator (ODI) installed (Optional)
  • Basic understanding of Oracle GoldenGate concepts
  • Access to relevant databases for hands-on exercises
  • Database developers and administrators seeking to master Oracle Data Integrator (ODI) for comprehensive ETL and data integration
  • Data engineers and integration professionals looking to enhance their skills in real-time data movement and replication
  • Business intelligence professionals or data architect aiming to leverage ODI for efficient data warehousing solutions
  • Data Engineer interested in mastering Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) techniques
  • Data Engineer aspiring to implement real-time ETL using Oracle GoldenGate in conjunction with ODI
  • Students and professionals aiming to advance their careers in data management and integration
View More...
  • Section 1 : Introduction 2 Lectures 00:04:30

    • Lecture 1 :
    • Lecture 2 :
    • Materials
  • Section 2 : Introduction to Oracle Data Integrator (ODI) 16 Lectures 01:08:20

    • Lecture 1 :
    • Data integration usage scenarios
    • Lecture 2 :
    • ODI Product Overview
    • Lecture 3 :
    • ODI product architecture - Part 1
    • Lecture 4 :
    • ODI product architecture - Part 2
    • Lecture 5 :
    • ODI product architecture - Part 3
    • Lecture 6 :
    • ODI Studio - Part 1
    • Lecture 7 :
    • ODI Studio - Part 2
    • Lecture 8 :
    • ODI Agent
    • Lecture 9 :
    • WebLogic Enterprise Manager
    • Lecture 10 :
    • Execution Context - Part 1
    • Lecture 11 :
    • Execution Context - Part 2
    • Lecture 12 :
    • Knowledge Modules
    • Lecture 13 :
    • Models
    • Lecture 14 :
    • Mappings
    • Lecture 15 :
    • Packages & Scenarios
    • Lecture 16 :
    • Connect to Repository
  • Section 3 : Mastering Variables and Packages 6 Lectures 00:15:00

    • Lecture 1 :
    • Variable location and scope
    • Lecture 2 :
    • Refreshing variables
    • Lecture 3 :
    • Assigning a value to a variable
    • Lecture 4 :
    • Referencing variables
    • Lecture 5 :
    • Variables in models
    • Lecture 6 :
    • Variables utilization in Package
  • Section 4 : ODI Sources, Targets, and Knowledge Modules 10 Lectures 00:30:02

    • Lecture 1 :
    • ODI Sources, Targets, and Knowledge Modules
    • Lecture 2 :
    • Defining physical data servers
    • Lecture 3 :
    • Defining Physical Schemas (Data Sources)
    • Lecture 4 :
    • Defining Physical Schemas (Target Data Source)
    • Lecture 5 :
    • Defining Logical Schemas and Contexts
    • Lecture 6 :
    • Reverse-engineering metadata into ODI models
    • Lecture 7 :
    • Reverse-engineering metadata into ODI models -Example
    • Lecture 8 :
    • Custom reverse-engineering
    • Lecture 9 :
    • Knowledge Modules Using Example
    • Lecture 10 :
    • Detail Importing a Knowledge Module
  • Section 5 : Working with Databases 4 Lectures 00:16:35

    • Lecture 1 :
    • Topology configuration - Data Server, Schema, Model Reverse Engineering
    • Lecture 2 :
    • Create project & Do ODI Mappings
    • Lecture 3 :
    • Perfom moving the data using an ODI Mappings
    • Lecture 4 :
    • Monitor ODI Mappings process
  • Section 6 : Working with Specific Databases 10 Lectures 00:31:22

    • Lecture 1 :
    • Source MySQL Table example
    • Lecture 2 :
    • Create Data Server on Source and Target
    • Lecture 3 :
    • Physical Schema, Logical Schema
    • Lecture 4 :
    • Reverse Engineering Models
    • Lecture 5 :
    • Mappings
    • Lecture 6 :
    • Monitor Mappings running process - Operator Navigator
    • Lecture 7 :
    • MSSQL Database Loading by using ODI
    • Lecture 8 :
    • MSSQL Loading Monitor - Operator Navigator
    • Lecture 9 :
    • File Loading by using ODI - Topology Configuration
    • Lecture 10 :
    • File Loading by using ODI - Mapping Running and Monitoring
  • Section 7 : Creating Workflows 1 Lectures 00:08:27

    • Lecture 1 :
    • Packages and Load Plans - Mastering Workflows
  • Section 8 : ODI ETL with SCD table 3 Lectures 00:11:46

    • Lecture 1 :
    • SCD Configuration
    • Lecture 2 :
    • SCD Mapping
    • Lecture 3 :
    • SCD Running and Monitoring
  • Section 9 : Real-time ETL with CDC and OGG 9 Lectures 00:41:17

    • Lecture 1 :
    • Oracle GoldenGate Overview
    • Lecture 2 :
    • Oracle GoldenGate Example with Core Banking System
    • Lecture 3 :
    • Oracle GoldenGate Commands
    • Lecture 4 :
    • Oracle GoldenGate - Demo Extract Process
    • Lecture 5 :
    • Oracle GoldenGate - Demo Pump Process
    • Lecture 6 :
    • Oracle GoldenGate - Demo Replicate Process
    • Lecture 7 :
    • Oracle GoldenGate - Results
    • Lecture 8 :
    • ODI CDC
    • Lecture 9 :
    • ODI CDC Realtime Movement
  • Section 10 : Summary session 1 Lectures 00:03:36

    • Lecture 1 :
    • Recap – what have you learned
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

6545 Course Views

8 Courses

I am an experienced and accomplished author with a deep passion for data strategy and management. With over 15 years of hands-on experience in the IT industry, I have gained extensive knowledge and expertise in various domains, including banking, insurance, retail, and more. Throughout my career, I have held several senior positions such as: - Data Division Director of an insurance company - Deputy Data Governance & Analytics of the Group (Real Estate, Retail, Hospitality, Commerce, ...) - Deputy Chief Data Officer cum Senior IT Strategy Expert - Head of Data & Analytics Service - Project Director/ Project Manager - Enterprise & Solution Architect of bank That have allowed me to make significant contributions to the field. And right now, as a director of Data Division, I played a pivotal role in shaping data initiatives and driving the effective use of data within organizations. Additionally, as a Data Governance & Analytics expert, I focused on establishing robust data governance frameworks and harnessing the power of analytics to drive actionable insights. With my diverse background and extensive industry experience, I have developed a strong understanding of the challenges and opportunities in the data management landscape. Through my work as an author, I am dedicated to sharing my knowledge, insights, and practical strategies with students like you.
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • big-data-pipeline-applied-to-ufos

    Big Data Pipeline Applied to UFOs

    By : Eduardo Morelli

    Lectures 6 Beginner 0:16:47
  • git-and-github-version-control-the-complete-startup-guide

    Git and GitHub Version Control - Th...

    By : Abhilash Nelson

    Lectures 15 Beginner 1:34:6
  • statistics-for-data-scientists-and-data-analysts

    Statistics for Data Scientists and ...

    By : Phikolomzi Gugwana

    Lectures 31 Intermedite 0:36:49
  • big-data-and-hadoop

    Big Data and Hadoop

    By : Saheb Singh chaddha

    Lectures 26 Beginner 0:1:29
  • technical-writing-how-to-write-software-documentation-using-dita-xml

    Technical Writing: How to Write Sof...

    By : Jordan Stanchev

    Lectures 21 Beginner 3:35:45
  • apache-nifi-the-complete-guide-part-1

    Apache NiFi - The Complete Guide (P...

    By : Manoj G T

    Lectures 19 Beginner 1:23:18

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.