Oracle ODI Training

Learn Oracle ODI Training to Unleash a Modern Career

Average Rating 4.2 From 771 Students

Duration : 25 Hours | Lab Sessions : 25 Hours
1353 Students Enrolled
Oracle ODI Training

About Course


Oracle ODI 12c Online Training at SMC is facilitated by certified, experienced professional and real-time expert trainers. It details on how to use Oracle Data Integrator(ODI) to implement high-performance movement and transformation of data among various platforms.

This Oracle ODI Online Training course deals with the usage of ODI graphical user interfaces that enable users to access different ODI components and resources that form ODI infrastructure. This training helps you to create and manage ODI repositories, which stores configuration information about the IT infrastructure.  During the training, you will learn the development of various components in Oracle ODI Topology and understand the difference between Oracle ODI 11g and Oracle ODI 12c.

In this Oracle ODI training course our team would be demonstrating numerous small examples that will help you learn how to create the ODI Topology, organize ODI models and design ODI interfaces. It will help you understand each concept with a practical implementation of Oracle Data Integrator(ODI). Let's get started now !!!

Reasons to choose SM Consultant

Mock Interviews Mock
Interviews
Focused Learning Focused
Learning
Practical Training Practical
Training
Easy Payments Easy
Payments
Lifetime Access Lifetime
Access
Expert Trainers Expert
Trainers
Shareable Certificate Shareable
Certificate
Flexible Timings Flexible
Timings

Upcoming Batch Schedule for Oracle ODI Training

SM Consultant is dedicated to the service of our students. Below mentioned are the timings of our upcoming batches online. If none of these times suit you, you can request to schedule a custom time suitable for you.
FASTTRACK - 3 Hours Session
04 Dec, 2021 - 17 Dec, 2024
01:30 AM
WEEKEND - 2 Hours Session
08 Dec, 2024 - 22 Jan, 2025
01:30 AM
WEEKDAY - 1 Hour Session
12 Dec, 2024 - 06 Jan, 2025
01:30 AM
WEEKDAY - 1 Hour Session
16 Dec, 2024 - 10 Jan, 2025
01:30 AM
WEEKDAY - 1 Hour Session
20 Dec, 2024 - 14 Jan, 2025
01:30 AM
WEEKDAY - 1 Hour Session
24 Dec, 2024 - 18 Jan, 2025
01:30 AM

No Timing Suitable for You ?

Tell Us Your Preferred Starting Date, we will schedule a batch for You!




    Take Oracle ODI Training at your own pace

    Self Paced Online Learning

    The Self Paced format allows you to stream the course content from anywhere across the globe with a good Internet connection. There is no defined schedule, you can watch them at your comfortable time. Get Started.

    Watch Free Oracle ODI Training videos before signing up.



      Instructor Led Live Training

      We deliver Instructor-led online course via your personal computer through an easy-to-use web conferencing tool that allows for real-time interaction between you and the trainer. Get Expert guidance tailored for you.

      Join Free Oracle ODI Training demo session before signing up.



        Oracle ODI Training Course Content

        1. Introduction to Oracle ODI

        • 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 ModulesExchanging 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

        • 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

        Need Customized Course Content?

        We will customize the Oracle ODI Training course content according to your job requirements.



          Certification

          Once you are successfully through the project, you will be awarded an SM Consultant’s Oracle ODI Training Completion Certificate for the course.

          SM Consultant’s certification has industry recognition, and we are the preferred training partner for many organizations.

          Sample Certificate SM ConsultantSM Consultant’s Certificate Holders work at 100s of companies

          Frequently Asked Questions About Oracle ODI Training

          1. When will I receive my joining instructions for Oracle ODI Training?
          Joining instructions for Oracle ODI Training is sent two days prior to the course start date, or immediately if the booking is confirmed within this timeframe.

          2. How are you better than the other classes? Past achievements?
          As they say, “History speaks for itself”, the past achievements would give you a good picture of our reputation, and would also tell you what extra efforts we put in to achieve it.

          3. Do you offer a Oracle ODI Training Demo or Trial class before joining?
          We offer 1 demo classes to students. Just make sure that you select the subject and time of the class so that you get an independent assessment of the quality of teaching and you can take an informed decision.

          4. What’s the batch size? Will I get personal attention?
          An average batch size could be min. 4-5 and max. 8-10 but irrespective of the batch size you will get personal attention and our trainers will help you understand the technology.

          5. What if I am not able to attend or miss a session?
          If you are unable to attend your session we will help you understand the session by sharing the recording of the live session and still if you need more assistance, we will arrange a backup session for you.

          6. Can I access the Oracle ODI Training course material after training?
          Yes, you will get the material in pdf format and will have access to the Oracle ODI Training recordings.

          Have More Questions?

          Do let us know if you need more information we will be happy to help you!




            Enroll Now









              Talk To Expert Right Now
              +91-7799196622

              Trusted By Companies of All Size

              Aditya-Birla-Copper
              Brocade
              CedarCrestone
              Aditya Birla Hindalco
              Ess
              FCS
              KNK
              Logica
              Sais Erp
              Xilinx
              ZylogZSL
              HDFC