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

Uli Bethke OBIEE, Oracle Data Integrator (ODI)

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 are used to SOAP headers you find in tools such as soapUI you are out of luck for the ...

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

OBIEE & OBI Apps event, Dublin, Ireland, 17 September

Uli Bethke Irish BI SIG, OBIEE

There has been very little activity on the blog recently as I've been busy working on an ODI data integration project. The good thing though is that I have collected a lot of blog material. Watch out amongst others for a post on the wobbly relationship between ODI and analytic functions in the not so distant future. Anyway, as part ...

Query hints in OBIEE

Uli Bethke OBIEE

I have recently come across a post on the OTN forums on how to use hints in OBIEE. OBIEE lets you specify hints in the physical layer on a table by table basis. The problem of the user in the forum was how it is possible to hint the alias of a table in the SQL generated by Answers. This ...