ODI 11g in a Services Oriented Architecture. Part IV. Consuming a SOAP OBIEE web service using ODI 11g

Uli Bethke OBIEE, Oracle Data Integrator (ODI)

This post completes our series on using ODI in a web services environment. In part one of this series (Oracle Data Integrator in a Services Oriented Architecture) I had laid the groundwork and explained the basics of a SOA environment and how ODI fits into it. In part two we then looked at creating and deploying data services with ODI ...

Get a list of all of your ODI objects including the path in your project or model

Uli Bethke Oracle Data Integrator (ODI)

Below is a query that will retrieve all of the ODI objects in your project and model. It will also spit out the path where they sit in your hierarchy. Very useful if you need to know which objects have changed over the last week or if you want to track down one of the thousands of objects in your ...

ODI 11g standalone agent as a windows service

Uli Bethke Oracle Data Integrator (ODI)

In the documentation for ODI 11g you can read that you need Oracle Process Manager and Notification Server (OPMN) to create your standalone agent as a windows service. OPMN is not available as a standalone install but is installed as part of Web Tier, Oracle Portal, Forms, Reports, and Discoverer Installation, Oracle Identity Management Installation. I know you are gonna ...