Oracle Data Integrator (ODI) Reviews and Pricing

it_user275139

Hyperion Applications Manager at a retailer with 1,001-5,000 employees

Jul 27, 2015

Download

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

Pros and Cons

"It has streamlined and automated data loads, and exports from our ERP system to our finance data warehouse and to Hyperion Essbase."

"It used to crash with large datasets."

What is most valuable?

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

How has it helped 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.

For how long have I used the solution?

I've used it for four years.

What was my experience with deployment of the solution?

No issues encountered.

Buyer's Guide

Oracle Data Integrator (ODI)

June 2026

Free Report: Oracle Data Integrator (ODI) Reviews and More

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.

DOWNLOAD NOW

900,747 professionals have used our research since 2012.

What do I think about the stability of the solution?

It used to crash with large datasets.

How are customer service and support?

I've never had to contact them.

Which solution did I use previously and why did I switch?

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

How was the initial setup?

Straighforward except for DBA involvement during installation for schema creation.

What about the implementation team?

The implementation was done in-house.

What other advice do I have?

It's a great product.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Brian DandeneauBusiness Process and Strategy Specialist Advisor at a consultancy with 10,001+ employees

Report as inappropriate

May 17, 2016

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.

it_user175956

BI Expert at a consultancy with 51-200 employees

Jun 1, 2015

Download

Enhancement of the export/import features needed but a strong and reliable ETL tool nevertheless.

Pros and Cons

"Go ahead it is a very good, stable and reliable product."

"Export/import isn't stable and they don't have a clear behavior."

What is most valuable?

Strong and reliable ETL tool with high performance and helpful features

What needs improvement?

Enhance export/import features and add more features (I think they enhanced it in the 12c version)

For how long have I used the solution?

More than 3 years 11g and now start working with 12c.

What was my experience with deployment of the solution?

Export/import isn't stable and they don't have a clear behavior.

What do I think about the scalability of the solution?

No issues.

Which solution did I use previously and why did I switch?

Developed a project on SSIS (SQLServer Integration Services), and used to write ETL in scripts (PL/SQL).

How was the initial setup?

Straightforward set-up.

What other advice do I have?

Go ahead it is a very good, stable and reliable product.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user485409Consultant at a tech services company with 10,001+ employees

Report as inappropriate

Jan 3, 2017

Export and import is a big pain.
Debugging is much easier as compared to informatica.
More developer friendly as compared to informatics

Buyer's Guide

Oracle Data Integrator (ODI)

June 2026

Free Report: Oracle Data Integrator (ODI) Reviews and More

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.

DOWNLOAD NOW

900,747 professionals have used our research since 2012.

it_user3876

Database Manager at a tech company with 51-200 employees

Jan 25, 2013

Download

Enhances the strategic usage of data which compromises more reliability for large data warehouses

Pros and Cons

"Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting."

"As with any big tool, truly mastering ODI may take months."

Valuable Features:

 Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.  Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.  Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.  In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.

Room for Improvement:

 As with any big tool, truly mastering ODI may take months.

Other Advice:

 Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.