Oracle Data Integrator (ODI) Reviews and Pricing

Business Analyst at Paunaste OÜ

Jan 29, 2019

Knowledge modules can be modified to fix small issues

What is our primary use case?

To have a common ETL tool in the DW team, start a common way of ETL development, set up a process registry, and daily process flow.

How has it helped my organization?

It increased ETL development efficiency 1/3 in time.
It has a short learning curve for newcomers, compared to previous MS DTS packages and scripting.

What is most valuable?

Reusing existing ETL development pattern in the next similar tasks.
It's flexible to add new common procedures.
Knowledge modules can be modified to fix small issues.

What needs improvement?

ETL process registry solution is missing.
To manage dependencies between loading packages.
Versioning logic and release process are not well supported.

Buyer's Guide

Oracle Data Integrator (ODI)

June 2025

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 2025.

DOWNLOAD NOW

860,592 professionals have used our research since 2012.

For how long have I used the solution?

Three to five years.

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

David Barragan

Principal Owner at New Frontier Professionals LLC

Nov 27, 2018

Download

I like the separate environments for dev, test and prod from one management facility, though the GUI could be improved.

What is our primary use case?

Multiple data sources: "Most" of them, Oracle databases (some MS SQL, some Sybase, lots of files and some web services). Because the environment was overwhelmingly Oracle, ODI (we started from OWB) was a much better and cost-effective solution for us than Informatica.

How has it helped my organization?

Far more efficient and robust than OWB, (it was the natural evolution for us).

What is most valuable?

Separate environments for dev, test and prod from one management facility.

What needs improvement?

Click intensive on mapping
Lots of mouse clicking
GUI could be improved.

For how long have I used the solution?

Three to five years.

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

Buyer's Guide

Oracle Data Integrator (ODI)

June 2025

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 2025.

DOWNLOAD NOW

860,592 professionals have used our research since 2012.

it_user911514

Works at Momentum Consulting

Aug 5, 2018

Download

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses. It does have the ability to easily load slowly changing dimensions

Pros and Cons

"It has the ability to easily load slowly changing dimensions."

"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."

What is our primary use case?

High volume batch loads to move data from transactional systems into the decision support warehouse.

How has it helped my organization?

It worked fine, but we needed a tool that would include quality and master data seamlessly. This is more of a standalone ETL tool.

What is most valuable?

I found nothing overly amazing about this tool, although I appreciate its ability to easily load slowly changing dimensions.

What needs improvement?

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.

For how long have I used the solution?

Less than one year.

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

Dava Wang（汪燊）

Data engineer at realestate.pingan.com

Aug 1, 2018

Download

Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

Pros and Cons

"The installation of the client ODI Studio is easy."
"Besides loading data, we do most of our transformations in ODI."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."

"The stability of the software could be improved. Sometimes, the software just crashes. "

What is our primary use case?

We use ODI to integrate data from the OLTP database to the data warehouse. The source database systems including Oracle, MySQL, flat files... Our business background is OTA and the total data is about 100T.

How has it helped my organization?

In our DW/BI solution, ODI is the main tool to integrate the data as a daily batch. Besides loading data, we do most of our transformations in ODI. ODI is quick to use.

What is most valuable?

Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.

What needs improvement?

The ODI scheduler for agent sometime fails with no sign, which impact the ETL solution severely.

The property window in the ODI studio always does not refresh as it should.

Sometimes, the mapping or package automatically gets edited.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

The stability of the ODI studio is not strong enough. It crashes occasionally.

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

Informatica and SSIS are also good ETL tools besides ODI.

How was the initial setup?

The installation of the client tool: ODI studio is easy.

Which other solutions did I evaluate?

Basically the ETL tools is determined by the database.

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 NTTData

Report as inappropriate

Sep 17, 2018

Check the java heap size in the ODI params file to keep it from failing.
To the issue: You should be able to set the status in the operator to success. Without seeing what is happening that’s all I can offer. I would be happy to setup a quick session to dig in. I offer one free session per client a year.

See all 3 comments

it_user93825

Consultant at a tech consulting company with 1,001-5,000 employees

Jan 28, 2018

The enhanced security model and debugger are nice new features while the new layout is an advantage and disadvantage

The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes.

First, is there anything fancy in the installation process?

Just one note here: to be able to use ODI Studio, the enterprise installation needs to be selected (instead of the Standalone option) while launching the ODI installation program.

For the configuration part, creating a new login to ODI repository you are requested to specify a new wallet password. ODI12c provides you with a possibility to store your credentials in a wallet that is protected by a password. How much it helps to protect and manage your credentials with a single password!

Goodbye Interfaces, Welcome Mappings

First of all, we do not deal with interfaces anymore; mappings are offered to the developers instead. On this background let´s talk about common features and functions across various ETL tools, like Informatica Powercenter, which has many advantages. As the previous version of ODI and Powercenter are totally different technologies, there is no tool to convert the flow automatically. Either you need to use the Powercenter workflow manager to build a new ODI package, or you can use a Powercenter mapping to create a new ODI interface, keeping in mind all the constraints that ODI11g may have, including its inability to load multiple targets. What changes now? Source and target data tables can now be dragged and dropped to the same canvas, which was not the case for the previous version.

Example canvas with components panel:

Moreover, all objects have IN and OUT connectors. There is also a possibility to use multiple targets within the same mapping as the OUT connector can be mapped to many IN connectors. The split component may be used to direct rows to the desired destination based on particular conditions. And speaking of the split option - a new components panel has been added, containing operations like join, filter, lookup or split to simplify mapping creation (see picture above). The star icon (distinct component), enables selecting particular rows. Finally you can take advantage of the reusability of mappings, which can be applied across various projects by simply connecting to other components.

All these changes made Oracle Data Integrator more like Informatica Powercenter (or other ETL tools) when it comes to the creation of the transformation mappings. However, it’s good to remember that their main paradigm continues to be different, as ODI is still considered an ELT tool while Powercenter is a traditional ETL tool. Of course there will be supporters of both and the choice may depend on budget or functionality.

More Nice Features

We also found some other features that make our lives easier. One of them is the auto completion and syntax highlighting in expression fields. Another one is that when one column is selected all the related columns are highlighted across the mapping. The entire path for transformations is perfectly visible. Nice, isn’t it? I prefer that much more than checking every single box to track all modifications.

Undoubtedly, adding a debugger was long awaited. It provides you with options to set breakpoints, inspect the values of variables, debug sessions or data. Step by step, you can easily review your work.

We also enjoyed the enhanced security model. Security is assigned to a role and the same level of security is shared by all users belonging to that role. Additionally, ODI standalone agents are managed by WebLogic Management Framework, which gives us the benefit of centralized management. You are offered a wizard to carry out the configuration:

Agents can be controlled by Node Manager.

Any drawbacks?

As always, there is a discussion around new releases on which features are useful and which are not. Some changes, like the layout, can be considered both as an advantage and a disadvantage. In 12c this is the case for the complexity. You are now able to see more objects at the same time, providing you with some new options like the components panel, but on the other hand it makes everything less transparent and a decent screen size is needed.

To read the complete post, go to:

https://www.clearpeaks.com/blog/etl/what-are-the-ne...

Disclaimer: The company I work for is partners with Oracle and other vendors.

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

it_user804942

Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees

Jan 21, 2018

Download

Could use an add-on solution that might know how to avoid performance issues. Benefits from not having to maintain a separate ETL instance.

Pros and Cons

"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."

"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."

What is our primary use case?

We are moving data from everywhere to everywhere else all the time. We will be moving data to a cloud solution in the future and ODI seems to be able to do it as well.

How has it helped my organization?

The tool is declarative, and it only runs on the target staging databases, so I have full control over it and I can change the SQL that the tool generates. I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.

What is most valuable?

It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important.

What needs improvement?

When I do a BI type of project, I like to pick the simplest declarative solution that I can find. So ODI appeals to me at a base solution level, but that sometimes puts a lot of burden on me personally to fix all of the nuances of the platform that I am integrating to and from. Some might argue this is just a part of the job, but if there is an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it provides me value. I can see a great deal of value of ODI plus an add-on solution that might know how to avoid performance issues on the target database with, for example, the proper use of SQL functions.

For how long have I used the solution?

Less than one year.

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

it_user521808

Development Manager

Nov 22, 2017

Download

Extracts, transforms and loads the data, does the job for us

Pros and Cons

"It is an ETL tool, which does the extract, transform, and load."

"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."

What is most valuable?

It is an ETL tool, which does the extract, transform, and load.

What needs improvement?

At this point we are seeing what we need, so I don't know if there is anything, any big improvements that are needed. This is basically just transforming and loading the data. It's doing its job.

I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.

For how long have I used the solution?

We have been using it now for two years.

What do I think about the stability of the solution?

So far it has provided what we need, it's working fine.

What do I think about the scalability of the solution?

It's scalable. Right now, we have a pilot project that we started with ODI, which went fine. We will be ramping that up for the other integrations and hopefully that will all go fine.

How are customer service and technical support?

I think the support at Oracle is tremendous. We have a whole stack of Oracle products and the support with Oracle has always been very good.

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

We chose ODI because we have the Oracle Stack and we wanted to be in the Oracle space. We wanted a tool that will work long-term for Oracle, so that's why we chose ODI.

How was the initial setup?

All ODI, all the ETL tools, they have mappings and knowledge bases and the like. Based on that, I don't think it is too complicated. It is fine. There is a learning curve, but this is going to be orchestrated by IT, not by business users, so I think it's fine.

What other advice do I have?

I would definitely recommend the ODI. The reason is that now Oracle, after a long time, has put its weight behind an ETL tool, which is ODI, and so Oracle is going to stand behind it, which means that it has a long life. That's another reason which we chose it.

Informatica is a gold standard in ETL and, before ODI, Informatica used to be the king of the ETL. Now, because Oracle is putting its weight behind this tool we think that, long-term, ODI will have a better future. When we had the option of choosing an ETL tool, we went with ODI because we wanted to choose something for the long-term.

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

GaryMData Architect at World Vision

Report as inappropriate

Jan 4, 2019

Why do you think Oracle will support ODI long term any more than their prior ETL tools such as OWB or the tool they bought in the 1990s from Sagent, both of which are gone now?

Some history for you....ODI used to be a weird combination of two completely different tools - OWB which was just a PlSql generator and ODI that came from the Hyperion acquisition which ironically actually originally used Informatica and SqlServer (when Hyperion was doing it) but I know Oracle was frantically trying to re-write all that....is it still a consolidation of 2 desperate tools or now pretty much integrated?

it_user636159

Owner at a tech vendor with 11-50 employees

Nov 1, 2017

Download

Has a mapping functionality that makes the tool very open and accessible

Pros and Cons

"ODI is a very accessible tool, especially since the mapping functionality has been added."

"Technical Support could be better."

What is most valuable?

ODI is a very accessible tool, especially since the mapping functionality has been added.

How has it helped my organization?

We added DevOps to ODI.

You can use the ODI versioning or our component, and complement both with lifecycle management, fully-automated deploy and integration with issue tracking.

For how long have I used the solution?

Three years.

What was my experience with deployment of the solution?

Not with ODI itself, but with deploying programs written in ODI. That is why we developed our solution.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

No issues.

How are customer service and technical support?

Customer Service:

It could be better.

Technical Support:

It could be better.

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

OWB: We switched because the this tool was at the end of its life.

How was the initial setup?

It was straightforward.

What about the implementation team?

It was implemented in-house by experts.

What was our ROI?

Not applicable.

What's my experience with pricing, setup cost, and licensing?

It is OK.

Which other solutions did I evaluate?

No.

What other advice do I have?

It is a great tool to work with.

Disclosure: My company has a business relationship with this vendor other than being a customer. We developed a DevOps solution for ODI.