Oracle Data Integrator (ODI) Review

I like the separate environments for dev, test and prod from one management facility, though the GUI could be improved.


What is our primary use case?

Multiple data sources: "Most" of them, Oracle databases (some MS SQL, some Sybase, lots of files and some web services). Because the environment was overwhelmingly Oracle, ODI (we started from OWB) was a much better and cost-effective solution for us than Informatica.

How has it helped my organization?

Far more efficient and robust than OWB, (it was the natural evolution for us).

What is most valuable?

Separate environments for dev, test and prod from one management facility.

What needs improvement?

  • Click intensive on mapping
  • Lots of mouse clicking
  • GUI could be improved.

For how long have I used the solution?

Three to five years.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest