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

How to query a whole schema or even database?! This tip will save you hours and hours of boring work.

Uli Bethke Oracle Data Integrator (ODI)

I really like this tip especially its simplicity. It has saved me hours and hours of mind numbing work in the past. The use case Imagine the following situation. You are tasked to complete a source to target map. With the help of various source system SMEs, legacy data models, and the data dictionary of the source database you have ...

Best practice of organizing interfaces and data stores into projects and models in ODI

Uli Bethke Oracle Data Integrator (ODI)

Have you ever wondered what the best way is to structure your objects in ODI into projects? Look no further. I will outline what works well for an Enterprise Data Warehouse. Let’s assume you follow the Oracle reference architecture for data warehousing and you have a couple of source systems, a staging area, a foundation layer (core data warehouse), and ...