Oracle Data Integrator (ODI) 12c Admin Course
3.4 (111 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
916 students enrolled

Oracle Data Integrator (ODI) 12c Admin Course

ODI 12c Admin Course-Architecture, Enterprise Installation, Maintenance, and Support
3.4 (111 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
916 students enrolled
Created by Sanjay Singh
Last updated 12/2019
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 2 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • ODI Architecture and significance of each component.
  • Integration and data flow architecture in ODI.
  • Oracle Fusion Middleware, WebLogic Domain, Directory structure.
  • Enterprise installation. Install each component JDK, Repositoy, Fusion Middleware, Web Logic Server, Agents.
  • Start Node Manager, Weblogic Admin Server, Managed Server, Standalone Colocated Agent and JEE Agent.
  • Operational Activities for ODI Admin -> Topology maintenance, ODI user maintenance.
Requirements
  • You should be able to use a PC.
  • You should be able to work on operating systems like Windows.
  • You should know how to use browser and such operating system tools.
  • Basic knowledge of SQL and relational database will be an asset.
Description

Join the most comprehensive and popular ODI Admin Course on Udemy, because now is the time to get started!

From Architecture, Installation, Agents, Topology, Security to Project Execution this course covers it all you need to know to become a successful ODI Admin

You'll learn all about Architecture, ODI ComponentsRepositoriesDomainsFusion MiddlewareWebLogic Server, Topology, - and in the end: You'll will have a project to ensure all the components are installed and configured properly!

But that's not all! Along with covering all the steps for ODI  Admin functions, this course also has quiz and project, which allow you to practice the things learned throughout the course!

And if you do get stuck, you benefit from an extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience I have designed this course for students and professionals who wish to learn (or need support) how to install fully functional Enterprise level Oracle Data Integrator with all its components and support its execution.

This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!

Why ODI?

Oracle data integrator is Oracle's flagship, High-performance bulk data movement and transformation tool. Oracle is investing a lot in this tool.

  • ODI is a built in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tool with ODI.
  • The ELT approach of ODI with knowledge module based modular approach makes it the most complete and scalable batch integration tool.

If you are looking for a thriving career in data integration and analytics, this is the right time to learn ODI.

Get a very deep understanding of ODI Admin activities

Every new ODI version is coming with added features. Success of ODI implementation and its performance depends a lot on how  ODI Admin has installed and configured it. 

When installing ODI 12c at enterprise level, Oracle recommends Enterprise installation with Web logic server, Managed ODI Server and either Standalone collocated agent or JEE agent as they provide high availability and other benefits of Fusion Middleware. This course covers all that you need to know to successfully install ODI for your project. You will go through instructions in video as well as pdf document with each step shown in the video. 

Pay once, benefit a lifetime!
This is an evolving course! Enterprise installation of ODI 12c and later future versions will  be covered in this course.  You won’t lose out on anything!
Don’t lose any time, gain an edge and start now!

This course will also be updated to Oracle Data Integrator (ODI) Enterprise Installation on Linux platform !

Who this course is for:
  • Anyone interested in knowing about data, integration, business intelligence
  • Database Administrators (DBA), Software Engineers, Developers, Consultants, and Tech Leads
Course content
Expand all 25 lectures 02:10:14
+ Introduction
3 lectures 17:06

Welcome to the course. In this lecture I explain you different attributes of this course.

Preview 06:56

This introductory lecture explains what is data, information, intelligence and how they relate to each other. It also explains different architectures of ETL tools.

Data to Intelligence
07:40

 Using a real world scenario, this video explains why data integrator is required.

Why Data Integrator?
02:30
+ Architecture
4 lectures 16:01

This lecture explains the development process flow in ODI. You will understand the components you need to develop.

Preview 03:23

This lecture explains 

  • ODI components and how it moves data from source to target
  • Knowledge Modules
  • Role of ODI Admin in projects
ODI Data Flow Architecture
03:23

This lecture explains ODI repository and it's components.

ODI Repositories
02:53

In this lecture you will learn about ODI Agents.

  • Role of ODI Agent
  • Type of ODI Agents -> Standalone, JEE, Colocated
  • Architecture
  • Compare and contrast between these agents
ODI Agents
06:22
+ Oracle Fusion Middleware
2 lectures 07:13

In this lecture, you will understand 

  • What is WebLogic Domain
  • Administration Server, Managed
    Servers
  • Node Manager
  • Cluster


WebLogic Domain
03:59

In this lecture you will understand Oracle Fusion Middleware with WebLogic Domain Directory Structure.

  1. Oracle Home
  2. ODI Domain
Preview 03:14
+ Oracle Express Database and SQL Developer
4 lectures 12:25

You will need an relational database for next step. If you don't have an Oracle Database you can install free Oracle Express Data Base and try the installation steps.

Preview 05:22

In this lecture you will download and start SQL Developer.

SQL Developer Download
03:55

In this lecture you will connect the SQL developer with database.

SQL Developer : Connection
01:27

In this lecture you will learn how to reset database password using SQL Developer.

SQL Developer: Password Reset
01:41
+ Enterprise Installation
8 lectures 37:39

ODI 12c needs JDK 7 and above. This lecture explains the steps to install and configure JDK 8 and change JAVA_HOME environment variable.

Preview 05:54

This lecture explains from where to download ODI12c files and how to configure it.

The lecture covers following components.

  • Oracle Home creation
  • Install ODI SDK, 
  • ODI Knowledge Modules, 
  • ODI Studio, 
  • ODI Standalone Agent, 
  • ODI JEE, 
  • Oracle DataDirect Hive Driver
  • SOA All Client Libraries
  • Repository Creation Utility


ODI Installation
05:58

Create ODI repositories using Oracle provided repository creation utility.

This lecture explains how to create following schema in ODI repository database

  • Master Schema
  • Work Schema
  • OPSS Schema
  • OPSS Audit Schema
Repository Creation
05:43

Fusion Middleware configuration is important step in ODI Enterprise installation. This step is required  specially if you are going to use Standalone collocated agent or JEE agent.

This lecture explains how to configure the following components 

  • Administrator Server
  • Node Manager
  • Managed ODI Server
  • Cluster
  • Standalone Collocated Agent and JEE Agent
Domain Creation
11:14
  • Start Node Manger
  • Start Web logic server
  • Login to Weblogic Admin Console and monitor servers.
  • Start Manged ODI Server
Start Node Manager and Servers
02:46

Configure and start Standalone Colocated Agent.

  • Configure Standalone Colocated Agent
  • Start Standalone Colocated  Agent through command prompt
  • Test the Standalone Colocated Agent


Standalone Colocated Agent
02:43
  • Configure JEE Agent
  • Start JEE Agent through Weblogic Admin Console
  • Test the JEE Agent
JEE Agent
03:12

In this lecture you will learn how to resolve  ERROR ODI-1419 or ERROR ODI-1131 errors.

ERROR ODI-1419 Warning to connect to agent OracleDIAgent1
00:09

This Quiz will test your knowledge on ODI Architecture and ODI Enterprise Installation

ODI Installation
10 questions
+ Operation
2 lectures 09:09

In this lecture, you will start ODI Studio and create connection with repository.

Start ODI Studio and Create Connection
00:54

This lecture explains how to connect ODI with other data sources like file system and Oracle Database.

Preview 08:15
+ Support
2 lectures 30:41
  • Transfer data from a flat file to Oracle RDBMS table. 
  • Define physical and logical architecture in Topology. 
  • Create Project. Import Knowledge modules. 
  • Create Models and data store. 
  • Reverse engineer the file attributes and target table meta data. 
  • Create mapping between source file and target table. 
  • Run the mapping. Monitor the run in operator tab.
Project (Part1): Transfer data from flat file to Oracle RDBMS table.
15:28
  • Transfer data from a flat file to Oracle RDBMS table. 
  • Define physical and logical architecture in Topology. 
  • Create Project. Import Knowledge modules. 
  • Create Models and data store. 
  • Reverse engineer the file attributes and target table meta data. 
  • Create mapping between source file and target table. 
  • Run the mapping. Monitor the run in operator tab.
Project (Part2): Transfer data from flat file to Oracle RDBMS table.
15:13