Oracle Data Integrator (ODI) web services (SOAP client via ODIInvokewebservice) and the OBIEE web services API.

Uli Bethke OBIEE, Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes As outlined in a previous post ODI has a built in SOAP client via the ODIInvokewebservice tool. One of its limitations is that it doesn’t run on Java 6. Another limitation is that it doesn’t like SOAP headers. So if you ...

Oracle Data Integrator: ODIInvokeWebService and Java 6

Uli Bethke Oracle Data Integrator (ODI), Web Services

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes 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 ...

Nesting ODI Substitution Methods. Part II.

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Today we look at how we can escape quotes when nesting ODI substitution method calls at different levels of the multi pass parser. As an example we will store the columns of the C$_ datastore and the columns of a target ...

Calling custom Java classes and JAR files in ODI via Jython or Java BeanShell

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes First we create a simple Java class that creates and writes to a text file and save it as FileWrite.java

Next we compile the .java class from the command line

Next we create a .jar file from the class ...