Oracle Data Integrator 12c: Integration and Administration Ed 3 Course in Germany
Practice ODI 12c using actual scenarios
Train under seasoned professionals with top credentials
Add value to your CV with a recognized Oracle certification
Learn anytime with flexible schedules & formats
Master advanced data integration & admin tools
Choose from simple, stress-free payment plans
4.8/53246 EnrolledEnrolled Learners
4.8/53246 EnrolledEnrolled Learners
Overview
What our training includes:
- Develops your understanding of ODI agents, repositories, and integration architecture
- Teaches you to craft and refine ODI mappings for smooth data transformation
- Explains CDC implementation for real-time synchronization of data
- Prepares you to create complex ODI projects using reusable modules and custom steps
- Provides guidance on integrating version control with Subversion
- Trains you in applying Hadoop and Big Data tools through hands-on learning
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
Learn to manage ODI agents, repositories, & architecture for smooth data integration
2
Build efficient data transformation flows using ODI knowledge modules
3
Apply CDC methods to sync data in real time
4
Connect ODI with Hadoop tools for handling Big Data tasks
5
Collaborate using Subversion for tracking changes & team 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
The Oracle Data Integrator 12c Integration and Administration Ed 3 course in Germany is all about helping professionals master Oracle Data Integrator (ODI) 12c. Professionals learn using ODI for ODI agents, repository management, data integration projects, and data mappings. The program will also cover advanced topics like Big Data integration with Hadoop, how to use Changed Data Capture (CDC), and version control using Subversion.
This course is ideal for professionals working in managing data integration systems, especially those using Oracle technologies, like -
- Data Integration Specialists
- ETL Developers
- Data Engineers
- Database Administrators
- Business Intelligence Analysts
- IT Professionals transitioning to data roles
Our training is available in the following flexible modes-
- Group classes
- Individual one-on-one sessions
- Online live sessions
The Oracle Data Integrator 12c Integration and Administration Ed 3 Certification allows professionals to apply for the following job roles -
- Data Architect
- Oracle Developer (ODI focused)
- Data Integration Engineer
- ODI Consultant
- BI Developer or Analyst
- ETL Developer
This Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification in Germany is globally recognised. The certification is highly valued by employers in data-driven industries, which enhances career opportunities, especially in the GCC regions, where skilled data professionals are in high demand.
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!
