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

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