We performed a comparison between Informatica PowerCenter, Pentaho Data Integration and Analytics, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"It's a complete package, which is why we use this solution."
"It has helped us monetize."
"Has a good visual tool for data mapping."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"We have found the PowerCenter and B2B data transformation most valuable."
"It's very easy to use it to develop mappings and workflows."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"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."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"The abstraction is quite good."
"It's my understanding that the product can scale."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."
"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."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The initial setup of this solution is very straightforward."
"The product's deployment phase is easy."
"The scalability of SSIS is good."
"The performance and stability are good."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The solution is easy to use and developer friendly."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Integrating new tools can be tricky and challenging."
"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."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"There is some room for improvement in terms of pricing."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"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."
"I would like to see improvements made for real-time data processing."
"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."
"One thing that I don't like, just a little, is the backward compatibility."
"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."
"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."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"The solution could improve by having quicker release updates."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"This solution needs full support for real-time processing."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →