We performed a comparison between Pentaho Data Integration and Analytics, SSIS, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."
"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."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"It has improved our data integration capabilities."
"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."
"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."
"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."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The UI is very user-friendly."
"The scalability of SSIS is good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"The most valuable feature is the metadata generated code."
"Data transformations and rollups are easy to accomplish."
"The tool supports multiple target update methods."
"I found the initial setup very easy."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"I like the data vault implementations."
"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."
"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 web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."
"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 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."
"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."
"If you develop it on MacBook, it'll be quite a hassle."
"The product needs more plugins."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Generic processes should be used instead of custom code for each table."
"It hangs a lot of the time."
"The performance of this solution is not as good as other tools in the market."
"It needs more integration tools, so you can connect to different sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"No support for change data capture or delta detection - that must be custom coded ."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Earn 20 points