We performed a comparison between Informatica PowerExchange, 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."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."
"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 data transformation is the solution's most valuable feature."
"Mainstream integration and real-time integration are the best features."
"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."
"It is easy to integrate the solution with other tools."
"The most valuable feature is connectivity to data sources."
"The most valuable feature of the solution is a huge list of available connectors for a lot of different platforms, which we can use very easily."
"Customers can make use of Runtime Fabric, an RTF environment."
"The most valuable feature is the variety of characters Anypoint Platform has. It is very scalable and customizable."
"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 most valuable feature is their integrations and very good API management."
"The most valuable features of the Mule Anypoint Platform are the Flex Gateway, API management, easy-to-use, and connectors. Additionally, they are coming out with improvements to the solution when required."
"The tool's visual features are attractive."
"Whenever we need some support in our local language, we get it easily. They also have an office in Germany and if a person is unable to contact them by phone, they can go to the office in person."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"SSIS integrates well with SQL servers and Microsoft products."
"It's saved time using visualization descriptions."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"SSIS is easy to use."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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."
"Integration with the largest number of databases and other systems would be important."
"Technical support can be improved with respect to delays in ticket response time."
"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 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."
"The solution needs better integration with other tools."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"Pushdown optimization could be improved."
"The stability could be better."
"The solution is very expensive. They need to work on the pricing."
"Technical support needs to be improved, especially when you need help with more technical aspects of the solution."
"The initial setup should be made easy and the documentation should have some guidance."
"One area we'd like to see improvement in is the error logging and troubleshooting process."
"I would like to see some data integration and automation."
"The price could be improved."
"An on-premise setup requires special skills and you need a lot of professional services."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We'd like more integration capabilities."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"Improvement as per customer requirements."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"Generic processes should be used instead of custom code for each table."