What users are saying about
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
Based on 12 reviews and ratings
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
Based on 119 reviews and ratings
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

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employeesPentaho
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.
Information Technology Adviser
Information Technology AdviserInformation Technology & Services, 1-10 employees
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
DevOps Engineer
DigitalOnUsComputer Software, 201-500 employees
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.

Verified User
Manager in Finance and Accounting
Consumer Goods Company, 10,001+ employeesCons
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.

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employeesPentaho
- 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
Senior Solution Architect
Three.Telecommunications, 501-1000 employees
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 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.
Technical Lead
Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees
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

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employeesPentaho
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.
Database Manager
Online Buddies, Inc.Internet, 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
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.
DevOps Engineer
DigitalOnUsComputer Software, 201-500 employees
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.

Verified User
Manager in Product Management
Computer Software Company, 51-200 employeesReturn 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
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