Recent Articles

All JSON Snowflake XML
Oracle Data Integrator (ODI),

Copying and moving objects between projects in ODI

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and RecipesOne of the really annoying things about ODI is that it is…
Uli Bethke September 18, 2012
Oracle Data Integrator (ODI),

Get a list of all of your ODI objects including the path in your project or model

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and RecipesBelow is a query that will retrieve all of the ODI objects…
Uli Bethke September 17, 2012
Oracle Data Integrator (ODI),

OBIEE 11g Repository Documentation: Extracting metadata from the RPD

With OBIEE 11g there are two methods to extract metadata from the RPD. The first one uses the admintool.exe command to generate metadata. It was already around in OBIEE 10g.…
Uli Bethke March 8, 2012
Data Lineage,

Limitations ODI – OBIEE data lineage

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes We recently evaluated the ODI-OBIEE data lineage feature that was added…
Uli Bethke February 8, 2012
Oracle Data Integrator (ODI),

What's the best location for the ODI agent?

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes I am just back from a holiday in County Wexford, Ireland's…
Uli Bethke July 24, 2011
Oracle Data Integrator (ODI),

Time series in OBIEE. Analytic functions and range window as an alternative to OBIEE AGO function.

All intellectual credit for this post goes to my colleague Maciek Kocon. I am simply documenting this. We had some performance issues recently using the OBIEE AGO function for time…
Uli Bethke June 1, 2011