Wednesday Dec 11, 2013

Review: Oracle Data Integrator Essentials [Video]

Packt Publishing (http://www.packtpub.com/). released a new video tutorial about Oracle Data Integrator http://bit.ly/1i8k1jr  authored by Andreas Nobbmann of TrivadisAG in Switzerland.

The video is well paced and structured and in its larger parts focuses on ODI Studio, the IDE for building data integration projects. The TOC shown below is from the Packt Publishing website and while it gives  the timing for each section as +20 minutes, each item on the TOC is provided in its own 3-7 minute video, making it easy to listen and consume:

  1. The ODI Core Concepts [24:15 minutes]
    • Key ODI Concepts
    • Differentiating between ETL and ELT
    • Exploring the Graphical UI
    • ODI Basics
    • Defining Your Strategy
    • The ODI Staging Area

  2. Developing in ODI – the Core Objects [21:47minutes]
    • Organizing Your Project
    • Creating an Interface
    • Using Joins, Data Sets, Filters, and Sequences
    • Using Temporary Interfaces and Lookups

  3. Your Data Transformation Strategy – Knowledge Modules [11:06 minutes]
    • Adapting Knowledge Modules to Your Needs
    • Executing Data Transformation in an ODI Interface
    • Executing a Mapping on Your Source

  4. Workflows in ODI [19:08 minutes]
    • Creating a Workflow in ODI
    • Reusable Workflows: Procedures
    • User Functions as Useful Functions
    • Customize Development Objects in ODI

  5. Data Quality and Delta Detection [15:08 minutes]
    • Oracle Data Quality Products
    • Using Data Integrity Controls and Integrating Data Quality in ODI
    • Running EDQ
    • Delta Detection via CDC

  6. Version Management and Deployment [13:06 minutes]
    • Version Management
    • Scenarios: Smallest Deployment Units
    • Solutions
    • Export and Import

  7. Operating and Maintenance [12:51 minutes]
    • Loadplans
    • ODI Repository Tables
    • Security

  8. Additional Supporting Functions [11:11 minutes]
    • How to Automate ODI Object Creation
    • Impact and Data Lineaging
    • ODI Studio Enhancements

The videos explains the development environment and replaces lots of readings. As someone being new to the whole project of data integration I missed a chapter 0 that introduces data integration principals and concepts to put viewers into a context that allows them to follow the rest of the tutorial.

Maybe people like me are not the envisioned audience this video is recorded for. Questions I had while watching the tutorial included i) what is the end product of a Oracle DI project (a script? a service API?), ii) how is the repository installed and where iii) what is the result of data integration, is is a data loading from a source into a target? An end-to-end example would have been nice to see the problem solved by the product and how this solution then looks. 

All in all I think its a good tutorial if you are BI savvy and know what the Oracle DI Studio is good for (as it seems to be quite powerful). Given my non-BI background and using the Amazon star ranking as a shared language, I would give 3 stars. If there was a chapter 0 (missing) that introduces the concepts of data integration it would be worth a 4th star. An end-to-end example would have made me giving a 5th star in my rating.

About

The Oracle JDeveloper forum ranks in the Top 5 of the most active forums on the Oracle Technology Network (OTN).



The OTN Harvest blog is a summary of selected topics posted on the OTN Oracle JDeveloper forum.



It is an effort to turn knowledge exchange into an interesting read for developers who enjoy little nuggets of wisdom





Frank Nimphius

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today