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."The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"This product is easy to install and it can be done in a few hours."
"The data transformation is the solution's most valuable feature."
"The scalability is excellent."
"The product’s flexibility is valuable."
"It is easy to integrate the solution with other tools."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"It is an ETL tool, which does the extract, transform, and load."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The CAEM is very useful in its modularity and portability."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"Oracle provides great documentation."
"The scalability is great. It's one of the reasons we chose the solution."
"Integration with the largest number of databases and other systems would be important."
"The product is not suitable for application integration."
"The solution needs better integration with other tools."
"I would like to have easier integration with cloud platforms."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The product's high costs can be an area of concern where improvements are required."
"Pushdown optimization could be improved."
"I would like the stability to improve."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"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."
"The price needs to be lowered. It's too expensive."
"We used a third party to do the implementation of ODI."
"If you have something like Cisco on top of it, you will have endless problems."
"Technical Support could be better."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
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, Azure Data Factory, SSIS and Qlik Replicate, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, 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.