We performed a comparison between Informatica PowerExchange, Mule Anypoint Platform, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"It is a scalable and versatile solution."
"The most valuable feature is connectivity to data sources."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"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."
"This product is easy to install and it can be done in a few hours."
"Overall, it is a pretty good product. It is also very scalable."
"When we talk about the APIs, there are multiple policies one can apply on APIs, like rate limiting policies, OWASP policies, and OWASP security policies, that can be easily configured in Mule Anypoint Platform."
"The most valuable features for us are flexibility, all the features related to connectivity with multiple connectors to the business, and the flexibility of on-premises and cloud deployments."
"Mule Anypoint Platform's valuable features are its flexibility in terms of deployment and its SaaS capabilities."
"The solution's deployment and proxy processes are very good."
"Mule Anypoint Platform is our preferred platform for integration."
"It has improved our organization a lot because of the increase in productivity, and it has simplified the development of products. MuleSoft Anypoint Platform is a highly effective tool where you can build integrations so effectively. If you establish the integration platform, it increases productivity. It helps us to do effective re-authentication, and it speeds the integration."
"The tool is very capable and offers a high performance. The tool supports batch processing and ETL processing."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"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."
"Besides loading data, we do most of our transformations in ODI."
"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 product has an ELT approach."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The product is not suitable for application integration."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The connectivity with T24 core banking could be improved."
"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."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"Pushdown optimization could be improved."
"Integration with the largest number of databases and other systems would be important."
"Lacks intelligent management data and intelligent mappings."
"It doesn't work well when you try using it for the processing layer."
"The terms of use and how it's priced has become very difficult to manage, which is forcing us to look for alternatives already - and we haven't even been using it for that long just yet."
"The initial setup should be made easy and the documentation should have some guidance."
"The solution's licensing methodologies could be improved."
"We would like an entire DevOps in place in this particular solution."
"Better documentation, in particular with respect to the initial setup, would be helpful."
"The price could be improved."
"The performance of the user interface is in need of improvement."
"Reverse engineering is complicated and challenging to manage."
"It needs easier security."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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 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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."