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 most valuable feature is connectivity to data sources."
"It is a scalable and versatile solution."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"This product is easy to install and it can be done in a few hours."
"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."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The user interface and user experience are perfectly all right."
"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."
"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."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"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."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"I would like to have easier integration with cloud platforms."
"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."
"The product's high costs can be an area of concern where improvements are required."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The connectivity with T24 core banking could be improved."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It needs easier security."
"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."
"The price needs to be lowered. It's too expensive."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The solution lacks some functions and features."
"If you have something like Cisco on top of it, you will have endless problems."
"Technical Support could be better."
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.