ODI snippets: Query to retrieve source and target columns in an interface

Uli Bethke Oracle Data Integrator (ODI)

The following query can be used to retrieve the source columns/tables and target columns/tables for interfaces in a specified project NOTE: BELOW QUERY IS VALID FOR ODI 10g ONLY!!! ODI 11g has introduced the concept of data sets, which invalidates below query.

In order to master scripting in ODI I recommend the following books. Java BeanShell Scripting in Java: ...

ODI Variables and the Operator Module

Uli Bethke Oracle Data Integrator (ODI)

One of the annoying things in ODI is that you can't print out the value of an ODI variable to the Operator module without a workaround. In this workaround you throw an exception in Jython or the Java BeanShell and pass the ODI variable as an argument to the exception method,e.g. in Jython you can use raise('#name_of_project.name_odi_var') to achieve this. ...

Under the hood of the Sunopsis Memory engine. Part 3.

Uli Bethke Oracle Data Integrator (ODI)

This is the final part in our series on the HSQLDB in memory engine. In the first part of this series we’ve had a look at the Sunopsis Memory Engine (SME) from a high level. In the second part we then looked at two use cases namely using Java methods directly in SQL transformations and using the in memory database ...

Under the hood of the Sunopsis Memory Engine. Part 2

Uli Bethke Oracle Data Integrator (ODI)

In the first part of this series we've had a high level look at the ODI HSQLDB in memory databasase aka the Sunopsis Memory Engine (SME). As promised we'll today have a look at one of the use cases for the SME, in-memory low data volume transformations. This could be particularly useful for temp (yellow) interfaces where you don't want ...

Under the hood of the Sunopsis Memory Engine. Part 1.

Uli Bethke Oracle Data Integrator (ODI)

Oracle Data Integrator not only uses hsqldb for its demo environment. It is also used as the in memory database for the so called Sunopsis Memory Engine. “It is possible to run HSQLDB in a way that the database is not persistent and exists entirely in random access memory. As no information is written to disk, this mode should be ...