What users are saying about
20 Ratings
129 Ratings
20 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100
129 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Feature Set Ratings

    BI Standard Reporting

    AWS Glue

    Feature Set Not Supported
    N/A
    8.4

    Pentaho

    84%
    Pentaho ranks higher in 3/3 features

    Pixel Perfect reports

    N/A
    0 Ratings
    8.6
    86%
    19 Ratings

    Customizable dashboards

    N/A
    0 Ratings
    8.4
    84%
    19 Ratings

    Report Formatting Templates

    N/A
    0 Ratings
    8.2
    82%
    19 Ratings

    Ad-hoc Reporting

    AWS Glue

    Feature Set Not Supported
    N/A
    8.6

    Pentaho

    86%
    Pentaho ranks higher in 4/4 features

    Drill-down analysis

    N/A
    0 Ratings
    7.9
    79%
    19 Ratings

    Formatting capabilities

    N/A
    0 Ratings
    8.2
    82%
    20 Ratings

    Integration with R or other statistical packages

    N/A
    0 Ratings
    8.8
    88%
    13 Ratings

    Report sharing and collaboration

    N/A
    0 Ratings
    9.3
    93%
    18 Ratings

    Report Output and Scheduling

    AWS Glue

    Feature Set Not Supported
    N/A
    8.6

    Pentaho

    86%
    Pentaho ranks higher in 5/5 features

    Publish to Web

    N/A
    0 Ratings
    8.6
    86%
    19 Ratings

    Publish to PDF

    N/A
    0 Ratings
    7.6
    76%
    20 Ratings

    Report Versioning

    N/A
    0 Ratings
    8.9
    89%
    14 Ratings

    Report Delivery Scheduling

    N/A
    0 Ratings
    9.0
    90%
    18 Ratings

    Delivery to Remote Servers

    N/A
    0 Ratings
    8.8
    88%
    11 Ratings

    Data Discovery and Visualization

    AWS Glue

    Feature Set Not Supported
    N/A
    8.2

    Pentaho

    82%
    Pentaho ranks higher in 3/3 features

    Pre-built visualization formats (heatmaps, scatter plots etc.)

    N/A
    0 Ratings
    7.8
    78%
    17 Ratings

    Location Analytics / Geographic Visualization

    N/A
    0 Ratings
    8.0
    80%
    17 Ratings

    Predictive Analytics

    N/A
    0 Ratings
    8.7
    87%
    15 Ratings

    Access Control and Security

    AWS Glue

    Feature Set Not Supported
    N/A
    8.7

    Pentaho

    87%
    Pentaho ranks higher in 4/4 features

    Multi-User Support (named login)

    N/A
    0 Ratings
    9.0
    90%
    21 Ratings

    Role-Based Security Model

    N/A
    0 Ratings
    8.5
    85%
    20 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    N/A
    0 Ratings
    9.2
    92%
    19 Ratings

    Single Sign-On (SSO)

    N/A
    0 Ratings
    8.0
    80%
    11 Ratings

    Mobile Capabilities

    AWS Glue

    Feature Set Not Supported
    N/A
    8.6

    Pentaho

    86%
    Pentaho ranks higher in 3/3 features

    Responsive Design for Web Access

    N/A
    0 Ratings
    9.4
    94%
    11 Ratings

    Mobile Application

    N/A
    0 Ratings
    8.0
    80%
    9 Ratings

    Dashboard / Report / Visualization Interactivity on Mobile

    N/A
    0 Ratings
    8.9
    89%
    12 Ratings

    Application Program Interfaces (APIs) / Embedding

    AWS Glue

    Feature Set Not Supported
    N/A
    8.5

    Pentaho

    85%
    Pentaho ranks higher in 6/6 features

    REST API

    N/A
    0 Ratings
    8.5
    85%
    11 Ratings

    Javascript API

    N/A
    0 Ratings
    8.8
    88%
    10 Ratings

    iFrames

    N/A
    0 Ratings
    7.5
    75%
    10 Ratings

    Java API

    N/A
    0 Ratings
    8.7
    87%
    10 Ratings

    Themeable User Interface (UI)

    N/A
    0 Ratings
    8.2
    82%
    11 Ratings

    Customizable Platform (Open Source)

    N/A
    0 Ratings
    9.2
    92%
    11 Ratings

    Attribute Ratings

    • Pentaho is rated higher in 2 areas: Likelihood to Recommend, Support Rating

    Likelihood to Recommend

    8.8

    AWS Glue

    88%
    5 Ratings
    9.3

    Pentaho

    93%
    32 Ratings

    Likelihood to Renew

    AWS Glue

    N/A
    0 Ratings
    8.8

    Pentaho

    88%
    11 Ratings

    Usability

    AWS Glue

    N/A
    0 Ratings
    9.1

    Pentaho

    91%
    7 Ratings

    Support Rating

    7.0

    AWS Glue

    70%
    2 Ratings
    9.1

    Pentaho

    91%
    10 Ratings

    Online Training

    AWS Glue

    N/A
    0 Ratings
    9.5

    Pentaho

    95%
    2 Ratings

    Implementation Rating

    AWS Glue

    N/A
    0 Ratings
    5.0

    Pentaho

    50%
    2 Ratings

    Likelihood to Recommend

    Amazon AWS

    One of AWS Glue's most notable features that aid in the creation and transformation of data is its data catalog. Support, scheduling, and the automation of the data schema recognition make it superior to its competitors aside from that. It also integrates perfectly with other AWS tools. The main restriction may be integrated with systems outside of the AWS environment. It functions flawlessly with the current AWS services but not with other goods. Another potential restriction that comes to mind is that glue operates on a spark, which means the engineer needs to be conversant in the language.
    Read full review

    Hitachi Vantara

    I used this tool for a complex ETL problem where we fetched data from APIs, SQL, and Oracle. We merged and created a complex job which was able to fulfill our requirements and was able to make better business decisions based on the trends from the data. Sometimes, it's very hard to optimize jobs if you didn't work on this or similar ETL tools in past but I enjoyed it and made the best out of it.
    Read full review

    Pros

    Amazon AWS

    • It is extremely fast, easy, and self-intuitive. Though it is a suite of services, it requires pretty less time to get control over it.
    • As it is a managed service, one need not take care of a lot of underlying details. The identification of data schema, code generation, customization, and orchestration of the different job components allows the developers to focus on the core business problem without worrying about infrastructure issues.
    • It is a pay-as-you-go service. So, there is no need to provide any capacity in advance. So, it makes scheduling much easier.
    Read full review

    Hitachi Vantara

    • Integrate and synchronize with big data easily
    • Import data from any sources and different databases
    • Managing data in on-premise, hybrid and cloud environments.
    • Compatibility and flexibility of the platform with any type of scenario and any business or industry
    • Various tools in the software suite to transformation of data
    • Simple interface appearance and creative UI graphics
    Read full review

    Cons

    Amazon AWS

    • In-Stream schema registries feature people can not use this more efficiently
    • in Connections feature they can add more connectors as well
    • The crucial problem with AWS Glue is that it only works with AWS.
    Read full review

    Hitachi Vantara

    • I think the relative obscurity of the tool is a downside, not as many developers, consultants or peers you can tap into.
    • Lack of a solid user community held us back, looking at Power BI and Qlik, they have huge user communities that help each other out. Would have liked that here.
    • Smaller company means smaller sales force, and the lack of a local presence made it hard to only interact online with the account rep. Other companies have someone local who often stops by with pre-sales developers to just pitch in free of charge when they have time.
    Read full review

    Pricing Details

    AWS Glue

    Starting Price

    $0.44 billed per second, 1 minute minimum

    Editions & Modules

    AWS Glue editions and modules pricing
    EditionModules
    per DPU-Hour$0.441

    Footnotes

    1. billed per second, 1 minute minimum

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Pentaho

    Starting Price

    Editions & Modules

    Pentaho editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      Amazon AWS

      No answers on this topic

      Hitachi Vantara

      I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
      Read full review

      Usability

      Amazon AWS

      No answers on this topic

      Hitachi Vantara

      The software's ability to mine, extract & convert data into a readable actionable format works very well for organizations like ours & minimizes the risk of human error. It helps in automating daily tasks & saves a lot of time which in turn can be better utilized to analyze that data. Pentaho also helps in creating models out of said data which can be directly used to get to pain points.
      Read full review

      Support Rating

      Amazon AWS

      Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.
      Read full review

      Hitachi Vantara

      Pentaho's customer support team was one of the best I've ever seen, both from the documentation as from the engineering point of view. In cases when a critical issue related to security or performance was found, the multiple developer teams would change priorities to have them fixed as soon as possible with the next release, making our customers and users, in general, happy and satisfied. Sometimes enterprise customers would have some issues which would require some hot-fixing, and in most cases, the problems would be solved diligently.
      Read full review

      Online Training

      Amazon AWS

      No answers on this topic

      Hitachi Vantara

      Course Taken: DI1000 Pentaho Data Integration Fundamentals Setup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The Course The 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
      Read full review

      Implementation Rating

      Amazon AWS

      No answers on this topic

      Hitachi Vantara

      Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework. Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set. Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
      Read full review

      Alternatives Considered

      Amazon AWS

      AWS Glue is a managed service. It was easier for us to integrate it into our stack since we are already an AWS shop. It saved us the headache of managing a 3rd part service.
      Read full review

      Hitachi Vantara

      Since the Pentaho platform offers a range of broad functionality across data preparation and advanced analytics, it also can be easily integrated to support many data sources and machine-learning frameworks. Based on that fact, we selected Pentaho to be used in our internal department. It also supports many of our BI use cases as required by company management or the business user. Last but not least, the Pentaho license is cheaper than their competitor.
      Read full review

      Return on Investment

      Amazon AWS

      • It is costly.
      • Implementation is time consuming.
      • Data creation transformation is smooth.
      Read full review

      Hitachi Vantara

      • Pentaho has improved our overall business process.
      • Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
      • We have a started a big project using Pentaho that is going to include all the business processes in the organization.
      Read full review

      Add comparison