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 most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"PowerCenter performs well during data transformation and optimization."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"Good interface, reasonable documentation."
"The solution is stable."
"The technical support is excellent."
"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."
"The most valuable feature is connectivity to data sources."
"It is easy to integrate the solution with other tools."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"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 data transformation is the solution's most valuable feature."
"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 agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"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."
"It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading."
"The Talend Studio connected to the Talend MDM (Master Data Management) is the most valuable feature. Talend Studio is used to create a job stream that connects to multiple data sources, matches, compares or creates a golden record for overall identification. It also has a good catalogue of objects that can be dragged and dropped for building models."
"The most valuable features are the ETL tools."
"The initial setup of the product was very easy."
"This is a user-friendly solution that is easy to use."
"The best thing I have found with Talend Open Studio is their major support for the lookups."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"The most valuable feature for me when it comes to this solution is that it's easy to use."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"They should release new versions for the solution's on-premises setup."
"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."
"I would like to have easier integration with cloud platforms."
"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."
"Should diversify more, maybe with a reporting and visualization utility,"
"The connectivity with T24 core banking could be improved."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The solution needs better integration with other tools."
"Pushdown optimization could be improved."
"In the next release, Open Studio should include cloud storage as an input."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
"The product could be more intuitive."
"Having additional training materials, such as a video tutorial, would be an improvement."
"Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio."
"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 features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM."
"The server-side should be completely revamped."