We performed a comparison between Informatica PowerCenter, Pentaho Data Integration and Analytics, and Talend Data Management Platform based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The setup is very simple."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"In the end, you have structured, proper data for use in an integrated BI solution."
"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."
"The most valuable features are the metadata repository and the data warehouse application console."
"It is UI friendly and has all the advantages of an ETL tool."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."
"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."
"The amount of data that it loads and processes is good."
"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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."
"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"The features that I like the most are the simplicity of the interface, and the ability to quickly develop with a predefined component."
"I think Talend is one of the easiest tools for faster implementation compared to other tools."
"We can develop our own code if we do not see the functionality we need."
"The most valuable feature is integration."
"The basic tools are easy to pick up and understand."
"I like everything about this product, but the biggest thing is the ease of use."
"The most valuable features of the Talend Data Management Platform are the components."
"The most valuable feature is the data loading and scripting language"
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Support could be better."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"It should be more cloud-centric than on-prem-centric."
"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."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"The reputation of Informatica is that it is expensive."
"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."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."
"The product needs more plugins."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"I would like to see more improvements with AS400 DB2."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"Performance and speed could be improved."
"They lack in memory capacity."
"The stability is good, but the performance is slower when I work on a huge amount of data."
"I would like to sync a project and do an upload from that current version, and then from GitLab, be able to download the latest one."
"The solution's memory sometimes bottlenecks and that can be challenging."
"I've had some issues with bugs causing crashes, especially when making changes to the system or with the monthly upgrades to Studio they've introduced."
"I'd be interested in seeing the running of Python programs and transformations from within the studio itself."
"The documentation from version to version could be more accurate."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
More Talend Data Management Platform Pricing and Cost Advice →