What users are saying about
100 Ratings
158 Ratings
100 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101
158 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Pentaho

The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
No photo available

SSIS

Microsoft SQL Server Integration Services is suited for development by those who are NOT very experienced developers. End-users with some database experience may find the development environment easy to use allowing development of basic ETL. Experienced developers will likely feel restricted by the "Microsoft-only" interface. Additionally, many larger organizations that have made a significant investment in databases other than SQL Servers will be unable to use SSIS against those database servers.
No photo available

Feature Rating Comparison

BI Standard Reporting

Pentaho
7.0
SSIS
Pixel Perfect reports
Pentaho
6.8
SSIS
Customizable dashboards
Pentaho
7.2
SSIS
Report Formatting Templates
Pentaho
7.0
SSIS

Ad-hoc Reporting

Pentaho
6.3
SSIS
Drill-down analysis
Pentaho
7.1
SSIS
Formatting capabilities
Pentaho
6.7
SSIS
Integration with R or other statistical packages
Pentaho
6.3
SSIS
Report sharing and collaboration
Pentaho
5.0
SSIS

Report Output and Scheduling

Pentaho
6.7
SSIS
Publish to Web
Pentaho
6.2
SSIS
Publish to PDF
Pentaho
7.6
SSIS
Report Versioning
Pentaho
6.6
SSIS
Report Delivery Scheduling
Pentaho
7.0
SSIS
Delivery to Remote Servers
Pentaho
6.2
SSIS

Data Discovery and Visualization

Pentaho
6.2
SSIS
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.2
SSIS
Location Analytics / Geographic Visualization
Pentaho
6.6
SSIS
Predictive Analytics
Pentaho
5.9
SSIS

Access Control and Security

Pentaho
7.4
SSIS
Multi-User Support (named login)
Pentaho
7.6
SSIS
Role-Based Security Model
Pentaho
7.3
SSIS
Multiple Access Permission Levels (Create, Read, Delete)
Pentaho
7.4
SSIS
Single Sign-On (SSO)
Pentaho
7.1
SSIS

Mobile Capabilities

Pentaho
6.2
SSIS
Responsive Design for Web Access
Pentaho
5.7
SSIS
Dedicated iOS Application
Pentaho
6.5
SSIS
Dedicated Android Application
Pentaho
6.5
SSIS
Dashboard / Report / Visualization Interactivity on Mobile
Pentaho
6.1
SSIS

Application Program Interfaces (APIs) / Embedding

Pentaho
6.1
SSIS
REST API
Pentaho
6.8
SSIS
Javascript API
Pentaho
6.4
SSIS
iFrames
Pentaho
5.2
SSIS
Java API
Pentaho
6.0
SSIS
Themeable User Interface (UI)
Pentaho
5.6
SSIS
Customizable Platform (Open Source)
Pentaho
6.4
SSIS

Data Source Connection

Pentaho
SSIS
8.0
Connect to traditional data sources
Pentaho
SSIS
9.1
Connecto to Big Data and NoSQL
Pentaho
SSIS
6.8

Data Transformations

Pentaho
SSIS
8.7
Simple transformations
Pentaho
SSIS
9.5
Complex transformations
Pentaho
SSIS
7.9

Data Modeling

Pentaho
SSIS
7.2
Data model creation
Pentaho
SSIS
7.5
Metadata management
Pentaho
SSIS
6.8
Business rules and workflow
Pentaho
SSIS
8.5
Collaboration
Pentaho
SSIS
6.0
Testing and debugging
Pentaho
SSIS
7.3

Data Governance

Pentaho
SSIS
7.6
Integration with data quality tools
Pentaho
SSIS
7.7
Integration with MDM tools
Pentaho
SSIS
7.4

Pros

  • 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.
No photo available
  • Native data connections to SQL Server and Azure SQL DB and DW
  • Flat file processing
  • .NET C#/VB scripting
  • Ease of use in designing and implementing control flows within conditional processing and looping
David Milillo profile photo

Cons

  • Lack of support. Unlike many Microsoft products, there is not a great wealth of support out there for Pentaho on the web. It is much harder to track down solutions.
  • Non-intuitive. There is a learning curve, and there are subtle nuances to Pentaho that even experienced ETL developers will take a while to get used to.
  • Less reputable. Despite all of Pentaho's benefits, it just hasn't gotten to that critical mass in the marketplace. Thus it does not garner as much respect as Microsoft or Oracle, which in turn makes it harder to find online support. It's a vicious cycle.
No photo available
  • Integration with Access/Excel should be more seamless and less problematic
  • CASS certified address standardization
  • Higher performing Slowly Changing Dimension functionality
  • SFTP
  • Incremental loading (deletion, upsert, etc.)
  • PowerBI integration. I really really really want to be able to refresh reports via IS packages
  • More Azure administration tasks
  • Office365 and Sharepoint integration
David Milillo profile photo

Likelihood to Renew

Pentaho8.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 profile photo
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

Pentaho5.0
Based on 1 answer
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 profile photo
SSIS7.0
Based on 3 answers
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.
No photo available

Performance

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 1 answer
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
No photo available

Support

Pentaho9.9
Based on 2 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.
Deepak Paramanand profile photo
SSIS9.0
Based on 3 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chris Morgan profile photo

Online Training

Pentaho9.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 profile photo
No score
No answers yet
No answers on this topic

Implementation

Pentaho5.0
Based on 1 answer
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 profile photo
SSIS10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli profile photo

Alternatives Considered

Pentaho is not as robust or as reputable as Microsoft ETL tools, but it is great for simpler ETL solutions. It has limitations and often lacks the ability for fine-tuning, but it gets the job done and is consistently reliable. Cheaper than other products, it's a great place to start for a company interested in creating a data warehouse.
No photo available
SSIS works great with the above tools. We are a Microsoft shop so anything that fosters better integration among the various tools and platforms we use is very welcomed.
No photo available

Return on Investment

  • Because of the security issue we have had to spin up an additional reporting portal using another vendor. This means we have two reporting tools that we must maintain and support.
  • Since Pentaho is used by a limited audience it gets sidelined as a solution that requires our customers and partners to access their reporting via the web.
Stephanie Dozier profile photo
  • Various data requests have been fulfilled without much hazard using SSIS (data processing, ETL job, schedules, etc.)
  • Data related standards have been enforced on SSIS development methodology so that data quality has been improved.
  • Advanced features have been implemented using SSIS (e.g. FTP file notification) to automate some of the manual work.
No photo available

Pricing Details

Pentaho

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

SSIS

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