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

Likelihood to Recommend

Pentaho

It is well suited for developers who may not be adept at strict coding, but have experience with GUI development. It is also better for rather simpler ETL, as the GUI interface has natural restrictions that make complex ETL problems challenging to solve. It may also be well suited for companies on a budget, as the free version still has enough features to be reasonably useful.
No photo available

SSIS

SQL Server Integration Services is extremely well built for creating packages to run ETL operations in environments where the structure of the source and/or destination data never or rarely changes, however, it tends to be difficult to maintain packages in production environments where the structure of the data changes frequently.
No photo available

Feature Rating Comparison

BI Standard Reporting

Pentaho
7.6
SSIS
Pixel Perfect reports
Pentaho
7.6
SSIS
Customizable dashboards
Pentaho
8.0
SSIS
Report Formatting Templates
Pentaho
7.3
SSIS

Ad-hoc Reporting

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

Report Output and Scheduling

Pentaho
6.8
SSIS
Publish to Web
Pentaho
6.2
SSIS
Publish to PDF
Pentaho
7.7
SSIS
Report Versioning
Pentaho
6.8
SSIS
Report Delivery Scheduling
Pentaho
7.1
SSIS
Delivery to Remote Servers
Pentaho
6.2
SSIS

Data Discovery and Visualization

Pentaho
6.3
SSIS
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.3
SSIS
Location Analytics / Geographic Visualization
Pentaho
6.7
SSIS
Predictive Analytics
Pentaho
5.8
SSIS

Access Control and Security

Pentaho
7.2
SSIS
Multi-User Support (named login)
Pentaho
7.5
SSIS
Role-Based Security Model
Pentaho
7.2
SSIS
Multiple Access Permission Levels (Create, Read, Delete)
Pentaho
7.2
SSIS
Single Sign-On (SSO)
Pentaho
6.9
SSIS

Mobile Capabilities

Pentaho
6.4
SSIS
Responsive Design for Web Access
Pentaho
6.2
SSIS
Dedicated iOS Application
Pentaho
6.4
SSIS
Dedicated Android Application
Pentaho
6.4
SSIS
Dashboard / Report / Visualization Interactivity on Mobile
Pentaho
6.6
SSIS

Application Program Interfaces (APIs) / Embedding

Pentaho
6.2
SSIS
REST API
Pentaho
7.2
SSIS
Javascript API
Pentaho
6.7
SSIS
iFrames
Pentaho
5.6
SSIS
Java API
Pentaho
6.2
SSIS
Themeable User Interface (UI)
Pentaho
5.5
SSIS
Customizable Platform (Open Source)
Pentaho
6.3
SSIS

Data Source Connection

Pentaho
SSIS
8.3
Connect to traditional data sources
Pentaho
SSIS
9.3
Connecto to Big Data and NoSQL
Pentaho
SSIS
7.2

Data Transformations

Pentaho
SSIS
8.8
Simple transformations
Pentaho
SSIS
9.8
Complex transformations
Pentaho
SSIS
7.9

Data Modeling

Pentaho
SSIS
7.2
Data model creation
Pentaho
SSIS
8.1
Metadata management
Pentaho
SSIS
6.8
Business rules and workflow
Pentaho
SSIS
8.1
Collaboration
Pentaho
SSIS
5.7
Testing and debugging
Pentaho
SSIS
7.0

Data Governance

Pentaho
SSIS
7.8
Integration with data quality tools
Pentaho
SSIS
8.1
Integration with MDM tools
Pentaho
SSIS
7.5

Pros

Pentaho

  • Great visualizations. Much like SSIS, the component-based model of ETL is easy to see at-a-glance in order to understand what is going on.
  • Easy roll-ups. It is very easy to encapsulate logic into separate jobs (KJBs) and transforms (KTRs), in order to group code into bite-size chunks.
  • Wide selection of tools. There are several dozen ETL steps to choose from, in a variety of different categories. Everything from file management to XML and scripting.
No photo available

SSIS

  • It handles SQL Server databases flawlessly
  • It provides a robust developer interface
  • It allows a developer to encapsulate complex scripts directly within an SSIS project or reuse scripts across projects
  • It interfaces quite well with a large number of available libraries
No photo available

Cons

Pentaho

  • Speed on ETL. Without a very complex setup, the ETL Job runs single threaded and can be slow for BIG jobs.
  • The "Report Designer" is decent, but lacks a lot of control that you might get from more mature products (like Business Objects, for instance). Sometimes to want to rotate or reformat a chart label, and it can't be done. In other cases, it can. It is not consistent. Also, 3D charts don't work in certain circumstances. Finally, charts mapped over time, in some cases, don't have the X Axis auto-scale and so all the data points are not readable.
Sandro Frattura profile photo

SSIS

  • SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
  • SSIS is not available on any environment other than Microsoft Windows
  • SSIS does not function with any database engine back-end other than Microsoft SQL Server
No photo available

Likelihood to Renew

Pentaho

Pentaho 8.8
Based on 11 answers
Pentaho continues to fulfill our needs as previously described. We are regularly finding new uses for it as we expand our business and our technology stack.
Kenneth Panacy profile photo

SSIS

SSIS 6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

Pentaho

Pentaho 5.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

SSIS

SSIS 8.2
Based on 6 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

Pentaho

No score
No answers yet
No answers on this topic

SSIS

SSIS 8.3
Based on 4 answers
You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.
No photo available

Support

Pentaho

Pentaho 9.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

SSIS

SSIS 9.0
Based on 3 answers
They are generally responsive and knowledgeable too
No photo available

Online Training

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 profile photo

SSIS

No score
No answers yet
No answers on this topic

Implementation

Pentaho

Pentaho 5.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

SSIS

SSIS 10.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

We have experience with Informatica and Talend. I think that between Talend and Pentaho it's a close fight, although I prefer, personally, Pentaho Kettle (Larger community, more resources).I think that you can say informatica is better than both of them but it is way more expensive and the differences are small. Let's say, I didn't find something I can't do with Pentaho - maybe it took a little bit more creativity or code (java / javascript).
Itamar Steinberg profile photo

SSIS

I have not used any other data transformation tools other than writing custom .exe programs. SSIS is far superior as it provides so much functionality out of the box. From data sources, transformations, error handling, parallelism, scheduling, etc.
Eddie Brady profile photo

Return on Investment

Pentaho

  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available

SSIS

  • Like any IT department, we almost always have an MS SQL license and therefore also access to this tool, though the free version also works just fine with a little less functionality.
  • Makes things like data cleaning or integration easy.
  • Scheduling and running SISS jobs can be done in many ways, very flexible.
  • Negative. I would say source control is difficult, there’s no elegant solution.
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

Add comparison