Monday Aug 20, 2012

Book Review Getting Started with Oracle Data Integrator 11g

The Getting Started with Oracle Data Integrator 11g: A hands On Tutorial book is a good introduction to ODI with some common examples that will be useful to many. It illustrates how data can be imported from various sources, transformed and exported to various sources with ODI. Following the step by step guide of the examples and you will have the right knowledge at the end of the book to create your own data integration solutions. The book is easy to read for novices and offers a great introduction to the world of ODI with useful tips from the authors - and there are a few of them ;-)

This book is an ideal book for somebody who wants to learn quickly about ODI, it's not a reference manual but a good introduction. It is filled with an abundance of useful info, I even discovered new information myself! Such as the Column Setup Wizard when importing flat file data. The chapter on Working with XML Files is also a useful one for anyone working in that area clearly spelling out with an example how it works.

The first and second chapters are all about the product overview and installation. Chapter 3 introduces variables which is a useful reference since it details now only how variables are defined but also where they can be used - this is a much asked question which I have seen many ask for mailing lists and forums. So good to see it included here. The fourth chapter introduces the design objects including topology, models and interfaces. There are useful notes scattered throughout the book which are worth checking out - these are little insights into useful hints on using the tool, personally these are my favorite items in the book. Chapters five, six and seven have illustrations of working with databases including Oracle, MySQL and Microsoft SQL Server covering various areas along the way from building interfaces using ODI's declarative designer, designing lookups, writing transformation expressions and KM selection. Chapters eight and nine are all about files and XML files and as I mentioned even surprised me with a few little pieces of info. Chapter 10 covers the workflow oriented objects including load plans, packages and procedures - a lot for a single chapter but an ok introduction. These 3 could easily be expanded into much, much more information. Chapter 11 covers errors in general - nice to see this too, this gives some insight of how the error handling in ODI works, and where to go to check up on errors. Finally there is an introduction to the ODI management components including the integration with Oracle's Enterprise Manager and the ODI console itself. There are some topics covered quickly such as procedures and I couldn't find any information on user functions, but on the whole it's a good start.

All in all, this book is in excellent read for somebody who wants to have a quick start in ODI. Its a useful book to dive into each chapter and have a read up on topics you don;t have to read end to end - my favorite type. Its an introduction, not a cookbook, the cookbook would be another useful companion book for ODI! This book is ideal for somebody who wants to get up and running in a short amount of time. If you interested in this book, you can get further info from Packt Publishing  here plus see Julien's earlier blog post here on discounts.

Thursday Jul 12, 2012

Discount Codes for 'Getting Started with ODI 11g: A Hands-On Tutorial' Book

If you would like to get your hands on a copy of 'Getting Started with ODI 11g: A Hands-On Tutorial', Packt Publishing provided us with discount codes you can use to buy the book from their website (

The codes are as follows :

  • odi5pbk for 15% off on print books.
  • rfk6ebk for 25% off on eBooks.

You will need to enter the respective discount codes in the “Promotional code” field and click “Update” in your shopping cart. The discount will be applied to the purchase.

Friday Jul 06, 2012

ODI 11g - Oracle Data Integrator 11g – A Hands-On Tutorial

I've have been asked by Packt publishing to review a brand new book on Oracle Data Integrator: Getting Started with Oracle Data Integrator 11g – A Hands-On Tutorial. Waiting on this book to arrive and see what goodies are inside, I'll blog a review later. The book can be found at Oracle Data Integrator 11g – A Hands-On Tutorial

Looking at the table of contents, it looks like it gives a good broad introduction (including various data formats) to the product;

  • Chapter 1: Product Overview
  • Chapter 2: Product Installation
  • Chapter 3: Using Variables
  • Chapter 4: ODI Sources, Targets, and Knowledge Modules
  • Chapter 5: Working with Databases
  • Chapter 6: Working with MySQL
  • Chapter 7: Working with Microsoft SQL Server
  • Chapter 8: Integrating File Data
  • Chapter 9: Working with XML Files
  • Chapter 10: Creating Workflows—Packages and Load Plans
  • Chapter 11: Error Management
  • Chapter 12: Managing and Monitoring ODI Components
  • Chapter 13: Concluding Remarks

Looking forward to it.


Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality


« July 2016