We performed a comparison between Informatica PowerCenter, 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."It's a complete package, which is why we use this solution."
"It is UI friendly and has all the advantages of an ETL tool."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"It has very good monitoring and process monitoring."
"Deployment was simple and straightforward."
"UI-based ability to create data mapping."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"PowerCenter performs well during data transformation and optimization."
"The solution's deployment and proxy processes are very good."
"MuleSoft Anypoint Platform's most valuable features are its observability and stability."
"Customers can make use of Runtime Fabric, an RTF environment."
"The solution's market place for different kinds of integration platforms is the most valuable feature."
"The flexibility has been great overall."
"This is the easiest and best tool available."
"The initial setup is quite easy because the solution has a good interface through which the configuration, mapping, and so on can be done."
"The exchange and API management features are the best in the market."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"It has the ability to easily load slowly changing dimensions."
"It's completely user-friendly."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"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."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The performance of Informatica PowerCenter could improve."
"The pricing could be improved."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Support could be better."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"MuleSoft's release calendar is rather conventional with two major, two minor releases and hotfixes in between. The competition sometimes offer more rapid release cycles and provides improved and new functionality with a faster time-to-market."
"There is not much information on the internet...The transforming message is an area in the solution that needs to be improved."
"It doesn't work well when you try using it for the processing layer."
"One area we'd like to see improvement in is the error logging and troubleshooting process."
"Mule Anypoint Platform could improve by having better integration with MDM. There are challenges when doing the interaction at this time."
"The runtime management and connectors could use some work and are vulnerable to breakage after upgrades."
"The initial setup should be made easy and the documentation should have some guidance."
"Its documentation needed a little bit of work to make it more usable. It is a platform that is used mainly by developers and other people for connecting systems. Its documentation was confusing in some areas and was not very helpful in other areas. I had to go to a consultant to get some work done, which ideally shouldn't be required."
"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 stability of the software could be improved. Sometimes, the software just crashes. "
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"We used a third party to do the implementation of ODI."
"The solution lacks some functions and features."
"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 initial setup is a bit complex compared to other tools."
"The performance of the user interface is in need of improvement."