ODI 11g Cookbook - The leading ETL tool now also has the best ETL book

Uli Bethke Oracle Data Integrator (ODI)

I don't know too many books or movies where the sequel is better than the original. The ODI 11g cookbook is such a rare case. It is stuffed with 60 valuable recipes that every ODI developer should know. Apart from the value of these recipes in their own right they also showcase the flexibility of ODI and can be transfered ...

How to query a whole schema or even database?! This tip will save you hours and hours of boring work.

Uli Bethke Oracle Data Integrator (ODI)

I really like this tip especially its simplicity. It has saved me hours and hours of mind numbing work in the past. The use case Imagine the following situation. You are tasked to complete a source to target map. With the help of various source system SMEs, legacy data models, and the data dictionary of the source database you have ...

Accessing a mapped network drive with the ODI agent as a Windows service

Uli Bethke Oracle Data Integrator (ODI)

The problem The other day we had a requirement to extract data from an Access database on a mapped network drive. For reasons too complicated to outline here, we could not use a UNC. While there is no problem to access the mapped drive from the Designer module using the Local Agent, things don't look so good if you are ...

Subselect, derived tables, and subqueries in ODI 11G

Uli Bethke Oracle Data Integrator (ODI)

I think one of the best new features in ODI 11G is the subselect/subquery feature. In ODI 10 this could only be achieved by a workaround as outlined in a previous post Using subqueries in Oracle Data Integrator. What is the advantage of a subquery? In previous versions of ODI we had to physically set down the data for each ...