Oracle ODI
( Duration: 5 Days )COURSE AGENDA
1
Introduction to Oracle Data Integrator
- What is Oracle Data Integrator?
- Why Oracle Data Integrator?
- Overview of ODI 11g Architecture
- Overview of ODI 11g Components
- About Graphical Modules
- Types of ODI Agents
- Overview of Oracle Data Integrator Repositories
2
Administrating ODI Repositories and Agents
- Administrating the ODI Repositories
- Creating Repository Storage Spaces
- Creating and Connecting to the Master Repository
- Creating and Connecting to the Work Repository
- Managing ODI Agents
- Creating a Physical Agent
- Launching a Listener
- Scheduler and Web Agent
- Example of Load Balancing
3
ODI Topology Concepts
- Overview of ODI Topology
- About Data Servers and Physical Schemas
- Defining the Physical Architecture
- Defining the Logical Architecture
- Mapping Logical and Physical Resources
- Defining Agents
- Defining a Topology
- Planning the Topology
4
Describing the Physical and Logical Architecture
- Overview of Topology Navigator
- Creating Physical Architecture
- Creating a Data Server
- Testing a Data Server Connection
- Creating a Physical Schema
- Creating Logical Architecture
- Overview of Logical Architecture and Context Views
- Linking the Logical and Physical Architecture
5
Setting up a New ODI Project
- Overview of ODI Projects
- Creating a New Project
- Using Folders
- Organizing Projects and Folders
- Understanding Knowledge Modules
- Exchanging ODI Objects
- Exporting and Importing Objects
- Using Markers
6
ODI Model Concepts
- What is a Model?
- Understanding Metadata in ODI
- Understanding Reverse Engineering
- Creating Models
- Organizing Models
- Creating Data stores
- Using Constraints in ODI
- Creating Keys and References
7
Organizing ODI Models and Creating Data Sources
- What is an Interface?
- Business Rules for Interfaces
- What is a Mapping?
- What is a Join?
- What is a Filter?
- What is a Constraint?
- What is a Staging Area?
- Creating a Basic Interface
8
ODI Interface Concepts
- What is an Interface?
- Business Rules for Interfaces
- What is a Mapping, Filter, Join?
- Overview of Integration Process
- What is a Staging Area?
- About Execution Location
- Using Knowledge Modules (KM) with ODI Interface
- Creating a Basic Interface
9
Designing Interfaces in ODI
- Designing an Interface
- Multiple Source Data stores
- Creating Joins
- Filtering data
- Disabling Transformations
- Overview of the Flow
- Specifying the Staging Area
- Selecting Knowledge Modules
10
Interfaces : Monitoring and Debugging
- Monitoring Interfaces
- Using Operator
- Viewing Sessions and TasksHow to Monitor Execution of an Interface
- How to Troubleshoot a Session
- Keys to Reviewing the Generated Code
- Working with Errors
- Tips for Preventing Errors
11
Using ODI Procedures
- What is a Procedure?
- Examples of Procedures
- Creating Procedures
- Adding Commands
- Adding Options
- Running a Procedure
- Using Operator to View Results
12
Using ODI Packages
- What is a package?
- Creating a package
- Executing a package
- Creating Advanced Packages
- Error handling
- Controlling an Execution Path
- Creating a Loop
- Using the Advanced tab
13
Managing ODI Scenarios and Versions
- What is a Scenario?
- Managing Scenarios
- Preparing Scenarios for Deployment
- Automating Scenario Management
- Scheduling the ODI Scenario
- Overview of ODI version management
- Using Version Browser and Version Comparison Tool
- Handling concurrent changes
14
Using Web Services in ODI
- Web Services in Action
- Using Data Services
- Setting Up Data Services
- Testing Data Services
- Installing Public Web Services
- Using Public Web Services
- Invoking Web Services
Encarta Labs Advantage
- One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
- All courses are delivered by Industry Veterans
- Get jumpstarted from newbie to production ready in a matter of few days
- Trained more than 50,000 Corporate executives across the Globe
- All our trainings are conducted in workshop mode with more focus on hands-on sessions
View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php
Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.
Notice
X