Oracle Data Integrator 12c: Integration and Administration Ed 3 Course in Dubai
Master Oracle Data Integrator 12c with hands-on projects
Gain in-demand skills for top data integration roles
Learn from certified experts with real-world experience
Boost your career with a globally recognized certification
Flexible schedules to fit your busy lifestyle
Real-world applications for immediate impact
Convenient and hassle-free payment plans
4.8/53246 EnrolledEnrolled Learners
4.8/53246 EnrolledEnrolled Learners
Overview
What you will learn:
- Master ODI repositories, agents, and architecture for streamlined data integration
- Design and optimize ODI mappings for efficient data transformation
- Implement Changed Data Capture (CDC) for real-time data synchronization
- Develop advanced ODI projects with knowledge modules and custom procedures
- Integrate ODI with Subversion for version control and teamwork
- Gain hands-on experience with Hadoop and Big Data integration 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 Oracle Data Integrator 12c to design efficient data integration workflows
2
Implement advanced mapping techniques using Changed Data Capture (CDC) for real-time integration
3
Gain hands-on experience with Big Data integration using Hadoop ecosystems and Subversion
4
Design and optimize ODI repositories and agents for seamless data management
5
Develop expertise in integrating Oracle GoldenGate for high-performance data replication solutions
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
The Oracle Data Integrator 12c: Integration and Administration Ed 3 course in Dubai teaches you how to efficiently manage complex data workflows using Oracle Data Integrator (ODI). You’ll learn to design, administer, and optimize data integration processes, with hands-on experience in mapping, CDC, Big Data integration, and version control systems like Subversion. This training is perfect for professionals aiming to enhance their data management and integration skills, opening doors to high-demand roles in data integration.
By enrolling in the Oracle Data Integrator 12c: Integration and Administration Ed 3 course in Dubai, you’ll gain practical experience in real-world data integration. You’ll master advanced techniques like CDC, Big Data integration, and ODI repositories management. The certification adds significant value to your career, enabling access to in-demand roles and higher-paying positions in data integration and management, especially in the UAE and the Middle East.
This course is ideal for professionals in data management, ETL developers, cloud solutions engineers, and data architects. It’s perfect for those looking to enhance their skills in Oracle Data Integrator 12c, master data integration, and pursue careers in data management. Whether you're a beginner or looking to deepen your expertise, this course will equip you with the tools needed to advance your career.
The Oracle Data Integrator 12c certification is globally recognized by industry professionals, enhancing your credibility as a data integration expert. Whether you're working in the UAE, Middle East, or internationally, this certification is highly respected by top employers and provides a competitive edge in the growing data management industry.
The Oracle Data Integrator 12c: Integration and Administration Ed 3 course in Dubai offers flexible learning options. You can choose to learn at your own pace with self-paced modules, or attend live instructor-led sessions, depending on your preferred learning style and schedule.
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!
