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 for Informatica PowerCenter is good."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"It has good standard features for ETL development."
"The most valuable features are the monitoring tools and the reporting manager."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"Deployment was simple and straightforward."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"It's completely user-friendly."
"It has the ability to easily load slowly changing dimensions."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The initial setup is easy."
"It is an ETL tool, which does the extract, transform, and load."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"Support could be better."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The UI is a little outdated."
"They should release new versions for the solution's on-premises setup."
"The licensing is difficult."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The documentation could be improved."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"The resource management aspect of the solution could be improved."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The price needs to be lowered. It's too expensive."
"The performance of the user interface is in need of improvement."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 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.