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 product’s flexibility is valuable."
"It is easy to integrate the solution with other tools."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"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."
"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 most valuable feature is connectivity to data sources."
"Provides a significant amount of control over the landscape and overall implementation."
"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."
"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."
"The exchange and API management features are the best in the market."
"The flexibility has been great overall."
"The most valuable feature is their integrations and very good API management."
"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."
"I have found several things most valuable, including its very quick implementation that you can use a lot of out of the box templates, and lastly that it is a very mature product, especially in hybrid integration."
"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 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."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The solution is easy to use and developer friendly."
"The setup was easy. All Microsoft products are easy to set up."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"SSIS integrates well with SQL servers and Microsoft products."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"SSIS' best feature is SFTP connectivity."
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"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 solution could be made more user-friendly. The configurations are also quite difficult."
"The product is not suitable for application integration."
"Technical support can be improved with respect to delays in ticket response time."
"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."
"The connectivity with T24 core banking could be improved."
"The solution is very expensive. They need to work on the pricing."
"The pricing can be a little bit less."
"In order to set up a storefront, we currently rely on a third-party solution. It would greatly enhance our operations if this feature was integrated into their existing solution."
"Mule Anypoint Platform could improve by having better integration with MDM. There are challenges when doing the interaction at this time."
"One area we'd like to see improvement in is the error logging and troubleshooting process."
"The cost of the product is an area of concern where improvements are required, especially when compared to other tools, like Dell Boomi or Oracle."
"It doesn't work well when you try using it for the processing layer."
"We would like an entire DevOps in place in this particular solution."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"At one point, we did have to purchase an add-on."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Video training would be a helpful addition."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."