What users are saying about
9 Ratings
129 Ratings
9 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8 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

    SAS DataFlux

    Feature Set Not Supported
    N/A
    8.5

    Pentaho

    85%
    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.5
    85%
    19 Ratings

    Report Formatting Templates

    N/A
    0 Ratings
    8.3
    83%
    19 Ratings

    Ad-hoc Reporting

    SAS DataFlux

    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.3
    83%
    20 Ratings

    Integration with R or other statistical packages

    N/A
    0 Ratings
    8.9
    89%
    13 Ratings

    Report sharing and collaboration

    N/A
    0 Ratings
    9.4
    94%
    18 Ratings

    Report Output and Scheduling

    SAS DataFlux

    Feature Set Not Supported
    N/A
    8.7

    Pentaho

    87%
    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
    9.0
    90%
    14 Ratings

    Report Delivery Scheduling

    N/A
    0 Ratings
    9.1
    91%
    18 Ratings

    Delivery to Remote Servers

    N/A
    0 Ratings
    8.9
    89%
    11 Ratings

    Data Discovery and Visualization

    SAS DataFlux

    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.9
    79%
    17 Ratings

    Location Analytics / Geographic Visualization

    N/A
    0 Ratings
    8.1
    81%
    17 Ratings

    Predictive Analytics

    N/A
    0 Ratings
    8.8
    88%
    15 Ratings

    Access Control and Security

    SAS DataFlux

    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.6
    86%
    20 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    N/A
    0 Ratings
    9.3
    93%
    19 Ratings

    Single Sign-On (SSO)

    N/A
    0 Ratings
    8.0
    80%
    11 Ratings

    Mobile Capabilities

    SAS DataFlux

    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.5
    95%
    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

    SAS DataFlux

    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.9
    89%
    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.3
    83%
    11 Ratings

    Customizable Platform (Open Source)

    N/A
    0 Ratings
    9.3
    93%
    11 Ratings

    Attribute Ratings

    • SAS DataFlux is rated higher in 1 area: Likelihood to Renew
    • Pentaho is rated higher in 1 area: Likelihood to Recommend

    Likelihood to Recommend

    9.0

    SAS DataFlux

    90%
    1 Rating
    9.3

    Pentaho

    93%
    32 Ratings

    Likelihood to Renew

    10.0

    SAS DataFlux

    100%
    1 Rating
    8.8

    Pentaho

    88%
    11 Ratings

    Usability

    SAS DataFlux

    N/A
    0 Ratings
    9.2

    Pentaho

    92%
    7 Ratings

    Support Rating

    SAS DataFlux

    N/A
    0 Ratings
    9.2

    Pentaho

    92%
    10 Ratings

    Online Training

    SAS DataFlux

    N/A
    0 Ratings
    9.5

    Pentaho

    95%
    2 Ratings

    Implementation Rating

    SAS DataFlux

    N/A
    0 Ratings
    5.0

    Pentaho

    50%
    2 Ratings

    Likelihood to Recommend

    SAS

    No answers on this topic

    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

    SAS

    • dfPower Studio connects to virtually any data source, and any dfPower Studio user in any department can use dfPower Studio to profile, cleanse, integrate, enrich, monitor, and otherwise improve data quality throughout the enterprise. dfPower Architect, an innovative job flow builder, enables users to build complex management workflows quickly and logically.
    • DataFlux Integration Server supports the ability to run batch dfPower Studio jobs in a client/server environment.
    • DataFlux Integration Server for SAS additionally enables allows SAS programs to invoke DataFlux batch jobs from a SAS program and allows SAS programs to call a business service that was designed in the dfPower Studio client environment.
    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

    SAS

    • DataFlux handled all of our data integration needs. It could be considered pricey when compared to Microsoft's bundled SSIS product.
    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

    SAS DataFlux

    Starting Price

    Editions & Modules

    SAS DataFlux 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

      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

        SAS

        We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.
        Read full review

        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

        SAS

        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

        SAS

        No answers on this topic

        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

        SAS

        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

        SAS

        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

        SAS

        No answers on this topic

        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

        SAS

        • Complex data integration.
        • SAS integration.
        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