ODI Review
Anonymous | TrustRadius Reviewer
July 29, 2014

ODI Review

Score 5 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Data Integrator

Oracle Data Integrator was used to pull the Oracle BPM data into data mart. It was being used across the whole organization. It pulled the data from various sources and pushed it to a single source with very complex transformations. Master and incremental data was being loaded into the data warehouse.
  • Incremental data loads
  • Complex Transformations
  • Detailed documentation of LKM/IKM
  • Troubleshooting of failed jobs
  • More user friendly interface
  • Hierarchy flattening transformations
  • Integration issues with SAP HANA
  • LKM/IKL customization is complex
  • Processing speed issues in complex transformations
  • Easy troubleshooting
Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment.
ODI is very good tool for the small business and less complex transformation but when I have a big client and their requirement is complex then chances are that I would recommend Informatica instead of ODI.
For simple transformation and small business it is very good ELT tool but if you look for the big business and the complex transformation it has gaps to fill for example Hierarchy flattening jobs or multi language translation jobs etc. will make this tool good to use in big organizations.