We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, 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."What I like the most is that we have to deal with less while writing the queries."
"Deployment was simple and straightforward."
"Has a good visual tool for data mapping."
"I like the automated scheduling feature."
"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 works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"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."
"In the end, you have structured, proper data for use in an integrated BI solution."
"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."
"This product is easy to install and it can be done in a few hours."
"The product’s flexibility is valuable."
"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."
"It is a scalable and versatile solution."
"The scalability is excellent."
"It is easy to integrate the solution with other tools."
"The product is easy to install and configure. It is one of the best tools for data integration."
"This solution has improved our overall time to value for data ingestion."
"The standout feature for me is the user-friendly nature of the components."
"The solution's technical support is responsive and helpful."
"There are many architectures: hybrid, cloud, and on-prem."
"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."
"This is a user-friendly solution that is easy to use."
"The most valuable features are definitely data integration, data preparation, and data stewardship."
"The performance of Informatica PowerCenter could improve."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"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."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The licensing is difficult."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"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."
"I would like to have easier integration with cloud platforms."
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"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."
"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."
"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 user interface could be made simpler."
"The security features could be improved."
"The solution needs more integrations."
"Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated."
"Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."
"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."
"We don't get continuous replication of the data."
"I think my biggest problem with the tool is that the errors are very hard to debug."