The Oracle Data Integrator 12c Masterstroke

Uli Bethke Oracle Data Integrator (ODI)

Visual data flows and OWB to ODI 12c migration path In their latest release of Oracle Data Integrator (ODI 12c), Oracle have addressed two main concerns of the analysts and some of their customers and partners. The first one is the unclear migration path from Oracle Warehouse Builder to Oracle Data Integrator. Another frequent concern was that the declarative design ...

ODI 11g Cookbook - The leading ETL tool now also has the best ETL book

Uli Bethke Oracle Data Integrator (ODI)

I don't know too many books or movies where the sequel is better than the original. The ODI 11g cookbook is such a rare case. It is stuffed with 60 valuable recipes that every ODI developer should know. Apart from the value of these recipes in their own right they also showcase the flexibility of ODI and can be transfered ...

Using ODI user functions to dynamically inject SQL into Interfaces

Maciek Kocon Oracle Data Integrator (ODI), Training

I’d like to share with you a recipe that demonstrates the power which the combination of ODI functions and Java BeanShell scripting techniques can provide. Before I do so I will briefly describe the issue we recently had as a background for the use case. Doesn’t matter which programming language or tool you use, it’s a widely known good practice ...

Extreme re-usability in ODI 11g (I can’t believe I am giving away this trick).

Uli Bethke Oracle Data Integrator (ODI)

Another Christmas and a second baby under my belt it’s time to get back to blogging. There were recently some good posts by David Allan and Gurcan Orhan on the power of ODI functions. David mentions correctly that ODI functions are the most underrated feature in ODI. Whenever you think of re-usability in ODI think of user functions. Functions can ...

How you can launch an ODI scenario through a web service call?

Uli Bethke Oracle Data Integrator (ODI)

ODI and Jetty The ODI 11g standalone agent now ships with its own lightweight application server (Jetty). The main reason this was included is to make it easier to execute scenarios via web service calls. In the past this was quite painful as you needed a separate application server (OC4J). The other limitation was that it was difficult (read work ...