ODI Review
July 29, 2014
ODI Review
Score 5 out of 10
Vetted Review
Verified User
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.