3 Day Oracle Data Integrator (ODI) Developer

Request more details:

submit request
This course is for developers who wish to gain a practical and comprehensive understanding of how use the newest Oracle ELT tool: Oracle Data Integrator, formerly known as Sunopsis.
Delegates should have some experience with databases, SQL and ETL technologies.
Course Objectives:
This 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 covers different Database Technologies: Oracle and MS Access, as well as Flat Files and XML sources and targets.
Product Overview :
• ODI product architecture
ODI repositories
Oracle Enterprise Manager
• ODI key concepts
Execution Contexts
Knowledge Modules
Packages and Scenarios
Using Variables :
• Defining variables
Variable location and scope
Variable definitions
Refreshing variables
Variable history
• Using variables for dynamic information
Assigning a value to a variable
Referencing variables
Variables in interfaces
Variables in models
Variables in topology
• Using variables to alter workflows
Load Plans
ODI Sources, Targets, and Knowledge Modules :
• Defining Physical Schemas, Logical Schemas, and Contexts
Defining physical data servers
Defining Physical Schemas
Defining Logical Schemas and Contexts
Non-database technologies
• Reverse-engineering metadata into ODI models
Standard reverse-engineering
Custom reverse-engineering
File reverse-engineering
XML reverse-engineering
• Examining the anatomy of the interface flow
Example 1: Database and file to database
Example 2: File and database to second file
Example 3: File to Enterprise Application
• Importing and choosing Knowledge Modules
Choosing Knowledge Modules
Importing a Knowledge Module
KMs—A quick look under the hood
Configuring behavior with KM options
• Examining ODI Interfaces
Overview tab
Mapping tab
Flow tab
Quick-Edit tab
Working with Databases (Oracle):
• Sample scenario description
Integration target
Integration source
Integration mappings
Data flow logistics
• Building the Load_Customer interface
Building the topology
Reverse-engineering the model metadata
Moving the data using an ODI interface
Checking the execution with the Operator Navigator
Working with Microsoft Access :
• Overview of the task
Integrating the Sales data
• Sample scenario
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
Integrating File Data :
• Working with flat files
Prerequisites for flat files
Integrate the file data into an Oracle table
Partner data target, source, and mappings
Partner interface flow logistics
• Step-by-step example
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
• Writing to Flat Files
Creating an interface that writes the result to a Flat File
Working with XML Files :
• Introduction to XML
Introducing the ODI JDBC driver for XML
ODI and its XML driver—basic concepts
• Example: Working with XML files
Requirements and background
• Scope
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 Workflows—Packages and Load Plans :
• Packages
Creating a package
Adding steps into a package
Adding tools in a package
Best practice: No infinite loop
Generating a scenario from a package
• Load Plans
Serial and parallel steps
Objects that can be used in a Load Plan
Exception handling
• Using Packages and Load Plans
Error Management :
• Managing data errors
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
• Managing execution errors
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
• Handling operational errors