LIVE Instructor-Led Courses
Dismiss

Oracle ODI Development - Advanced training course

Attend An Advanced Oracle ODI Developer Course - Learn to Develop Applications Within Your Data Integration Installation

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

15/04/24 - 3 days
£1900 +VAT
27/05/24 - 3 days
£1900 +VAT
08/07/24 - 3 days
£1900 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

  • Product Installation
  • Developing ODI Knowledge Modules
  • Designing Advanced Integration Interfaces
  • Using variables
  • Using Groovy in ODI
  • Using Complex Files
  • Working with Changed Data Capture
  • Selecting Integration Strategies
  • ODI and Big Data

 

Developing ODI Knowledge Modules

    Overview of Different Types of KMs

    Guidelines for KM Developers

    Working with Substitution Methods

    Applying Various ODI Tags

    Implementing Java in KMs

    Troubleshooting and Debugging KMs

 

Designing Advanced Integration Interfaces

    Designing Integration Interfaces: E-LT and ETL - Style Interfaces

    Selecting LKM and Mono-Connection (Single Technology) IKM

    Applying Best Practices for Integration Interfaces Design

    Designing Temporary Interfaces

    Implementing Lookups

    Combining Multiple Datasets

    Using Set-Based Operators

    Partitioning ODI Datastores

 

Using variables

    Describing a Variable's Scope

    Inserting Variables in Object Properties

    Using Variables within Variables

    Defining Variables in the Resource Name of a Datastore

    Applying Variables in Topology Objects

    Setting Variables as Start Up Parameters

    Tracking Variables

 

Using Groovy in ODI

    Interacting Programmatically with ODI

    Overview of ODI SDK

    Introduction to Groovy

    Using Groovy Editor

    Automating Development Tasks with Groovy

 

Using Complex Files

    What are Complex Files

    Determining Technical Requirements for Complex Files Project

    Applying nXSD Schema: an Example

    Setting up the Topology for Complex Files

    Creating and Reverse-Engineering a Complex Files Model

    Designing an Interface with Complex Files

 

Working with Changed Data Capture

    Overview of ODI version management

    Techniques of Changed Data Capture

    Changed Data Capture in ODI

    CDC Strategies and Infrastructure

    CDC Consistency

    Using CDC

    Viewing Data/Changed data

    Using Journalizing

 

 

Selecting Integration Strategies

    Loading and Integration Patterns

    Selecting Staging Area Location

    Working with Slowly Changing Dimensions (SCD)

    Working with Changed Data Capture

    Using ODI with Oracle GoldenGate

 

ODI and Big Data

    Describe Big Data concepts

    Contrast Hadoop, NoSQL, Apache, Hive, HBase, HDFS

    Implement ODI mapping for Big Data to Oracle SQL

 

JBI training course London UK

This course is for ETL Developers who already know ODI, but wish to extend their knowledge of the this tool.

5 star

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



This Oracle ODI training course is for ETL Developers who wish to extend their understanding of ODI.  This course will cover the product architecture and practical use of the Tool, so you can hit the ground running when you start using the product after the course. The course can be tailored to cover different Database Technologies: Oracle, MySQL and SQLServer, as well as Flat Files and XML sources and targets.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course