We performed a comparison between Informatica PowerExchange, SSIS, and Talend Open Studio based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable feature is connectivity to data sources."
"The data transformation is the solution's most valuable feature."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"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."
"Mainstream integration and real-time integration are the best features."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The scalability is excellent."
"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 initial setup of this solution is very straightforward."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The simplicity of the solution is great. The solution also offers excellent integration."
"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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"A very user friendly solution."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"The solution's technical support is responsive and helpful."
"We're sold on the customization part of the solution."
"There are many architectures: hybrid, cloud, and on-prem."
"This product is very easy to use."
"The most valuable features are definitely data integration, data preparation, and data stewardship."
"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."
"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."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"Pushdown optimization could be improved."
"Technical support can be improved with respect to delays in ticket response time."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"Should diversify more, maybe with a reporting and visualization utility,"
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"It would be nice if you could run SSIS on other environments besides Windows."
"We have issues with SSIS connectors while extracting data from Excel sources."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"Future releases should improve the data lineage, as it currently is not good."
"As for improvement or additional features, I would like to know how to use Java in Talend and also how to use Talend in the cloud or in big data. I would prefer to have storage directly on Talend."
"The physical appearance of the product is an area of concern where improvements are required."
"Talent consumes a lot of resources on my PC."
"The solution should offer better integration with other products."
"The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it."
"The user interface could be made simpler."
"Talend Open Studio is in Java language, and right now, you can only use the debug functionality in Java. I see that people who know programming languages other than Java currently face difficulties."
"The pricing could be lower. They should work to make it more affordable."