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

Dec-21 - Feb-01

Weekend
SOLD OUT

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

350.00     Enroll Now

Dec-14 - Jan-25

Weekday
SOLD OUT

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

350.00     Enroll Now

Dec-21 - Feb-01

Weekend
FILLING FAST

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

350.00     Enroll Now

Dec-28 - Feb-08

Weekday
FILLING FAST

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

350.00     Enroll Now

Jan-04 - Feb-15

Weekend

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

350.00     Enroll Now

Jan-11 - Feb-22

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

DOWNLOAD BROCHURE

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.

Curriculum

Course Description

About The Course
What is Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training about? Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.
Taking this course will teach you how to improve performance and reduce integration costs across your organization's heterogeneous systems. You'll be able to centralize data across databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem (such as Hive, Hbase, HDFS, Oozie, etc), allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing.
Please Note: The latest release of Oracle Data Integrator supports storing ODI artifacts into source code management systems (such as Subversion.) This course teaches you how to integrate ODI with Subversion.
Objectives Of Our Online PySpark Training Course
What are the objectives of Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training ?
  • Administer ODI resources and setup security with ODI.
  • Apply ODI Topology concepts for data integration.
  • Describe ODI Model concepts.
  • Describe the architecture of Oracle Data Integrator 12c.
  • Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations.
  • Explore, audit data, and enforce data quality with ODI.
  • Implement Changed Data Capture with ODI.
  • Integrate ODI with Version Control Systems (Subversion).
  • Extend ODI to include the Big Data Hadoop Ecosystem.
Go For Online Spark Training
Who is Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training for?
  • Database Administrators.
  • Database Administrators.
  • Business Analysts.
  • SOA Architect.
  • Data Scientist.
  • Data Warehouse Administrator.
Learning With Our PySpark Certification Training
What are the prerequisites for Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training? Suggested Prerequisite:-Basic knowledge of ELT data processing.

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
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 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