We performed a comparison between Informatica PowerCenter and Oracle Data Integrator ODI based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: The two solutions received similar ratings. However, users of Informatica PowerCenter report a better experience with technical support.
"The technical support is excellent."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"I like the completeness of the way I can build ETL workflows."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It is an excellent ETL tool."
"Good interface, reasonable documentation."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The scalability is great. It's one of the reasons we chose the solution."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It's scalable."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Oracle provides great documentation."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"Support could be better."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Lacks ability to calculate cost of the product."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"The initial setup is a bit complex compared to other tools."
"Oracle support services are not up to the mark."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The resource management aspect of the solution could be improved."
"It needs easier security."
"The price needs to be lowered. It's too expensive."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews. Informatica PowerCenter is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Informatica PowerExchange, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Azure Data Factory, Oracle GoldenGate and Talend Open Studio. See our Informatica PowerCenter vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.