What users are saying about
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
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.
Independent Contractor Hearing Examiner
LAWYERBESLegal Services, 201-500 employees
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.

Verified User
Analyst in Sales
Logistics & Supply Chain Company, 10,001+ employeesPros
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.

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employeesPentaho
- 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
Information Technology Adviser
Information Technology AdviserInformation Technology & Services, 1-10 employees
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
Big Data Developer
SuncorOil & Energy, 10,001+ employees
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.

Verified User
Manager in Finance and Accounting
Consumer Goods Company, 10,001+ employeesPricing 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
OpenERP Software Implementation Engineer
Ursa Information Systems IncorporatedInformation Technology and Services, 1-10 employees
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.

Verified User
Engineer in Engineering
Information Technology and Services Company, 10,001+ employeesSupport 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

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employeesPentaho
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.
Technical Lead
Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees
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
Business Data Analyst
Centex Systems Support ServicesInformation Technology and Services, 51-200 employees
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.
Technical Lead
Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees
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.
IT Operations and Support Specialist
AZEREX LLC.Information Technology & Services, 1-10 employees
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.
Senior Solution Architect
Three.Telecommunications, 501-1000 employees
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
DevOps Engineer
DigitalOnUsComputer Software, 201-500 employees
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.
Business Intelligence Analyst/Developer
CD-adapcoComputer Software, 201-500 employees