What users are saying about

Pentaho

100 Ratings

SSIS

152 Ratings

Pentaho

100 Ratings
Score 7.5 out of 101

SSIS

152 Ratings
Score 7.9 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

If you need to move data around or direct the workflow of a process, SSIS can do it. It is a very capable piece of software that I use heavily every day. You do need to be careful because you can over-utilize it for simple things. If you just need to run a piece of SQL every hour to update some values, just use the Agent Scheduler, it's easier. But if you need to automate things in a repeatable and consistent manner, SSIS is a very good product.
Greg Goss profile photo

Feature Rating Comparison

BI Standard Reporting

Pentaho
6.7
SSIS
Pixel Perfect reports
Pentaho
6.5
SSIS
Customizable dashboards
Pentaho
6.9
SSIS
Report Formatting Templates
Pentaho
6.8
SSIS

Ad-hoc Reporting

Pentaho
6.2
SSIS
Drill-down analysis
Pentaho
7.1
SSIS
Formatting capabilities
Pentaho
6.6
SSIS
Integration with R or other statistical packages
Pentaho
6.2
SSIS
Report sharing and collaboration
Pentaho
4.9
SSIS

Report Output and Scheduling

Pentaho
6.6
SSIS
Publish to Web
Pentaho
6.2
SSIS
Publish to PDF
Pentaho
7.4
SSIS
Report Versioning
Pentaho
6.5
SSIS
Report Delivery Scheduling
Pentaho
6.9
SSIS
Delivery to Remote Servers
Pentaho
6.1
SSIS

Data Discovery and Visualization

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

Access Control and Security

Pentaho
7.4
SSIS
Multi-User Support (named login)
Pentaho
7.5
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.2
SSIS

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

Pentaho
6.0
SSIS
REST API
Pentaho
6.7
SSIS
Javascript API
Pentaho
6.3
SSIS
iFrames
Pentaho
5.0
SSIS
Java API
Pentaho
5.9
SSIS
Themeable User Interface (UI)
Pentaho
5.6
SSIS
Customizable Platform (Open Source)
Pentaho
6.4
SSIS

Data Source Connection

Pentaho
SSIS
8.1
Connect to traditional data sources
Pentaho
SSIS
9.1
Connecto to Big Data and NoSQL
Pentaho
SSIS
7.1

Data Transformations

Pentaho
SSIS
8.7
Simple transformations
Pentaho
SSIS
9.3
Complex transformations
Pentaho
SSIS
8.0

Data Modeling

Pentaho
SSIS
7.5
Data model creation
Pentaho
SSIS
7.1
Metadata management
Pentaho
SSIS
6.6
Business rules and workflow
Pentaho
SSIS
8.6
Collaboration
Pentaho
SSIS
6.9
Testing and debugging
Pentaho
SSIS
8.2

Data Governance

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

Pros

  • 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
  • There are many good workflow tools and ways to control the order in which things happen. In a short amount of time, you can quickly create a package that will move data from point A to point B and have it scheduled to run 4 times a day. Or if you need error handling or other business logic, you can spend more time and completely automate repetitive tasks. Robust? Check!
  • SSIS can consume multiple sources of data. From flat files, to Excel, to Oracle, or DB2...I've been able to access multiple data types and move them in and out of SQL databases with SSIS. We had one linux system that ran a Basis database system and there was a need to have something done, but no one could figure out how to make it work. I was able to use SSIS to import files and execute code on a server that had nothing to do with SQL server. So flexible? Check!
  • We already use SQL server almost exclusively for our enterprise database needs. The fact that we already have access to this tool at no additional cost to the business is a bonus. The fact that it is powerful, even better. Value? Check!
Greg Goss profile photo

Cons

  • Report designer seems to be buggy on Windows 7
  • The interface for the report designer is out dated and difficult to navigate or use.
  • I would like to see a tool tip when hovering over options
Adam O'Connor profile photo
  • Be careful when you edit a package, if the version is above the SSMS you are using then it will not be compatible. You have to compile or edit the SSIS package in the same version of SSMS you are using.
  • To explain it a bit better if you have SQL 2014 in your laptop, pull a package for the DB server which is running SQL 2012, after you edit the package it will not be allowed in the SQL server.
  • Python, Perl scripts are still a high competition for SSIS, mostly because they are very easy to manipulate, if you need a change you can do it directly with notepad.
  • Plus Python now has an add-on called Pandas which is great for manipulating data.
Jose Pla profile photo

Likelihood to Renew

Pentaho8.8
Based on 11 answers
We have moved to homegrown ETL and have matured as a company as to what we need from a BI tool. Our focus is now rich and intuitive data visualization with blazing speed. Our customers had already used MicroStrategy/Tableau in the past so that bar was already set very high. Unfortunately Pentaho could not give us a better if not similar experience as the tools our Customers had already used.
Deepak Paramanand 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
SSIS8.0
Based on 2 answers
Easy to use, however there are functionality limits
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

Breadth of Deployment

Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.
Deepak Paramanand profile photo
No answers on this topic

Alternatives Considered

We evaluated Panorama, Cognos, MicroSrategy, Jasper Reports, Talend and homegrown solutions. Though each were awesome in their own right, none of them provided a end to end integration like we wanted. Pentaho did the job for us and more. Knowing that Pentaho was built by a team who were industry veterans made us feel comfortable that the basics were always a given and that we could always reach out to them for more. Plus Pentaho's responsiveness in providing a hands on expert to train us was a huge plus.
Deepak Paramanand profile photo
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

Collaboration and Sharing

Pentaho7.3
Based on 14 answers
Pentaho has a community online that shares the jobs and transformations. Importing/exporting the jobs is a piece of cake. Within our internal cloud, I am able to share, open, review the jobs and transformations that he has created and we can work together to finalize them. However, the access control comes with the connections themselves; if you don't have access, you don't have access and cannot do much with the tools to help shape and transform the data.
Gordon Yeh profile photo
No score
No answers yet
No answers on this topic

Data Integration

Pentaho7.3
Based on 14 answers
With a built in AR Data source connector, setting this up was very easy. Currently we are using Pentaho to connect it to our multiple-discovery platform, HR user platform and exporting data from our AR system to various consumers of the data. Once I get started, most jobs take 1-2 hours of "coding". Very easy, and I am quite excited to hear about new projects that I can utilize Pentaho to help us deliver what the customer wants.
Gordon Yeh profile photo
No score
No answers yet
No answers on this topic

Return on Investment

  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available
  • Comes free with SQL server so no additional license
  • Easy to learn and material is available for free, no need for expensive training
Waheed Abualrous, MCP, MCTS, MCE profile photo

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