We performed a comparison between Alteryx Designer and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."One of the things I like about Alteryx Designer is how easy it is to connect numerous data inputs, including API connectors. This helps tremendously in reducing the time required to extract data from systems like SAP that don't have straightforward connectivity options."
"The features I found most valuable are the preparation features – the Join and the Transform."
"The product is very stable. The performance is reliable."
"Alteryx Designer is a tool that is pretty much easy to install."
"I have been using Alteryx Designer only for data modeling and data structuring."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"Alteryx is quite easy to use, learn, and understand as a product."
"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."
"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."
"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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."
"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."
"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."
"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"Improving the key-based sign-on process and making it more user-friendly would be a benefit."
"Based on my experience, the tool could be improved by providing sample reports or pre-configured workflows tailored to specific industries, like finance. It needs to integrate an AI chatbot as well."
"Its price can be improved. It is too expensive for our country. Because of its high price, we can't sell Alteryx Designer in this region. We used to be their reseller partner. There is also an additional cost for automating the data and running the flows, which makes it even more expensive. It will be very good if they can let users automate the data for free. Other solutions like Tableau provide this feature for free."
"The major concern in Alteryx Designer stems from the high costs attached to the product."
"The price of the product is an area with certain shortcomings where improvements are required."
"The only thing is sometimes it can be a bit slow."
"Alteryx Designer overall should be easier to use."
"Alteryx Designer's pricing and support could be improved."
"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."
"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."
"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."
"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."
"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."
"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."
"If you develop it on MacBook, it'll be quite a hassle."
"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."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Alteryx Designer is ranked 9th in Data Integration with 27 reviews while Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews. Alteryx Designer is rated 8.0, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Alteryx Designer writes "An easy-to-use automation solution with satisfying customer support". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". Alteryx Designer is most compared with Azure Data Factory, FME, Informatica PowerCenter, SSIS and Palantir Foundry, whereas Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. See our Alteryx Designer vs. Pentaho Data Integration and Analytics report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.