Thursday, July 11, 2013

Oracle Data Integrator 11g Cookbook

Among the major ETL tools in the market , Oracle Data Integrator outshines not just for a couple of reason. Oracle has invested a lot in developing the tool after it took over from Sunopsis. The tool is placed as a part of the Oracle Fusion Middleware stack. If you are a customer who is using Oracle Warehouse Builder , then ODI is a similar tool but it is engineered for the next generation ETL with many features.

All the transformations happens on the target database as SQL ,so it is not a black box and it allows developers/administrators to look into what is going on and helps in quick debugging. ETL happening via ODI uses the resource of the target database server.

I would like to recommend a Hands-On Tutorial Book that has been published by PACKT which covers the below topics in detail.

  • Installation, Deployment, and Configuration
  • Defining the Oracle Data Integrator Security
  • Advanced Topology
  • Using Variables
  • Knowledge Module Internals
  • Inside Knowledge Modules
  • Advanced Coding Techniques
  • Package Loop and File Processing
  • XML and Web Services
  • Advanced Coding Techniques Using the SDK

This book is a quick starter for any body who wants to take a deep dive into ETL.

Popular Posts