Oracle Data Integrator 12c: Integration and Administration Ed 3 Course
Master ODI 12c with hands-on projects and real-world applications
Learn from expert instructors with industry-leading credentials
Boost your career with a globally recognized Oracle certification
Flexible learning options that fit your schedule and format
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 for efficient data integration
- Design and optimize ODI mappings for effective data transformation workflows
- Implement Changed Data Capture (CDC) techniques for real-time data synchronization
- Build advanced ODI projects using knowledge modules and customized procedures
- Integrate ODI with Subversion for version control and collaborative development
- Gain hands-on experience with Hadoop ecosystem integration and 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 ODI repositories, agents, and architecture for efficient data integration
2
Design ODI mappings using knowledge modules for optimal data transformation
3
Implement Changed Data Capture (CDC) for real-time data synchronization
4
Integrate ODI with Hadoop for advanced Big Data management
5
Use Subversion for version control and collaborative development
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 teaches data integration, transformation, and administration. You will master configuring ODI repositories, designing advanced mappings, implementing CDC, and integrating with Big Data platforms like Hadoop.
This course prepares you to manage complex data workflows, enhancing your career in data management and integration. It’s ideal for IT professionals looking to boost their expertise in data systems and real-time integration solutions.
The course is suitable for IT professionals, data architects, and ETL developers with a basic understanding of databases, SQL, and data warehousing concepts. Prior experience with ETL processes is recommended but not mandatory. Familiarity with general data integration challenges will help, but the course is designed to teach you all the essential skills for successful data integration using ODI.
Oracle Data Integrator 12c certification is recognized globally and valued in industries requiring robust data management systems. In the UAE and the Middle East, certified professionals are in demand for roles in data integration and management. This certification opens doors to international career opportunities, positioning you as an expert in Oracle-based data systems.
Participants of the Oracle Data Integrator 12c: Integration and Administration Ed 3 course can pursue the following career paths:
- Data Integration Specialist: Manage data integration processes
- ETL Developer: Design and implement ETL pipelines
- Data Architect: Create data models and architecture
- Business Intelligence Analyst: Provide insights for business decisions
- Data Warehouse Administrator: Oversee data storage and processing
The Oracle Data Integrator 12c: Integration and Administration Ed 3 course covers Oracle Data Integrator (ODI), Subversion for version control, and Hadoop for Big Data integration. It also focuses on Oracle GoldenGate for data synchronization and introduces knowledge modules (KM) for efficient mapping and data transformation processes. You will gain hands-on experience with these industry-leading tools to improve data management.
Oracle Data Integrator 12c certification is highly specialized in data integration, focusing on ODI’s architecture, CDC, and Big Data integration. Unlike broader data management certifications, this course provides in-depth, hands-on skills in Oracle’s ecosystem, ensuring that you stand out in roles requiring Oracle-specific knowledge. Competitors like Simplilearn offer similar certifications, but Oracle's training is more aligned with real-world applications.
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!
