What has ODI encryption got to do with clearing the OBIEE cache???

Uli Bethke OBIEE, Oracle Data Integrator (ODI)

As part of a data mart refresh I am using nqcmd to clear the cache for the corresponding subject area in OBIEE. Thanks to John Minkjan for his post on properly documenting how the OBIEE cache can be cleared. Basically I am executing nqcmd -d AnalyticsWeb -u Hans -p Zipfel -s d:obieescriptsPurge_XXX_Cache.txt in an ODI procedure with technology set to ...

ODI - getSession("SESS_PARAMS" )

Uli Bethke Oracle Data Integrator (ODI)

In response to my article on the ODI variable debug procedure Craig Stewart has pointed out an undocumented parameter of the getSession method that does the same with one big limitation. The parameter SESS_PARAMS will print out any variables that have been passed into a scenario generated from a package. Unfortunately this is the limitation of this method. Variables that ...

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