We performed a comparison between Informatica PowerCenter, JumpMind SymmetricDS, and TIBCO BusinessWorks based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"In the end, you have structured, proper data for use in an integrated BI solution."
"I like the completeness of the way I can build ETL workflows."
"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."
"The interface is very clean and clear."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"It is fully featured. It has allowed me to do everything I wanted to do."
"The most valuable part of the solution is the ease-of-use and ease of deployment."
"XML to JSON transformations, out-of-the-box, helps to build REST services."
"Good performance and reliability."
"Areas for improvement would be the cloud fitness of the product and the ease of migrating to newer versions."
"I work in operations, so I value BusinessWorks' performance the most."
"BusinessWorks reduces development time, helping developers to focus on business logic."
"It is user friendly, it's not complex."
"One of the most valuable features is that it's a simple development. It takes a short time to get services to work."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"Integrating new tools can be tricky and challenging."
"Its scalability can be improved. It is not scalable."
"The licensing is difficult."
"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."
"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."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"The documentation could be improved."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"Improve Business Studio's stability to further minimize development time."
"I'd like to see a new cloud approach in the next release. They need to work on integrations, stability and management issues on their cloud platform."
"Technical support is average. It's not the best."
"The technical support's turnaround time is an area where TIBCO needs to consider improvements...Getting support from TIBCO on a particular issue takes a lot of turnaround time."
"Though it is a stable product, if we have an issue with the product, it gets difficult, and it gets really difficult to explain the issue to the support team. Also, it takes a long time to get resolved."
"Cloud fitness is lacking"
"Could be more user friendly in the development area."
"The Business Studio tool can be improved, which is the tool for designing the processes. Improving the Business Studio tool will make this solution more stable. It has a steep learning curve, and it is pretty tough to learn."