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

Likelihood to Recommend

Azure Data Factory

If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources
Anonymous | TrustRadius Reviewer

Pentaho

Integration Pentaho with Hitachi Vantara is a successful idea, it has increased the speed of work in all departments of the organization. We recommend Hitachi Pentaho Enterprise Edition (Lumada DataOps Suite) to our customers in all industries, information technology, human resources, hospitals, health services, financial companies, and any organization that deals with information and databases and we believe Pentaho is one of the good options because it's agile, safe, powerful, flexible and easy to learn.
Ali Kazempour | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Azure Data Factory
8.4
Pentaho
Connect to traditional data sources
Azure Data Factory
8.2
Pentaho
Connecto to Big Data and NoSQL
Azure Data Factory
8.6
Pentaho

Data Transformations

Azure Data Factory
8.4
Pentaho
Simple transformations
Azure Data Factory
9.1
Pentaho
Complex transformations
Azure Data Factory
7.8
Pentaho

Data Modeling

Azure Data Factory
8.2
Pentaho
Data model creation
Azure Data Factory
9.0
Pentaho
Metadata management
Azure Data Factory
9.0
Pentaho
Business rules and workflow
Azure Data Factory
7.7
Pentaho
Collaboration
Azure Data Factory
9.0
Pentaho
Testing and debugging
Azure Data Factory
6.6
Pentaho

Data Governance

Azure Data Factory
7.7
Pentaho
Integration with data quality tools
Azure Data Factory
8.1
Pentaho
Integration with MDM tools
Azure Data Factory
7.2
Pentaho

BI Standard Reporting

Azure Data Factory
Pentaho
7.7
Pixel Perfect reports
Azure Data Factory
Pentaho
7.4
Customizable dashboards
Azure Data Factory
Pentaho
8.7
Report Formatting Templates
Azure Data Factory
Pentaho
7.0

Ad-hoc Reporting

Azure Data Factory
Pentaho
7.9
Drill-down analysis
Azure Data Factory
Pentaho
7.8
Formatting capabilities
Azure Data Factory
Pentaho
7.5
Integration with R or other statistical packages
Azure Data Factory
Pentaho
7.9
Report sharing and collaboration
Azure Data Factory
Pentaho
8.6

Report Output and Scheduling

Azure Data Factory
Pentaho
7.8
Publish to Web
Azure Data Factory
Pentaho
7.9
Publish to PDF
Azure Data Factory
Pentaho
8.8
Report Versioning
Azure Data Factory
Pentaho
7.9
Report Delivery Scheduling
Azure Data Factory
Pentaho
7.1
Delivery to Remote Servers
Azure Data Factory
Pentaho
7.0

Data Discovery and Visualization

Azure Data Factory
Pentaho
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Azure Data Factory
Pentaho
8.6
Location Analytics / Geographic Visualization
Azure Data Factory
Pentaho
7.7
Predictive Analytics
Azure Data Factory
Pentaho
8.4

Access Control and Security

Azure Data Factory
Pentaho
8.1
Multi-User Support (named login)
Azure Data Factory
Pentaho
8.5
Role-Based Security Model
Azure Data Factory
Pentaho
8.5
Multiple Access Permission Levels (Create, Read, Delete)
Azure Data Factory
Pentaho
7.8
Single Sign-On (SSO)
Azure Data Factory
Pentaho
7.6

Mobile Capabilities

Azure Data Factory
Pentaho
7.9
Responsive Design for Web Access
Azure Data Factory
Pentaho
8.2
Dedicated iOS Application
Azure Data Factory
Pentaho
7.5
Dedicated Android Application
Azure Data Factory
Pentaho
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Azure Data Factory
Pentaho
8.0

Application Program Interfaces (APIs) / Embedding

Azure Data Factory
Pentaho
7.9
REST API
Azure Data Factory
Pentaho
7.5
Javascript API
Azure Data Factory
Pentaho
7.6
iFrames
Azure Data Factory
Pentaho
7.2
Java API
Azure Data Factory
Pentaho
8.5
Themeable User Interface (UI)
Azure Data Factory
Pentaho
7.0
Customizable Platform (Open Source)
Azure Data Factory
Pentaho
9.2

Pros

Azure Data Factory

  • Cloud-based
  • Fast
  • Reliable
Marco Urrea | TrustRadius Reviewer

Pentaho

  • The built-in ETL tools are easy to learn, and can quickly import and transform any data you have.
  • The excellent visualizations and charts are pleasing to the eye, and looks are important in sales and marketing presentations.
  • The rollout was fast, we installed the software and were building dashboards within minutes.
Anonymous | TrustRadius Reviewer

Cons

Azure Data Factory

  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Anonymous | TrustRadius Reviewer

Pentaho

  • At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it.
  • Some of the basic features need to be enhanced such as sharing and collaboration capabilities
  • Needs to support automatically generated analytic visualizations or models
Ilham AB | TrustRadius Reviewer

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
Adam O'Connor | TrustRadius Reviewer

Usability

Azure Data Factory

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.0
Based on 2 answers
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand | TrustRadius Reviewer

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
Anonymous | TrustRadius Reviewer

Pentaho

Pentaho 9.0
Based on 5 answers
We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small.As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract. Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found. They really are TOP-NOTCH.
Sandro Frattura | TrustRadius Reviewer

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
Stephanie Dozier | TrustRadius Reviewer

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.
Deepak Paramanand | TrustRadius Reviewer

Alternatives Considered

Azure Data Factory

I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.
Marco Urrea | TrustRadius Reviewer

Pentaho

We evaluated many typical BI software vendors including Micro-strategy, JasperSoft and Tableau. Tableau would have been a top pick if it had better support for OEM. We had to compete against Tableau in many customers to try to get them to upgrade to use our analytics and found that they were very hard to displace due to how easy it is to use.The organization I worked for had been through other partnerships with Micro-strategy and I believe that may have had an impact on them not wanting to use them again, but I was not involved in the final decisions on that.
Anonymous | TrustRadius Reviewer

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
Marco Urrea | TrustRadius Reviewer

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.
Nikhil Karkare | TrustRadius Reviewer

Pricing Details

Azure Data Factory

General

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

Pentaho

General

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

Rating Summary

Likelihood to Recommend

Azure Data Factory
8.5
Pentaho
8.3

Likelihood to Renew

Azure Data Factory
Pentaho
8.8

Usability

Azure Data Factory
Pentaho
9.0

Support Rating

Azure Data Factory
7.0
Pentaho
9.0

Online Training

Azure Data Factory
Pentaho
9.5

Implementation Rating

Azure Data Factory
Pentaho
5.0

Add comparison