- Home
- Database
- Networking
- Programming
- Online Courses
- Mobile Application
- Web App Developments
- Cryptocurrency Wallets and Mining Coins
- Q# Programming
- BlockChain Application Development
- Java Servlet Programming
- Java Training with Spring
- Developing Images with Docker
- C++ Training
- Python RPA Programming
- Excel VBA Training
- Ruby on Rails Training
- C# Training Course
- Testing
- Automation Test Engineer
- Penetration Testing
- Cucumber BDD
- Selenium Web Test Training Java
- Selenium Test Automation with PHP
- Selenium Test Automation with C# .NET and NUnit
- Android Appium Test Automation
- Online Performance Testing
- Python Automation Testing with Selenium and BDD
- Automation Test Architect
- Automation Test Analyst
- SpecFlow Automation Testing
- Contact
- About Us
ODI – Oracle Data Integrator 12c Training
Hot
Course Overview
Oracle Data Integrator (ODI) software delivers high-performance data movement and transformation among enterprise heterogeneous platforms with its open and integrated ELT (Extract Load and Transform) architecture and extended support for Big Data. Oracle Data Integrator software helps Enterprise users to leverage data integration initiatives on-premise or in the cloud, such as Big Data management, Service Oriented Architecture (SOA) and Business Intelligence (BI). Our Oracle Data Integrator training course will teach you how to use the ODI software for creating repositories, defining data stores, using knowledge modules, using agents, creating interfaces, creating and executing packages etc.
Course Start Dates
| Start Date | Time | Days | Duration | Location |
|---|---|---|---|---|
| 24/05/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 28/06/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 26/07/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 30/08/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 27/09/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 01/11/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
| 06/12/2021 | 10.00 - 17.00 | Mon - Wed | 3 Days | Brentford |
Prerequisites
Target Audience
On-site training for Corporate
Course Content
Oracle Data Integrator 12c
- Identifying the Course Units
- What is Oracle Data Integrator?
- Why Oracle Data Integrator?
- Overview of ODI 12c Architecture
- Overview of ODI 12c Components
- About Graphical Modules
- Types of ODI Agents
- Overview of Oracle Data Integrator Repositories
- 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
- 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
- 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
- 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
- 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
- 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
- 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 an Interface
- Multiple Source Data stores
- Creating Joins
- Filtering data
- Disabling Transformations
- Overview of the Flow
- Specifying the Staging Area
- Selecting Knowledge Modules
- 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
- 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
- What is a Procedure?
- Examples of Procedures
- Creating Procedures
- Adding Commands
- Adding Options
- Running a Procedure
- Using Operator to View Results
- 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
- 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
- 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
- Reviewing the Oracle GoldenGate JAgent configuration in ODI Studio
- Initial load
- Starting the ODI and OGG Demo Client
- Running the Mappings
- Setting up Changed Data Capture
- Synchronizing the changed data
- Load TRG_CUSTOMER Mapping
- Sync Data Package
John Hood (verified owner) – :
The course was run by an extremely informative and experienced tutor, and covered all aspects of the latest ODI version including the various types of agent creation.
I would have no doubt in recommending this course for others requiring ODI tuition.