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.
"Once you have learned Informatica, it is very easy to use."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"Informatica PowerCenter is a very good ETL tool."
"I like the automated scheduling feature."
"We can scale the product."
"It has very good monitoring and process monitoring."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"It's scalable."
"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."
"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."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"It's completely user-friendly."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The CAEM is very useful in its modularity and portability."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The licensing is difficult."
"The solution must improve the integration with new services."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"Integration with Artificial Intelligence would benefit this solution."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Lacks ability to calculate cost of the product."
"Requires an established data center because there is no option for software as a service."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"Oracle support services are not up to the mark."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"Reverse engineering is complicated and challenging to manage."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"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."
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.