Wednesday, July 24, 2013

Oracle Data Integrator Concepts



ODI  High Level Objectives:
Ø  Overview of the architecture of the complete Oracle Data Integrator system
Ø  Define the Information System architecture
Ø  Get started with projects in Oracle Data Integrator and release your work for deployment
Ø  An overview of models, reverse-engineering model metadata from your database, and how and why to flesh out models with missing metadata
Ø  Manage metadata in Oracle Data Integrator: models and data quality
Ø  Create simple interfaces and add multiple sources to an interface
Ø  Launch a session to run an interface
Ø  Enforce data quality constraints in an interface
Ø  Manage packages
Ø  Add more advanced integration components
Ø  Customize data flow and get the best performance out of your system
Ø  An overview of sessions, use Operator to monitor, stop and start sessions, and basic troubleshooting.
Introduction : 
Ø  Identifying the Course Content
Ø  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
Installations & Configurations :
Ø  Oracle 11G Database.
Ø  ODI 11G
Ø  Weblogic Server 11G
Ø  Configurations
Administering 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
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
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
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
Oracle Data Integrator 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
Organizing ODI Models and Creating Data stores : 
Ø  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
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
Designing Interfaces :
Ø  Designing an Interface
Ø  Multiple Source Data stores
Ø  Creating Joins
Ø  Filtering data
Ø  Disabling Transformations
Ø  Overview of the Flow
Ø  Specifying the Staging Area
Ø  Selecting Knowledge Modules
Interfaces: Monitoring and Debugging :
Ø  Monitoring Interfaces
Ø  Using Operator
Ø  Viewing Sessions and Tasks
Ø  How to Monitor Execution of an Interface
Ø  How to Troubleshoot a Session
Ø  Keys to Reviewing the Generated Code
Ø  Working with Errors
Ø  Tips for Preventing Errors
Designing Interfaces: Advanced Topics : 
Ø  Using Business Rules in Interfaces
Ø  Overview of Business Rule Elements
Ø  Using variables
Ø  Using User Functions
Ø  Using Substitution Methods
Ø  Modifying a KM
Ø  Developing Your Own KM
Ø  Using RKM for Customized Reverse Engineering
Using ODI procedures : 
Ø  What is a Procedure?
Ø  Examples of Procedures
Ø  Creating Procedures
Ø  Adding Commands
Ø  Adding Options
Ø  Running a Procedure
Ø  Using Operator to View Results
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
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
Enforcing Data Quality and Auditing Data with ODI :
Ø  Why Data Quality?
Ø  When to Enforce Data Quality?
Ø  Data Quality in Source Applications
Ø  Data Quality Control in the Integration Process
Ø  Data Quality in the Target Applications
Ø  Enforcing Data Quality
Ø  Exploring Your Data
Ø  Auditing Data Quality
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
Administering ODI Resources: Advanced Topics :
Ø  Using Open Tools
Ø  Installing Open Tools
Ø  Using Open Tools in a Package
Ø  Using Open Tools in a Procedure or in a KM
Ø  Developing Your Own Open Tools
Ø  Setting Up ODI Security
Ø  Defining Security Policies
Ø  Defining Password Policies