Oracle Data Integrator 12c: Integration and Administration Ed 3 Course in Oman
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/52696 EnrolledEnrolled Learners
4.8/52696 EnrolledEnrolled Learners
Overview
What you will learn:
- Learn about ODI repositories, agents, and architecture for efficient data integration
- Design and optimise ODI mappings for effective data transformation workflows
- Implement Changed Data Capture (CDC) techniques for real-time data synchronisation
- Develop advanced ODI projects using knowledge modules and customised procedures
- Learn to integrate ODI with Subversion for version control & collaborative development
- Get hands-on 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
We, at Learners Point, take immense pride in our teaching methods and instructors. Our instructors are some of the best experts in their fields and employ a practical approach to learning. Many of them are globally recognised and have a diverse set of experience in their field of expertise. You are always sure to have the best in the industry as your teachers who are ready to guide you at every step and make the experience informative yet enjoyable. Apart from the focus on learning your chosen course, our instructors also encourage students to develop communication skills and interpersonal skills necessary to excel in the practical world.
Our cutting edge teaching methods make every program an immersive and productive experience for the learners. Our learning methods are research-driven and are continuously updated to stay relevant to present times as well as the future. You will enjoy practical applications of everything learned through theory and regular mock examinations to help monitor your progress. Our courses are led by an instructor in a classroom setup and we do offer online high-quality sessions as well for individuals. We also monitor the training sessions with a progress tracker to maintain high standards of instruction & ethics.
Learning Outcomes
Successful completion of the training will help you to:
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 synchronisation
4
Integrate ODI with Hadoop for advanced Big Data management
5
Use Subversion for version control and collaborative development
KHDA Certificate
Earn a KHDA attested Course Certificate. The Knowledge and Human Development Authority (KHDA) is the educational quality assurance and regulatory authority of the Government of Dubai, United Arab Emirates.
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
Our Oracle Data Integrator 12c: Integration and Administration Ed 3 course focuses on data administration, integration and transformation. We train learners to configure ODI repositories, design advanced mappings, implement CDC, and integrate with Big Data platforms like Hadoop.
This Oracle Data Integrator 12c: Integration and Administration Ed 3 course is ideal for IT professionals, data architects, and ETL developers looking to gain their expertise in data systems and real-time integration solutions. We prepare professionals to manage complex data workflows. This training is ideal for improving your career opportunities in data management and integration.
Before enrolling in this course, we recommend that you have some experience with the ETL process. However, it is not mandatory. Moreover, familiarity with general data integration challenges will make your learning easier and faster. Our course is designed to equip you with all the essential skills needed for successful data integration using ODI.
After successfully completing this Oracle Data Integrator 12c: Integration and Administration Ed 3 course, you can get lucrative career opportunities in Oman. Some of the top job roles are listed below:
- Data Architect
- Data Integration Specialist
- ETL Developer
- Business Intelligence Analyst
- Data Warehouse Administrator
Our Oracle Data Integrator 12c certification is a highly specialised training. We only focus on ODI’s architecture, CDC, and Big Data integration. Unlike other data integration courses, we offer deep knowledge and skill development in Oracle’s ecosystem. Our training ensures that you stand out in roles with Oracle-specific knowledge and stay 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!
