Oracle Data Integrator (ODI) 12c Admin Course
4.1 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
400 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Data Integrator (ODI) 12c Admin Course to your Wishlist.

Add to Wishlist

Oracle Data Integrator (ODI) 12c Admin Course

ODI 12c Admin Course-Architecture, Enterprise Installation, Maintenance, and Support
4.1 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
400 students enrolled
Created by Sanjay Singh
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • Anyone interested in knowing about data, integration, business intelligence
  • Database Administrators (DBA), Software Engineers, Developers, Consultants, and Tech Leads
Students Who Viewed This Course Also Viewed
Curriculum For This Course
24 Lectures
02:10:46
+
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


Preview 03:59

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

  1. Oracle Home
  2. ODI Domain
Fusion Middleware Directory Structure
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
7 Lectures 37:30

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

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

ODI Installation
10 questions
+
Operation
2 Lectures 09:14

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

Start ODI Studio and Create Connection
00:59

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
About the Instructor
Sanjay Singh
4.3 Average rating
64 Reviews
594 Students
4 Courses
Oracle Certified ODI and BI Implementation Specialist

Hi, I am Sanjay!

I am IIT Bombay graduate with more than two decades of IT experience. You can call me a curious guy with fascination for data integration, analytics and ERP technologies. 

I have led several business transformation projects for Infosys, Toshiba, and Fujitsu across Europe, USA, Canada, and India.

I love teaching IT technologies.I have been teaching to my students, project team mates, customers. My students are working for several Fortune 500 companies.

All my courses are backed by several years of experience on those technologies.

Enjoy the courses. I look forward to wonderful association with you!