Oracle Data Integrator (ODI) Review

Knowledge modules can be modified to fix small issues

What is our primary use case?

To have a common ETL tool in the DW team, start a common way of ETL development, set up a process registry, and daily process flow.

How has it helped my organization?

  • It increased ETL development efficiency 1/3 in time.
  • It has a short learning curve for newcomers, compared to previous MS DTS packages and scripting.

What is most valuable?

  • Reusing existing ETL development pattern in the next similar tasks.
  • It's flexible to add new common procedures.
  • Knowledge modules can be modified to fix small issues.

What needs improvement?

  • ETL process registry solution is missing.
  • To manage dependencies between loading packages.
  • Versioning logic and release process are not well supported.

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