We performed a comparison between Informatica PowerCenter, Mule Anypoint Platform, and SSIS 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."We have found the PowerCenter and B2B data transformation most valuable."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"It's a complete package, which is why we use this solution."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"It is UI friendly and has all the advantages of an ETL tool."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The API toolkit is the solution's most valuable aspect at this time, for our organization."
"The flexibility has been great overall."
"Mule Anypoint Platform is our preferred platform for integration."
"The tool is very capable and offers a high performance. The tool supports batch processing and ETL processing."
"The community manager is the standout feature of the Mule Anypoint Platform, as it provides a platform to showcase your API to external parties. It is exceptionally user-friendly and enables external parties to easily utilize and consume the APIs."
"The ability to define multi-tiered APIs and reuse them is a fantastic platform feature."
"This is the easiest and best tool available."
"Mule works very well with Salesforce and CRMs."
"The initial setup of this solution is very straightforward."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"It's a competent product."
"SSIS is easy to use."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"Integration with Artificial Intelligence would benefit this solution."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"This product is going to decommission in the next couple of years."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"There is some room for improvement in terms of pricing."
"It has different types of subscriptions. For platinum or lower subscriptions, there are not too many things that can be done. We don't see many features. They should release a basic version that has logging and monitoring features. These features should come with Mule Anypoint Platform for free instead of making customers pay separately for these features. Its dashboard can be improved to have a lot of charts so that it is easy to visualize information. The utilization part can be improved. The dashboard is good currently, but it can be better. Other solutions like Elastic have a good dashboard, and they allow you to administer the product from the UI. Currently, for RTF, there is a different dashboard or utility. It would be good to include the same utility in the cloud solution. It would be good if there is a centralized repository that includes the links to the information about various troubleshooting issues. The documentation is there currently, and it is good, but the troubleshooting information is too scattered. We have to go to different links to find troubleshooting information. This kind of centralized repository would be helpful for new customers who are implementing this solution. It will be helpful to see different kinds of issues that can occur."
"Technical support needs to be improved, especially when you need help with more technical aspects of the solution."
"The stability could be better."
"The price could be improved."
"Adding connectors for new upcoming applications would add extra value to this product."
"An on-premise setup requires special skills and you need a lot of professional services."
"The solution's licensing methodologies could be improved."
"Pricing is one aspect of the solution that is troublesome. It's too expensive for smaller organizations."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The high prices attached to the product can be an area of concern where improvements are required."
"Tuning using this solution requires extensive expertise to improve performance."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Options for scaling could be improved."
"The solution could improve by having quicker release updates."
"We'd like them to develop data exploration more."