Oracle ODI Online Training

ODI Training covers advanced methods for using Oracle Data Integrator 11g (ODI).By availing the online training from the Tysco Online Trainings participants will learn the process to implement high-performance movement and conversion of data amidst for the different platforms. The entire course is coordinated by the best subject experts & the course tutorials are made with latest industry updates. ODI Training stands for Oracle Data Integrator. Oracle ODI Online Course is rendered by the good subject matter experts & the tutorials prepared by these expert industry allied tutors are made with latest industry updates. Classes are available for the individual as well as for corporate batches on demand. Call the help desk for the more information for online ODI training’s and its details.

ODI Online Training Overview:

Oracle data integration Training employs the unique abstract load and transform technology that improve performance and reduce data integration supports heterogeneous sources. Active integration enables data warehousing and operational data hubs. Maximize the developer productivity and minimize the implementation time through declarative design. It allows the ELT architecture to increase performance and decrease TCO. Metadata navigator is a servlet application enables the access to repository through a web interface. Advanced encryption standard can be used for encrypting knowledge. Oracle ODI training teach how to discover modular repository that can be installed on database engine supports ANSI ISO 89 syntax.

ODI Online training which comprises of the XML drivers enhancements, FIPS compliance and packages. The key feature of the course is planning and relevant interactions with the students, emphasis on learning objectives and implement in real-time scenarios helps to leverage technology. Instructor led personalized virtual training accelerate the learning approach and focused on exploring the path of skills of every student by delivering applied live project support.

Prerequisites for ODI Online Training:

  • Basic knowledge of ELT data processing

Course Objectives for ODI Training:

  • Describe Oracle Data Integrator Model concepts
  • Describe architecture of Oracle Data Integrator 11gApply ODI Topology concepts for data integration
  • Design ODI Interfaces, Procedures, Packages, and Load
  • Plans to perform ELT data transformations
  • Explore, audit data, and enforce data quality with ODI
  • Administer ODI resources and setup security with ODI
  • Implement Changed Data Capture with ODI
  • Use ODI Web services and perform integration of ODI with SOA

ORACLE ODI ONLINE COURSE CONTENT

INTRODUCTION TO ODI TRAINING

  • 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

CURRICULUM_MODULE 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

CURRICULUM_MODULE ODI TRAINING 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

CURRICULUM_MODULE 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

CURRICULUM_MODULE 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

CURRICULUM_MODULE ODI TRAINING 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

CURRICULUM_MODULE 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
CURRICULUM_MODULE 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

CURRICULUM_MODULE 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

CURRICULUM_MODULE 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

CURRICULUM_MODULE USING ODI TRAINING PROCEDURES

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results

CURRICULUM_MODULE 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

CURRICULUM_MODULE MANAGING ODI TRAINING 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

CURRICULUM_MODULE 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

What is Oracle ODI?

Oracle Data Integrator (ODI) is  – product from Sunopsis acquired by the Oracle in 2006. ODI is built on E-L-T (Extract , Load & a Transform) Architecture. Oracle Data Integrator 10g (10.1.3.5.0) suite includes three types products, Oracle Data Integrator, Oracle Data Quality & Oracle Data Profiling. Oracle Data Integrator Enterprise Edition (ODIEE) is a combination of ODI (Oracle Data Integrator) and OWB(Oracle Warehouse Builder).

Oracle ODI Online Course gives widely used data integration of a software product, Oracle Data Integrator provides an new declarative design approach to defining data transformation & a integration processes, resulting in faster & a simpler development and maintenance. Based on the unique E-LT architecture (Extract – Load Transform), Oracle Data Integrator not only guarantees in the highest level of performance possible for a execution of data transformation & a validation processes but is also the most cost-effective solution for available today. Oracle Data Integrator employs an powerful declarative design approach to the data integration, which separates the declarative rules from a implementation details..

ODI Training outline:

  • Course Name: Oracle ODI Online course
  • Duration of the Module:  35 Hours
  • Mode of training : Online virtual classes and corporate
  • Timings: According to one’s feasibility
  • System Access : will be provided
  • Batch Type: Regular , weekends and fast track
  • Trainees will get the soft copy material.
  • Sessions will be conduct through WEBEX, GOTOMEETING OR SKYPE.
  • Basic Requirements: Good Internet Speed, Headset

Advantages upon enrolling with Tysco Online Trainings

  • We are the best ODI training providers
  • we will give you the assurance for back-up sessions.
  • The timings will be according to the candidate feasibility.
  • As our trainers are real time experts they will help you in giving training at very high level for real time projects.
  • Our Consultant will help you in preparing the resume and certifications
  • Tysco Online Trainings Team will be in switch on mode for 24/7 and will solve any issues regarding the training, timings, trainer or server.
    We are ready to solve any issues with in no time.