"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
ODI repositories
Studio
Agent
Console
Oracle Enterprise Manager
Execution Contexts
Knowledge Modules
Models
Interfaces
Packages and Scenarios
Variable location and scope
Variable definitions
Refreshing variables
Variable history
Assigning a value to a variable
Referencing variables
Variables in interfaces
Variables in models
Variables in topology
Packages
Load Plans
Defining physical data servers
Defining Physical Schemas
Defining Logical Schemas and Contexts
Non-database technologies
Standard reverse-engineering
Custom reverse-engineering
File reverse-engineering
XML reverse-engineering
Example 1: Database and file to database
Example 2: File and database to second file
Example 3: File to Enterprise Application
Choosing Knowledge Modules
Importing a Knowledge Module
KMs—A quick look under the hood
Configuring behavior with KM options
Overview tab
Mapping tab
Flow tab
Quick-Edit tab
Integration target
Integration source
Integration mappings
Data flow logistics
Building the topology
Reverse-engineering the model metadata
Moving the data using an ODI interface
Checking the execution with the Operator Navigator
Overview of the task
Integrating the product data
Integrating inventory data
Adding the MySQL JDBC driver
Expanding the topology
Reverse-engineering revisited
Preparing to move the product data
Using simulation and execution
Moving the inventory data
Overview of the task
Integrating the Sales data
Source
Target
Integrations
Expanding the ODI topology
Setting up the topology
Reverse-engineering the Model metadata
Creating interfaces and mappings
Load Sales Person interface
Load Sales Person mapping
Automatic Temporary Index Management
Load Sales Region interface
Checking the execution with the Operator Navigator
Execute the Load Sales Person interface
Verify and examine the Load Sales Person results
Verify and examine Load Sales Region results
Scope
Prerequisites for flat files
Integrate the file data into an Oracle table
Partner data target, source, and mappings
Partner interface flow logistics
Expanding the topology for file handling
Integrating the Partner data
Creating and preparing the project
Creating the interface to integrate the Partner data
Running the interface
Introducing the ODI JDBC driver for XML
ODI and its XML driver—basic concepts
Requirements and background
Overview of the task
Integrating a Purchase Order from an XML file
Creating models from XML files
Integrating the data from a single Purchase Order
Single order interface flow logistics
Sample scenario: Integrating a simple Purchase Order file
Expanding the Topology
Reverse-engineering the metadata
Creating the Interface
Creating procedures
Creating a package
Adding steps into a package
Adding tools in a package
Best practice: No infinite loop
Generating a scenario from a package
Serial and parallel steps
Objects that can be used in a Load Plan
Exception handling
Detecting and diverting data errors
Data quality with ODI constraints
ODI error table prefix
Contents of an error table
Using flow control and static control
Using error thresholds
Correcting and recycling data errors
Recycling errors and ODI update keys
Handling anticipated errors
Causing a deliberate benign error with OdiBeep
Handling unexpected design-time errors
More detailed error investigation in Operator Navigator
Handling unexpected runtime errors
"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
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.
Our Oracle ODI training course is for ETL Developers who wish to get to know 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
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