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 user interface and user experience are perfectly all right."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The product’s flexibility is valuable."
"The scalability is excellent."
"Provides a significant amount of control over the landscape and overall implementation."
"The data transformation is the solution's most valuable feature."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"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 setup was easy. All Microsoft products are easy to set up."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS' best feature is SFTP connectivity."
"It is easy to set up the product."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The performance and stability are good."
"Talend Studio has the ability to use it to ensure data quality."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool."
"The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component."
"It is user-friendly and the interface is good."
"The initial setup was quite straightforward. The deployment took between two and three days."
"The product's initial setup phase was easy."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"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."
"Should diversify more, maybe with a reporting and visualization utility,"
"The product is not suitable for application integration."
"I would like the stability to improve."
"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."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"I would like to have easier integration with cloud platforms."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would like to see better technical documentation because many times information is missing."
"Generic processes should be used instead of custom code for each table."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are 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 profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"The server-side should be completely revamped."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"The user interface could be made simpler."
"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."
"In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."