Educonnhub

ODI Product Overview

ODI product architecture - Part 2

ODI product architecture - Part 3

ODI Studio - Part 2

ODI Agent

WebLogic Enterprise Manager

Execution Context - Part 1

Execution Context - Part 2

Knowledge Modules

Models

Mappings

Packages & Scenarios

Connect to Repository

Demonstration: Introduction to Oracle Data Integrator (ODI)

Variable location and scopes

Refreshing variables

Assigning a value to a variable

Referencing variables

Variables in models

Variables utilization in Package

Demonstration: Mastering Variables and Packages

Defining physical data servers

Defining Physical Schemas (Data Sources)

Defining Physical Schemas (Target Data Source)

Defining Logical Schemas and Contexts

Reverse-engineering metadata into ODI models

Reverse-engineering metadata into ODI models -Example

Custom reverse-engineering

Knowledge Modules Using Example

Detail Importing a Knowledge Module

Topology configuration - Data Server, Schema, Model Reverse Engineering

Create project & Do ODI Mappings

Perform moving the data using an ODI Mappings

Operator Navigator - Monitor ODI Mappings process

Demonstration: ODI Sources, Targets, and Knowledge Modules & Working with Database

Source MySQL Table example

Create Data Server on Source and Target

Physical Schema, Logical Schema

Reverse Engineering Models

Mappings

Monitor Mappings running process - Operator Navigator

MSSQL Database Loading by using ODI

MSSQL Loading Monitor - Operator Navigator

Demonstration: Working with Specific Databases - Microsoft SQL Server & Oracle

Demonstration: Working with Specific Databases - MySQL & Oracle