We performed a comparison between Informatica PowerExchange and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a scalable and versatile solution."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The scalability is excellent."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"Provides a significant amount of control over the landscape and overall implementation."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"The user interface and user experience are perfectly all right."
"It's scalable."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The product has an ELT approach."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"Should diversify more, maybe with a reporting and visualization utility,"
"I would like the stability to improve."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"The product's high costs can be an area of concern where improvements are required."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The price needs to be lowered. It's too expensive."
"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."
"We used a third party to do the implementation of ODI."
"The solution lacks some functions and features."
"Reverse engineering is complicated and challenging to manage."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"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."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Informatica PowerExchange is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". 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 PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Qlik Replicate, Azure Data Factory and Informatica Cloud Data Integration, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate. See our Informatica PowerExchange 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.