Oracle Data Integrator 12C Integration And Administration Ed 3 Course

Oracle Data Integrator 12c: Integration and Administration Ed 3 Training

This Oracle Data Integrator (ODI) training provides experience in configuring and administering the ODI 12c environment. Learn methods and techniques of data integration among various platforms based on the architecture of Extract Load Transform (EL-T).

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Data Integrator12c Integration UpComing Batches

Nov-22 - Jan-03

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-15 - Dec-27

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-04 - Jan-15

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Oracle Data Integrator 12c: Integration

SELF PACED

This Oracle Data Integrator (ODI) training provides experience in configuring and administering the ODI 12c environment. Learn methods and techniques of data integration among various platforms based on the architecture of Extract Load Transform (EL-T).

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content

Topics:
  • Overview of ODI Components.
  • Overview of Oracle Data Integrator Repositories.
  • Identifying the Course Units.
  • Types of ODI Agents.
  • Overview of ODI Architecture.
  • About Graphical Modules.
  • Why Oracle Data Integrator?

Topics:
  • Overview of ODI Topology.
  • Defining a Topology.
  • Planning the Topology.
  • About Data Servers and Physical Schemas.
  • Mapping Logical and Physical Resources.
  • Defining the Logical Architecture.
  • Defining Agents.
  • Defining the Physical Architecture.

Topics:
  • Creating Logical Architecture.
  • Testing a Data Server Connection.
  • Overview of Logical Architecture and Context Views.
  • Creating a Physical Schema.
  • Creating Physical Architecture.
  • Creating a Data Server.
  • Overview of Topology Navigator.
  • Linking the Logical and Physical Architecture.

Topics:
  • Overview of ODI Projects.
  • Creating and Maintaining Folders.
  • Creating and Labeling with Markers.
  • Exporting and Importing Objects.
  • Creating a New Project.
  • Understanding Knowledge Modules.
  • Exchanging ODI Objects and Sharing Global Objects.
  • Organizing Projects and Folders.

Topics:
  • Creating Data Stores.
  • Organizing Models.
  • Understanding Metadata in ODI.
  • What is a Model?.
  • Creating Models.
  • Creating Keys and References.
  • Understanding Reverse Engineering.
  • Configuring Constraints in ODI.

Topics:
  • What is a Filter?
  • What is a Constraint?
  • Creating a Basic Mapping.
  • Business Rules for Mappings.
  • What is a Mapping?
  • What is a Join?
  • What is a Staging Area?

Topics:
  • Mapping with Knowledge Modules (KM).
  • Execution Location.
  • Creating an Intermediate Mapping.
  • What is a Staging Area?
  • What is a Filter?
  • What is a Join?
  • What is a Mapping?
  • Overview of Integration Process.
  • Business Rules for Mapping.

Topics:
  • Creating Joins.
  • Filtering Data.
  • Multiple Source Data Stores.
  • Designing a Mapping.
  • Overview of the Flow.
  • Selecting Knowledge Modules.
  • Disabling Transformations.
  • Specifying the Staging Area.

Topics:
  • How to Troubleshoot a Session?
  • Tips for Preventing Errors.
  • Monitoring Mappings.
  • Keys to Reviewing the Generated Code.
  • Working with Errors.
  • Viewing Sessions and Tasks.
  • How to Monitor Execution of a Mapping?
  • Creating Objects with Operator.

Topics:
  • Mapping with Business Rules.
  • Creating User Functions.
  • Mapping Substitution Methods.
  • Modifying a KM.
  • Showing Variable Values in Log.
  • Creating and Tracking Variables.
  • Customizing Reverse Engineering Using RKM.
  • Overview of Business Rule Elements.

Topics:
  • Using Substitution Methods.
  • Developing Your Own Knowledge Module.
  • Using User Functions.
  • Reusable Mappings.
  • Creating a User Function.
  • Using Partitioning in a Mapping.
  • Derived Select (Subselect) for Reusable Mappings.

Topics:
  • What is a Procedure?
  • Adding Commands.
  • Examples of Procedures.
  • Viewing Results with Operator Navigator.
  • Running a Procedure.
  • Adding Options.
  • Creating Procedures.

Topics:
  • Variable Steps.
  • Controlling the Execution Path.
  • Error Handling.
  • Review of Package Steps.
  • Executing a Package.
  • What is a Package?
  • Creating Model, Submodel and Datastore Steps.
  • Creating a Package.

Topics:
  • Menu Bar Icons.
  • Screen Step Numbering.
  • Control Execution Flow.
  • Specifying Debug Properties.
  • New Functionality.
  • Starting a Session in Debug Mode.

Topics:
  • Generating a Scenario.
  • What is a Scenario?
  • Scheduling the ODI Scenario.
  • Managing Schedules.
  • Executing a Scenario.
  • Automating Scenario Management.

Topics:
  • Defining the Restart Behavior.
  • What Are Load Plans?
  • Load Plan Editor.
  • Load Plan Steps.
  • Benefits of Using Load Plans.
  • Handling Failed Load Plans.

Topics:
  • Why Data Quality?
  • When to Enforce Data Quality?
  • Data Quality in Source Applications.
  • Enabling Static or Flow Control for a Mapping.
  • Data Quality Business Rules.
  • Data Quality Control in the Integration Process.
  • Data Quality in the Target Applications.
  • Setting the Options, Selecting Which Constraints to Enforce.
  • Reviewing Erroneous Records.

Topics:
  • Journalizing.
  • Oracle GoldenGate Integration.
  • Changed Data Capture in ODI.
  • Viewing Data/Changed Data.
  • CDC Strategies and Infrastructure.
  • Why Changed Data Capture?
  • Techniques of Changed Data Capture.
  • CDC Consistency.
  • Creating Change Data Capture (CDC).

Topics:
  • Generating Topology Reports.
  • Integration of ODI with Enterprise Manager.
  • Java EE Agent and Enterprise Manager Configuration with WebLogic Domain.
  • Defining Password Policies.
  • Creating Profiles.
  • Creating Users.
  • Assigning a Profile to a User.
  • Assigning an Authorization by Profile or User.
  • Introduction to ODI Security Navigator.
  • Security Concepts: Overview.
  • Defining Security Policies.
  • Implementing External Authentication.
  • Using ODI Console.

Topics:
  • Configuring the Subversion Repository with ODI.
  • Creating Full or Partial Tags in the Subversion Repository.
  • SVN Connections.
  • Performing a Branch Merge.
  • Adding a Single Non-Versioned Object to SVN.
  • Adding Multiple Non-Versioned Objects to SVN.
  • ODI: VCS Integration.
  • Creating a New Version for an Object.
  • Creating Full or Partial Tags in the Subversion Repository.
  • ODI: Selecting the Required VCS.

Topics:
  • Emergence of Apache Hadoop.
  • Hadoop Ecosystem.
  • Big Data Concepts.
  • ODI: Hadoop Integration Process.
  • Big Data Knowledge Modules Matrix.
  • Apache HBase, Apache Hive, Apache Pig.
  • Apache Spark, Apache Sqoop, Apache Oozie.
  • Hadoop Data Integration: Overview.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers