Oracle Data Integrator (ODI) Review

It handles metadata management efficiently and exports data loads from our ERP system to our finance data warehouse.

Valuable Features:

It's highly flexible, and can interface with almost any technology. One of the best ETL tools.

Improvements to My Organization:

It has streamlined and automated data loads, and exports from our ERP system to our finance data warehouse and to Hyperion Essbase. The post-data load tie-back to the source system was also performed using this tool. The tool has also made metadata management more efficient, and automated the process from relational source to Hyperion Essbase.

Use of Solution:

I've used it for four years.

Deployment Issues:

No issues encountered.

Stability Issues:

It used to crash with large datasets.

Customer Service:

I've never had to contact them.

Previous Solutions:

This is the only ETL tool I have used and never found a need to look for another. It met all our needs.

Initial Setup:

Straighforward except for DBA involvement during installation for schema creation.

Implementation Team:

The implementation was done in-house.

Other Advice:

It's a great product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
Brian DandeneauConsultantTOP 5LEADERBOARD

Great review. I agree that it can streamline the Metadata loading process for EPM applications. Especially if you have DRM installed you can automate the front to end process just by kicking off a few batch scripts. You just have to make sure you have the licensing to do it.

17 May 16
Sign Up with Email