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

Nesting ODI Substitution Methods. Part II.

Uli Bethke Oracle Data Integrator (ODI)

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 datastore in a two dimensional java array.

As you can see, we are nesting a call to the ...

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

Uli Bethke Oracle Data Integrator (ODI)

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

We then copy and paste the .jar archive to the ODI drivers folder Next we restart the ODI ...

ODI and analytic functions (again???)

Uli Bethke analytic functions, Oracle Data Integrator (ODI)

My friend and colleague Maciej Kocon has come up with the following trick. Rather than use a user defined function to implement an analytic function such as MAX() OVER or SUM() OVER as suggested by note 807527.1 there is another way to work around the getGrpBy bug. We will take advantage of the ODI multi pass parser and hide the ...

ODI and Integrated Security/Authentication with Microsoft SQL Server

Uli Bethke MS SQL, Oracle Data Integrator (ODI)

Setting up integrated security with the SQL Server JDBC driver can be tricky. You often end up with the message “This driver is not configured for integrated authentication”. Below are the steps that you need to perform to get this to work. Note: This will only work where the ODI agent has been installed on a Windows OS. 1. Download ...