Oracle Data Integrator 12c: Integration and Administration Ed 3 Course in US
Advance ODI 12c with hands-on projects and real-world applications
Learn from expert instructors with industry-leading credentials
Boost your career with a globally recognised Oracle certification
Flexible learning options that fit your schedule
Gain advanced skills in data integration and administration
Convenient and hassle-free payment plans
4.8/53246 EnrolledEnrolled Learners
4.8/53246 EnrolledEnrolled Learners
Overview
What our training includes:
- Master ODI repositories, agents, and architecture to streamline data integration processes
- Design and optimise ODI mappings for efficient and scalable data transformation workflows
- Implement Change Data Capture (CDC) techniques to enable real-time data synchronisation
- Develop advanced ODI projects using knowledge modules and custom procedures for tailored solutions
- Integrate ODI with Subversion for version control and enhanced team collaboration
- Gain hands-on experience with integrating the Hadoop ecosystem and applying Big Data techniques
Upcoming sessions
Curriculum
1
Overview of ODI Components
2
Overview of Oracle Data Integrator Repositories
3
Identifying the Course Units
4
Types of ODI Agents
5
Overview of ODI Architecture
6
About Graphical Modules
7
Why Oracle Data Integrator?
1
Creating a Wallet to Securely Store Credentials
2
Administrating the ODI Repositories
3
Creating Repository Storage Spaces
4
Creating and Connecting to the Work Repository
5
Managing ODI Agents
6
Creating and Connecting to the Master Repository
1
Overview of ODI Topology
2
Defining a Topology
3
Planning the Topology
4
About Data Servers and Physical Schemas
5
Mapping Logical and Physical Resources
6
Defining the Logical Architecture
7
Defining Agents
8
Defining the Physical Architecture
1
Creating Logical Architecture
2
Testing a Data Server Connection
3
Overview of Logical Architecture and Context Views
4
Creating a Physical Schema
5
Creating Physical Architecture
6
Creating a Data Server
7
Overview of Topology Navigator
8
Linking the Logical and Physical Architecture
1
Overview of ODI Projects
2
Creating and Maintaining Folders
3
Creating and Labeling with Markers
4
Exporting and Importing Objects
5
Creating a New Project
6
Understanding Knowledge Modules
7
Exchanging ODI Objects and Sharing Global Objects
8
Organizing Projects and Folders
1
Creating Data stores
2
Organizing Models
3
Understanding Metadata in ODI
4
What is a Model?
5
Creating Models
6
Creating Keys and References
7
Understanding Reverse Engineering
8
Configuring Constraints in ODI
1
What is a Filter?
2
What is a Constraint?
3
Creating a Basic Mapping
4
Business Rules for Mappings
5
What is a Mapping?
6
What is a Join?
7
What is a Staging Area?
1
Mapping with Knowledge Modules (KM)
2
Execution Location
3
Creating an Intermediate Mapping
4
What is a Staging Area?
5
What is a Mapping, a Filter, a Join?
6
What is a Mapping?
7
Overview of Integration Process
8
Business Rules for Mapping
1
Creating Joins
2
Filtering Data
3
Multiple Source Data stores
4
Designing a Mapping
5
Overview of the Flow
6
Selecting Knowledge Modules
7
Disabling Transformations
8
Specifying the Staging Area
1
How to Troubleshoot a Session
2
Tips for Preventing Errors
3
Monitoring Mappings
4
Keys to Reviewing the Generated Code
5
Working with Errors
6
Viewing Sessions and Tasks
7
How to Monitor Execution of a Mapping
8
Creating Objects with Operator
1
Mapping with Business Rules
2
Creating User Functions
3
Mapping Substitution Methods
4
Modifying a KM
5
Showing Variable Values in Log
6
Creating and Tracking Variables
7
Customizing Reverse Engineering Using RKM
8
Overview of Business Rule Elements
1
Using Substitution Methods
2
Developing Your Own Knowledge Module
3
Using User Functions
4
Reusable Mappings
5
Creating a User Function
6
Using Partitioning in a Mapping
7
Derived Select (Subselect) for Reusable Mappings
1
What is a Procedure?
2
Adding Commands
3
Examples of Procedures
4
Viewing Results with Operator Navigator
5
Running a Procedure
6
Adding Options
7
Creating Procedures
1
Variable Steps
2
Controlling the Execution Path
3
Error Handling
4
Review of Package Steps
5
Executing a Package
6
What is a Package?
7
Creating Model, Submodel and Datastore Steps
8
Creating a Package
1
Menu Bar Icons
2
Screen Step Numbering
3
Control Execution Flow
4
Specifying Debug Properties
5
New Functionality
6
Starting a Session in Debug mode
1
Generating a Scenario
2
What is a Scenario?
3
Scheduling the ODI Scenario
4
Managing Schedules
5
Executing a Scenario
6
Automating Scenario Management
1
Defining the Restart Behaviour
2
What Are Load Plans?
3
Load Plan Editor
4
Load Plan Steps
5
Benefits of Using Load Plans
6
Handling Failed Load Plans
1
Why Data Quality?
2
When to Enforce Data Quality?
3
Data Quality in Source Applications
4
Enabling Static or Flow Control for a Mapping
5
Data Quality Business Rules
6
Data Quality Control in the Integration Process
7
Data Quality in the Target Applications
8
Setting the Options, Selecting Which Constraints to Enforce
9
Reviewing Erroneous Records
1
Journalizing Oracle
2
GoldenGate Integration
3
Changed Data Capture in ODI
4
Viewing Data/Changed data
5
CDC Strategies and Infrastructure
6
Why Changed Data Capture?
7
Techniques of Changed Data
8
Capture CDC Consistency
9
Creating Change Data Capture (CDC)
1
Generating Topology Reports
2
Integration of ODI with Enterprise Manager
3
Java EE Agent and Enterprise Manager Configuration with
4
WebLogic Domain
5
Defining Password Policies
6
Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
7
Introduction to ODI Security Navigator. Security Concepts: Overview, Defining Security Policies Implementing External Authentication
8
Using ODI Console
1
Configuring the Subversion Repository with ODI
2
Creating Full or Partial Tags in the Subversion Repository
3
SVN Connections
4
Performing a Branch Merge
5
Adding a Single Non-Versioned Object to SVN, Adding Multiple
6
Non-Versioned Objects to SVN
7
ODI: VCS Integration
8
Creating a New Version for an Object. Creating Full or Partial Tags in the Subversion Repository ODI: Selecting the Required VCS
1
Emergence of Apache Hadoop. Hadoop Ecosystem
2
Big Data Concepts
3
ODI: Hadoop Integration Process
4
Big Data Knowledge Modules Matrix
5
Apache HBase, Apache Hive, Apache Pig. Apache Spark, Apache
6
Sqoop, Apache Oozie
7
Hadoop Data Integration: Overview
Meet your Trainer
Our Trainers
Learners Point has a reputation for high-quality training that makes a difference in people's lives. We undertake a practical and innovative approach to working closely with businesses to improve their workforce. Our expertise is wide-ranging with ample support from our expert trainers who are globally recognized and hold a diverse set of experiences in their field of expertise. We are proud of our instructors who take ownership of our distinctive and comprehensive training methodologies, help our students imbibe those with ease, and accomplish gracefully.
We at Learners Point believe in encouraging our students to embark upon a journey of lifelong learning and self-development, with the aid of our comprehensive and distinctive courses tailored to current market trends. The manifestation of our career-oriented approach is what we assure through a pleasant professional enriched environment with cutting-edge technology, and an outstanding while highly acknowledged training staff that uses up-to-date methodologies and quality course material. With our aim to mold professionals to be future leaders, our industry expert trainers provide the best in town mentorship to our students while endowing them with the thirst for knowledge and inspiring them to strive for professional and human excellence.
Learning Outcomes
Upon finishing the training, you will:
1
Master the configuration and management of ODI repositories, agents, and architecture for seamless data integration
2
Design and optimise ODI mappings using knowledge modules to ensure efficient data transformation
3
Implement Changed Data Capture (CDC) to enable real-time data synchronisation across systems
4
Integrate ODI with Hadoop to effectively manage and process Big Data workloads
5
Utilise Subversion for version control, ensuring smooth collaboration and consistent development processes
Learners Point Certificate
Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.
Overall ratings by our students
Related courses
Frequently asked questions
The Oracle Data Integrator 12c: Integration and Administration Ed 3 course in the US provides a comprehensive foundation in data integration. You'll master ODI repositories, agents, and advanced mapping techniques for seamless data transformation and synchronisation. The course includes hands-on training with tools like Oracle GoldenGate and Hadoop integration, ensuring you gain real-world skills for managing complex data workflows and boosting your career in data management.
Completing the Oracle Data Integrator 12c: Integration and Administration Ed 3 Training in the US boosts your career prospects by equipping you with expertise in managing data integration projects. The course helps you master ODI tools like repositories and agents, making you proficient in data management. It also provides practical skills for real-time data synchronisation and Big Data management, preparing you for high-demand roles in industries across the US and globally.
After completing the Oracle Data Integrator 12c: Integration and Administration Ed 3 course in the US, you can pursue roles such as:
● Data Integration Specialist
● ETL Developer
● Data Architect
● Oracle ODI Consultant
The Oracle Data Integrator 12c: Integration and Administration Ed 3 course in the US is valuable across multiple industries, including finance, healthcare, telecommunications, and technology. As businesses in these sectors—especially in the US—continue to rely on robust data integration for decision-making, professionals with Oracle Data Integrator expertise are increasingly in demand.
These professionals are sought after to optimise workflows, streamline data processes, and manage data systems efficiently, driving innovation and operational success in these industries.
This course is delivered through various flexible modes. Depending on your choice, you can go for classroom-based group learning or one-on-one training sessions. Live online sessions are also available for working professionals.
Do you want to learn more about Learners Point Academy?
- Learn more about courses
- Understand about our methodology
- Let’s talk about Corporate trainings
- Anything else that you want to know, we are here for you!
