Course Details

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

CourseOracle Data Integrator Training
Mode of Training Instructor Led Live Online Training
Duration 30 hours
Timings Flexible (Our Rep will work with you on the timings that suits your needs)
Course Material Our Expert Trainer will share you all the necessary course material,  ppts, videos and pdfs
Examples Trainer will cover Real time scenarios during the training
Interview Questions Click here to see the interview questions.
Certification Click here to know about the Oracle Data Integrator Certification
Salary Trends Check here to see the salary trends here.

At the end of the training with Tekslate you will be able to

  • Learn ODI design and how its not the same as other ETL devices
  • Build master and Work archives.
  • Create Agent(ODI’s execution engine) and how to configure agent to meet optimization.
  • Create different objects like Packages,Interface (Mapping),procedure, Models and variables to design a data transformation work flow.
  • Learn how to handle Exceptions in work flow through customizable code and through rich ODI components like Load plans.
  • Customize view of ODI repositories for every user through its Security architecture.
  • How to implement physical and logical architecture and migrate the logical code from development to production environment.
  • Implementation of KMs for different technology and how to customize your own KM to meet complex requirement.
  • Reverse Engineer metadata in ODI for different technology like RDBMS, Files, XML, excel etc.
  • Code optimization techniques to speed up the overall batch process and learns how ODI excels it.
  • Using customize java APIs in different objects of ODI to make code environment independent.
  • Implementation of CDC and SCD in ODI.
  • Learn new features provided in latest 12c version and how it integrates more advanced technology like Big data.

The following Oracle ODI Online Training is meant for the following.

  • SOA Architect
  • Data Warehouse Administrator
  • Database Administrators
  • Data Modelers
  • Business Analysts
  • Technical Consultant
  • Beginers

  • Basic SQL Knowledge.
  • Basic ETL knowledge

Tekslate Classes is the best Online Oracle ODI Trainings classes through staff LED-Online preparing, classroom preparing and through Self-Paced Video learning. Our Oracle ODI Tutorials authority staff will lead you till the finish of the Oracle ODI courses and our pros will help the association and individual students to increase required and commonsense information of each module in Oracle ODI Latest Version. Pivotal Oracle ODI Online Training cloud is set up according to the business measures and desires, everybody can get best profession open doors by taking our Oracle ODI Training’s web based preparing. What’s more, we are likewise giving Oracle ODI preparing with low Oracle ODI pricing cost.

Tekslate Classes give the finest Oracle ODI tutorial videos recordings completely through our Self-Paced Oracle ODI Training Courses. These Oracle ODI Latest Version preparing recordings are sorted out by industry staff educators who have sound learning in the Oracle ODI Latest Version. By taking Online Oracle ODI Online Training’s self-guided preparing you can be prepared the aggregate in foundry training course at your individual pace. Online Oracle ODI video tutorials are incorporated with continuous situations by the skilled staff.

Classes are conducted by Certified Oracle ODI Working Professionals with 100 % Quality Assurance. With an experienced Certified practitioner who will teach you the essentials you need to know to kick-start your career on Oracle ODI. Our training make you more productive with your Oracle ODI Certification Training Online. Our training style is entirely hands-on. We will provide access to our desktop screen and will be actively conducting hands-on labs with real-time projects.

Oracle ODI 12c Training Curriculum

Learning Objectives : Introduction to Oracle Data Integration & Overview of ODI 11g in-depth.

Topics Include : 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.

Practicals Covered : Introduction class to Data Integration & Overview of ODI 11g, Graphical Modules, description ODI Agents & Overview of Oracle Data Integrator 12c Repositories.

Learning Objectives : Learn how to administrate ODI Repositories, create repository storage spaces, how to connect repository, How to manage ODI Agents by creating a physical agents, Creating a Physical Agent, Launching a Listener, Scheduler and Web Agent, Example of Load Balancing

Topics Include : 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.

Practicals Covered : Hands on working with ODI Repositories, Create Repository Storage Spaces, Create and Connect to the Master Repository, Create and Connect to the Work Repository, Manage ODI Agents, Create a Physical Agent, Launch a Listener, Scheduler and Web Agent, Example of Load Balancing.

Learning Objectives : In this section we will have a Overview of ODI Topology, data servers and their physical schema, Architecture, How to define Logical Architecture, How to Map Logical and Physical Resources, How to define Agents, How to define Topology & planning.

Topics Include : 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

Practicals Covered : Work on ODI Topology, Data Servers and physical Schema, Define Physical Architecture & Logical Architecture, Define Agents, Topology & Planning of Topology.

Learning Objectives : Introduction to Topology Navigator and how to create Physical Architecture, Data Server and test the data server connection, Physical Schema, Logical Architecture,  How to Link the Logical and Physical Architecture.

Topics Include : 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

Practicals Covered : Hands on Topology Navigator, creation of Physical Architecture, Data Server and test the data server connection, Physical Schema, Logical Architecture, Link the Logical and Physical Architecture.

Learning Objectives : Learn how to create a ODI Project and folders. How to organize project and folders, How to exchange ODI Objects by exporting and importing using markers.

Topics Include : 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

Practicals Covered : Create a ODI Project and folders in it & organize the project and folders by understanding the modules in it. exchange the ODI Objects by Importing and Exporting Objects using markers.

Learning Objectives : Learn about model. Metadata in ODI, Reverse Engineering, Create Models, Organize Models, Create Data stores, Using Constraints in ODI, Create Keys and References

Topics Include : 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

Practicals Covered : Hands on creating model and learn about Metadata in ODI, learn how to reverse engineer, create different models & data stores, Use constraints in ODI, Creating Keys and references.

Learning Objectives : Learn what is an interface, how to write rules for Interface, What is Mapping?, Learn about Join, Filter, Constraint, Staging area and few basic interface steps.

Topics Include : 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

Practicals Covered : Hands on Creating and modifying Interface. Work on mapping & define filter, Constraint, Staging area etc…

Learning Objectives : Learn how to design Interface, Multiple Source data stores, how to create joins, filters, transformations. Overview of Flow, Specifying the Staging Area, Selecting Knowledge Modules.

Topics Include : Designing an Interface, Multiple Source Data stores, Creating Joins, Filtering data, Disabling Transformations, Overview of the Flow, Specifying the Staging Area, Selecting Knowledge Modules.

Practicals Covered : Hands on working with Interface design and work on multiple source data stores. Create SQL Joins, Filters, Transformations. Create the flow, specify the staging area, Modules.

Learning Objectives : How to monitor, usage of operators, creating Views & Tasks. How to Monitor Execution of an Interface, Troubleshoot a Session, Keys to Reviewing the Generated Code, Working with Errors, Tips for Preventing Errors.

Topics Include : 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

Practicals Covered : Hands on monitoring interface, using operator, create Views & Tasks. Monitoring the execution of interface. troubleshoot a session and review the generated code, work on errors generated and create tips.

Learning Objectives : Overview of Procedure with examples, Learn to create Procedures, Adding Commands, Options & Running a Procedure, Using operator to view results.

Topics Include : What is a Procedure?, Examples of Procedures, Creating Procedures, Adding Commands, Adding Options, Running a Procedure, Using Operator to View Results

Practicals Covered : Hands on creating Procedures with different examples, adding commands, options and run a procedure & finally operate to view results.

Learning Objectives : Learn how to create a package and execute the package, How to create advanced packages and handle error, execution path, loop using the advanced tab.

Topics Include : 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

Practicals Covered : Define Package, Creating a package, Executing a package, creating advanced packages, error handling, Controlling an Execution Path,  Creating loops, Advanced tab usage.

Learning Objectives : Learn about scenario, how to manage and prepare different scenarios for deployment, How to automate Scenario Management, how to schedule ODI Scenario, Overview of ODI version management, Using Version Browser and Version Comparison Tool, Handling concurrent changes.

Topics Include : 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

Practicals Covered : Hands on creating scenario and manage. For deployment prepare scenarios, automate the scenarios, schedule the ODI. versioning overview related to browser and comparison tools by handling concurrent changes.

Learning Objectives : Learn how to use data services and setup data services, test, install, invoke the public services.

Topics Include : 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.

Practicals Covered : Hands on working with Public web services for installation, invoke and remain web services in action.

Faq's

Tekslate basically offers the online instructor-led training. Apart from that we also provide corporate training for enterprises. Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Tekslate also verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

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

Oracle Data Integrator employs a powerful declarative design approach to data integration, which separates the declarative rules from the implementation details. Oracle Data Integrator is also based on a unique E-LT (Extract – Load Transform) architecture which eliminates the need for a standalone ETL server and proprietary engine, and instead leverages the inherent power of your RDBMS engines.

This combination provides the greatest productivity for both development and maintenance, and the highest performance for the execution of data transformation and validation processes. The central component of the architecture is the Oracle Data Integrator Repository. It stores configuration information about the IT infrastructure, metadata of all applications, projects, scenarios, and the execution logs.

Many instances of the repository can coexist in the IT infrastructure, for example Development, QA, User Acceptance, and Production. The architecture of the repository is designed to allow several separated environments that exchange metadata and scenarios (for example: Development, Test, Maintenance and Production environments). The repository also acts as a version control system where objects are archived and assigned a version number.

 

 

Certification

The Oracle Data Integration 12c Essentials (1Z0-448) exam is designed for individuals who possess a strong foundation and expertise in selling or implementing oracle Data Integration 12c solutions.

  • Having an ODI 12c certification distinguishes you as an expert.
  • For ODI 12c certification, you need not go to a test center, as the certification is available online.
  • You need to register yourself at Here to give your Oracle Data Integration 12c Exam.

Exam Details: Click Here…

Course Reviews

4.9

165 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
        Profile photo of Suneel Kumar
        Chrissteve
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Profile photo of Suneel Kumar
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Profile photo of Suneel Kumar
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Profile photo of Suneel Kumar
        Alison Benhar
    drop query

    Send us a Query

    Enroll into this course

    Register for Free Demo

    3 + 5

    Related Articles

    No Related Articles found

    Support


    Please leave a message and we'll get back to you soon.

    3 + 5