Introducing G2.ai, the future of software buying.Try now
Compare Pentaho Data Integration and Power Query 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Astro by Astronomer
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Omatic Software
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
At a Glance
Market Segments
Mid-Market (41.2% of reviews)
Mid-Market (53.3% of reviews)
Entry-Level Pricing
No pricing available
No pricing available
Pentaho Data Integration
Star Rating
(17)4.3 out of 5
Market Segments
Mid-Market (41.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Pentaho Data IntegrationPower Query
Star Rating
(15)4.5 out of 5
Market Segments
Mid-Market (53.3% of reviews)
Pros & Cons
Not enough data
Entry-Level Pricing
No pricing available
Learn more about Power QuerySummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Pentaho Data Integration excels in data transformation capabilities, with a strong focus on ETL processes, while Power Query is praised for its user-friendly interface that simplifies data preparation tasks.
- Reviewers mention that Power Query offers superior ease of use, scoring 8.9 compared to Pentaho's 8.6, making it a preferred choice for users who prioritize a straightforward setup and intuitive navigation.
- G2 users highlight that Pentaho Data Integration has robust automation features, scoring 8.8, which allows for efficient scheduling and execution of data workflows, whereas Power Query's automation capabilities are less emphasized.
- Users on G2 indicate that Power Query shines in its integration with Microsoft products, making it an ideal choice for organizations already using the Microsoft ecosystem, while Pentaho offers broader integration options with various databases and big data technologies.
- Reviewers say that Pentaho's reporting features, with a score of 9.0, provide advanced analytics and visualization tools, which some users find more comprehensive compared to Power Query's reporting functionalities.
- Users report that while both products have strong data migration capabilities, Pentaho Data Integration is often favored for its ability to handle complex data workflows and transformations, which is crucial for larger enterprises.
Pricing
Entry-Level Pricing
Pentaho Data Integration
No pricing availablePower Query
No pricing availableFree Trial
Pentaho Data Integration
No trial information availablePower Query
No trial information availableRatings
Meets Requirements
8.7
15
8.7
14
Ease of Use
8.6
15
8.9
15
Ease of Setup
8.0
9
Not enough data
Ease of Admin
8.6
7
Not enough data
Quality of Support
7.2
12
8.6
14
Has the product been a good partner in doing business?
8.6
6
Not enough data
Product Direction (% positive)
9.2
14
10.0
15
Features by Category
Management
8.7
5
9.0
14
9.0
5
8.5
14
Functionality
9.7
5
8.6
14
9.7
5
8.9
14
9.3
5
8.3
14
8.3
5
8.8
14
8.7
5
8.5
14
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Agentic AI - Cloud Migration
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Functionality
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Integrations
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Processing
Not enough data
Not enough data
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Pentaho Data Integration and Power Query are categorized as ETL Tools
Unique Categories
Pentaho Data Integration is categorized as Cloud Migration, Big Data Integration Platforms, On-Premise Data Integration, Data Mapping, and Big Data Processing and Distribution
Power Query has no unique categories
Reviews
Reviewers' Company Size
Pentaho Data Integration
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Power Query
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.3%
Telecommunications
11.8%
Banking
11.8%
Internet
5.9%
Information Services
5.9%
Other
29.4%
Financial Services
13.3%
Transportation/Trucking/Railroad
6.7%
Telecommunications
6.7%
Retail
6.7%
Non-Profit Organization Management
6.7%
Other
60.0%
Alternatives
Discussions
Pentaho Data Integration has no discussions with answers
Power Query has no discussions with answers
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
