We performed a comparison between Informatica PowerCenter, Pentaho Data Integration and Analytics, and TIBCO Cloud Integration based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"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."
"It has a Data Catalog that uses the Model repository."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"The ability to scale through partitions helped us to improve the performance."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"I like the completeness of the way I can build ETL workflows."
"The solution has a free to use community version."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"It has improved our data integration capabilities."
"The amount of data that it loads and processes is good."
"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"I am really impressed by TIBCO's integration of any level of complexity."
"I like that it is a very good integration tool with many other things. TIBCO is very good for cloud integration"
"The product's initial setup phase was easy."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"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."
"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."
"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."
"I would like to see it be able to import data from NoSQL."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
"The product needs more plugins."
"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."
"Integrations could be better. Although integration is good, we have faced some block issues."
"TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex."
"The deployment was rather complicated."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →