Limitations ODI - OBIEE data lineage

Uli Bethke Oracle Data Integrator (ODI)

We recently evaluated the ODI-OBIEE data lineage feature that was added to the most recent release of ODI 11g. As part of this evaluation we came across various limitations of this out of the box data lineage functionality. First of all we came across what I believe to be two bugs (one of them serious): 1. The data lineage feature ...

ODI 11g in a Services Oriented Architecture. Part III. Consuming a RESTful web service.

Uli Bethke Oracle Data Integrator (ODI)

Consuming web services in ODI In part one of this series (Oracle Data Integrator in a Services Oriented Architecture) I had laid the groundwork and explained the basics of a SOA environment and how ODI fits into it. In part two we then looked at creating and deploying data services with ODI 11g in Weblogic. In part three we will ...

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 ...

Oracle Data Integrator: ODIInvokeWebService and Java 6

Uli Bethke Oracle Data Integrator (ODI), Web Services

ODI has a built in SOAP client, the ODIInvokeWebService tool. However, there is one caveat when you try using this with Java 6/JDK 6. It simply doesn’t work and you will get the following error: org.apache.xerces.dom.DocumentImpl.getXmlStandalone()Z This is documented in note 1085594.1 and the suggested workaround is to fall back to an earlier version of Java. Another option of course ...