We performed a comparison between Informatica PowerCenter, JumpMind SymmetricDS, 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."Deployment was simple and straightforward."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It's a complete package, which is why we use this solution."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"PowerCenter performs well during data transformation and optimization."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Has a good visual tool for data mapping."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"It is fully featured. It has allowed me to do everything I wanted to do."
"The most valuable features are the ETL tools."
"The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."
"The data integration aspect of the solution is excellent."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The initial setup of the product was very easy."
"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."
"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."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The initial setup is not straightforward. You need expertise to do it."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"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 user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"The server-side should be completely revamped."
"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot."
"We don't get continuous replication of the data."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources."
"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."
"The physical appearance of the product is an area of concern where improvements are required."
"Technical support and customer service need to be improved."