July 29, 2014
Score 5 out of 10
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.
- 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.