What users are saying about

Azure Data Factory vs Pentaho

Azure Data Factory
44 Ratings
Pentaho
126 Ratings

Azure Data Factory

44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Based on 44 reviews and ratings

Pentaho

126 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Based on 126 reviews and ratings

Feature Set Ratings

    Data Source Connection

    8.9

    Azure Data Factory

    89%

    Pentaho

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Connect to traditional data sources

    9.1
    91%
    6 Ratings
    N/A
    0 Ratings

    Connecto to Big Data and NoSQL

    8.8
    88%
    6 Ratings
    N/A
    0 Ratings

    Data Transformations

    8.3

    Azure Data Factory

    83%

    Pentaho

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Simple transformations

    8.9
    89%
    6 Ratings
    N/A
    0 Ratings

    Complex transformations

    7.7
    77%
    6 Ratings
    N/A
    0 Ratings

    Data Modeling

    8.8

    Azure Data Factory

    88%

    Pentaho

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 6/6 features
    Azure Data Factory ranks higher in 6/6 features

    Data model creation

    9.3
    93%
    4 Ratings
    N/A
    0 Ratings

    Metadata management

    8.4
    84%
    5 Ratings
    N/A
    0 Ratings

    Business rules and workflow

    8.5
    85%
    6 Ratings
    N/A
    0 Ratings

    Collaboration

    9.2
    92%
    5 Ratings
    N/A
    0 Ratings

    Testing and debugging

    8.7
    87%
    6 Ratings
    N/A
    0 Ratings

    feature 1

    9.0
    90%
    2 Ratings
    N/A
    0 Ratings

    Data Governance

    8.1

    Azure Data Factory

    81%

    Pentaho

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Integration with data quality tools

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    Integration with MDM tools

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    BI Standard Reporting

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.2

    Pentaho

    82%
    Pentaho ranks higher in 3/3 features
    Pentaho ranks higher in 3/3 features

    Pixel Perfect reports

    N/A
    0 Ratings
    8.3
    83%
    18 Ratings

    Customizable dashboards

    N/A
    0 Ratings
    8.4
    84%
    18 Ratings

    Report Formatting Templates

    N/A
    0 Ratings
    7.8
    78%
    18 Ratings

    Ad-hoc Reporting

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.4

    Pentaho

    84%
    Pentaho ranks higher in 4/4 features
    Pentaho ranks higher in 4/4 features

    Drill-down analysis

    N/A
    0 Ratings
    7.8
    78%
    18 Ratings

    Formatting capabilities

    N/A
    0 Ratings
    7.8
    78%
    19 Ratings

    Integration with R or other statistical packages

    N/A
    0 Ratings
    9.0
    90%
    12 Ratings

    Report sharing and collaboration

    N/A
    0 Ratings
    9.0
    90%
    17 Ratings

    Report Output and Scheduling

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.4

    Pentaho

    84%
    Pentaho ranks higher in 5/5 features
    Pentaho ranks higher in 5/5 features

    Publish to Web

    N/A
    0 Ratings
    8.6
    86%
    18 Ratings

    Publish to PDF

    N/A
    0 Ratings
    7.8
    78%
    19 Ratings

    Report Versioning

    N/A
    0 Ratings
    8.8
    88%
    13 Ratings

    Report Delivery Scheduling

    N/A
    0 Ratings
    8.5
    85%
    17 Ratings

    Delivery to Remote Servers

    N/A
    0 Ratings
    8.4
    84%
    10 Ratings

    Data Discovery and Visualization

    Azure Data Factory

    Feature Set Not Supported
    N/A
    7.7

    Pentaho

    77%
    Pentaho ranks higher in 3/3 features
    Pentaho ranks higher in 3/3 features

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

    N/A
    0 Ratings
    7.4
    74%
    16 Ratings

    Location Analytics / Geographic Visualization

    N/A
    0 Ratings
    7.4
    74%
    16 Ratings

    Predictive Analytics

    N/A
    0 Ratings
    8.3
    83%
    14 Ratings

    Access Control and Security

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.4

    Pentaho

    84%
    Pentaho ranks higher in 4/4 features
    Pentaho ranks higher in 4/4 features

    Multi-User Support (named login)

    N/A
    0 Ratings
    8.6
    86%
    20 Ratings

    Role-Based Security Model

    N/A
    0 Ratings
    8.0
    80%
    19 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    N/A
    0 Ratings
    8.8
    88%
    18 Ratings

    Single Sign-On (SSO)

    N/A
    0 Ratings
    8.0
    80%
    10 Ratings

    Mobile Capabilities

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.3

    Pentaho

    83%
    Pentaho ranks higher in 3/3 features
    Pentaho ranks higher in 3/3 features

    Responsive Design for Web Access

    N/A
    0 Ratings
    9.1
    91%
    10 Ratings

    Mobile Application

    N/A
    0 Ratings
    7.6
    76%
    8 Ratings

    Dashboard / Report / Visualization Interactivity on Mobile

    N/A
    0 Ratings
    8.4
    84%
    11 Ratings

    Application Program Interfaces (APIs) / Embedding

    Azure Data Factory

    Feature Set Not Supported
    N/A
    8.1

    Pentaho

    81%
    Pentaho ranks higher in 6/6 features
    Pentaho ranks higher in 6/6 features

    REST API

    N/A
    0 Ratings
    8.0
    80%
    10 Ratings

    Javascript API

    N/A
    0 Ratings
    8.3
    83%
    9 Ratings

    iFrames

    N/A
    0 Ratings
    7.3
    73%
    9 Ratings

    Java API

    N/A
    0 Ratings
    8.4
    84%
    9 Ratings

    Themeable User Interface (UI)

    N/A
    0 Ratings
    8.0
    80%
    10 Ratings

    Customizable Platform (Open Source)

    N/A
    0 Ratings
    8.9
    89%
    10 Ratings

    Attribute Ratings

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

    Likelihood to Recommend

    9.0

    Azure Data Factory

    90%
    6 Ratings
    9.2

    Pentaho

    92%
    31 Ratings

    Likelihood to Renew

    Azure Data Factory

    N/A
    0 Ratings
    8.8

    Pentaho

    88%
    11 Ratings

    Usability

    Azure Data Factory

    N/A
    0 Ratings
    8.8

    Pentaho

    88%
    6 Ratings

    Support Rating

    7.0

    Azure Data Factory

    70%
    2 Ratings
    8.8

    Pentaho

    88%
    9 Ratings

    Online Training

    Azure Data Factory

    N/A
    0 Ratings
    9.5

    Pentaho

    95%
    2 Ratings

    Implementation Rating

    Azure Data Factory

    N/A
    0 Ratings
    5.0

    Pentaho

    50%
    2 Ratings

    Likelihood to Recommend

    Azure Data Factory

    Suitable for virtually any scenario that involves working with linked Service, so that it is possible to connect Azure Data Factory to storage services for SQL data in the cloud, and that it is possible to access them at any time. Serves to make the information much cleaner and have the desired formats and structures in case of working with time tracking or general employee work tracking applications, so it is easy to create accurate and aesthetically acceptable analysis for general tracking software. It is extremely useful if you do not have any data server service, as Azure Data Factory has the ability to maintain almost 90 different data connectors without the need to use a server.

    Read full review

    Murray Clear | TrustRadius Reviewer
    Murray Clear
    View all 6 answers on this topic

    Pentaho

    Pentaho is very well suited to perform data extraction & data mining from various cloud storage & transform that data using various available data models. However, the software struggles when it comes to visualizing the extracted data in an appealing manner & can be difficult for end-users to get an understanding of data tables created using those models.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 31 answers on this topic

    Pros

    Azure Data Factory

    • Easy to set up and get started.
    • Runtimes make integration with on-prem data simple and also allow for support of existing investments in SSIS.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    Pentaho

    • 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

    Ali Kazempour | TrustRadius Reviewer
    Ali Kazempour
    View all 31 answers on this topic

    Cons

    Azure Data Factory

    • Error Flagging, Details of the error code is not specific especially faced this during Azure Table load
    • Missing feature of Data exploration functionality similar to Synapse Data explorer
    • missing access to orchestrate/create stream analytics job

    Read full review

    Gorthy Rohith | TrustRadius Reviewer
    Gorthy Rohith
    View all 6 answers on this topic

    Pentaho

    • 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

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 31 answers on this topic

    Pricing Details

    Azure Data Factory

    General

    Free Trial
    —
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    —
    Entry-level set up fee?
    No

    Starting Price

    —

    Pentaho

    General

    Free Trial
    —
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    —
    Entry-level set up fee?
    No

    Starting Price

    —

    Likelihood to Renew

    Azure Data Factory

    No score
    No answers yet
    No answers on this topic

    Pentaho

    Pentaho 8.8
    Based on 11 answers
    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

    Adam O'Connor | TrustRadius Reviewer
    Adam O'Connor
    View all 11 answers on this topic

    Usability

    Azure Data Factory

    No score
    No answers yet
    No answers on this topic

    Pentaho

    Pentaho 8.8
    Based on 6 answers
    The Pentaho tools are designed so you can start playing around on your own. Of course, you will need guidance at some point, but the training teams are good at guiding new users, and the online documentation is usually pretty up-to-date.
    Some of the tools, such as the Pentaho Data Integration tool and the Pentaho Server, are pretty self-explanatory. The other tools maybe are not so quickly and obvious to use, but again, with some documentation and some customer support, you can find your way around them.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    Support Rating

    Azure Data Factory

    Azure Data Factory 7.0
    Based on 2 answers
    We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Pentaho

    Pentaho 8.8
    Based on 9 answers
    They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.

    Read full review

    Deepak Paramanand | TrustRadius Reviewer
    Deepak Paramanand
    View all 9 answers on this topic

    Online Training

    Azure Data Factory

    No score
    No answers yet
    No answers on this topic

    Pentaho

    Pentaho 9.5
    Based on 2 answers
    Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup 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 CourseThe 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

    Stephanie Dozier | TrustRadius Reviewer
    Stephanie Dozier
    View all 2 answers on this topic

    Implementation Rating

    Azure Data Factory

    No score
    No answers yet
    No answers on this topic

    Pentaho

    Pentaho 5.0
    Based on 2 answers
    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

    Deepak Paramanand | TrustRadius Reviewer
    Deepak Paramanand
    View all 2 answers on this topic

    Alternatives Considered

    Azure Data Factory

    The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.

    Read full review

    Niloofar Keshvari Nia | TrustRadius Reviewer
    Niloofar Keshvari Nia
    View all 6 answers on this topic

    Pentaho

    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

    Ilham AB | TrustRadius Reviewer
    Ilham AB
    View all 31 answers on this topic

    Return on Investment

    Azure Data Factory

    • It is very useful and make things easier
    • Debugging can improve
    • Its better suited than other products with the same objective

    Read full review

    Marco Urrea | TrustRadius Reviewer
    Marco Urrea
    View all 6 answers on this topic

    Pentaho

    • 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

    Nikhil Karkare | TrustRadius Reviewer
    Nikhil Karkare
    View all 31 answers on this topic

    Add comparison