Pentaho Business Analytics vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Pentaho Business Analytics
Average Rating
8.0
Number of Reviews
42
Ranking in other categories
BI (Business Intelligence) Tools (18th), Cloud Operations Analytics (4th), Reporting (14th)
SSIS
Average Rating
7.6
Number of Reviews
69
Ranking in other categories
Data Integration (3rd)
 

Mindshare comparison

As of July 2024, in the BI (Business Intelligence) Tools category, the mindshare of Pentaho Business Analytics is 0.5%, down from 0.6% compared to the previous year. The mindshare of SSIS is 0.0%, up from 0.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
Unique Categories:
Cloud Operations Analytics
50.0%
Reporting
0.5%
Data Integration
8.5%
 

Q&A Highlights

PS
Apr 10, 2020
 

Featured Reviews

Azhagarasan Annadorai - PeerSpot reviewer
Nov 27, 2023
Great automation, easy migration, and a rather simple setup
The fuzzy logic match component came in handy to identify AML suspects (anti-money laundering). The SHA key generation component helped in generating a unique identifier for our customers, without revealing personal data; especially when we send data to the AWS cloud. Regularly, we had to send the new policy data files to medical centers over email. Using Pentaho, we were able to compress the files in zip format with a password and email them to unlimited partners. We could confidently use Pentaho for sharing data with internal and external customers in mediums such as FTP servers, LAN folders (Local Area Network), email, etc. Connectivity to platforms such as snowflake is great.
BobAmy - PeerSpot reviewer
Aug 21, 2023
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"The initial setup is pretty straightforward."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"Easy to use components to create the job."
"The most valuable feature of Pentaho is the Tableau report."
"We were able to install it without any assistance from tech support."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It has good data integration and good processes."
"It's already very user-friendly and has a good dashboard."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The interface is very user-friendly."
 

Cons

"The repository should be improved."
"Version control would be a good addition."
"Pentaho Business Analytics' user interface is outdated."
"Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Logging capability is needed."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"Another concern is that Pentaho is not customizable or interactive."
"The high prices attached to the product can be an area of concern where improvements are required."
"Generic processes should be used instead of custom code for each table."
"I would like to see better technical documentation because many times information is missing."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
 

Pricing and Cost Advice

"Free and commercial versions are available."
"Pentaho is expensive ."
"We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"We have an enterprise license for this solution."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"This solution is included with the MSSQL server package."
"Our license with SSIS is annual."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
792,098 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Answers from the Community

PS
Apr 10, 2020
Apr 10, 2020
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection : 1) License cost 2) Type of data to be handled and integration with source database 3) Are we looking for cloud implementation or on-premises 4) Volume of data that we are looking at with possible transfo...
See 2 answers
Rahul Sahay - PeerSpot reviewer
Mar 18, 2020
Product recommendation depends on the business requirement and use case. Both are good products and well established in the market. Parameters to look for at the time of product selection : 1) License cost 2) Type of data to be handled and integration with source database 3) Are we looking for cloud implementation or on-premises 4) Volume of data that we are looking at with possible transformations 5) Data Quality framework 6) Scalability 7) Customer experience ie support. I am from MS background and have worked both on cloud version and on-premises version. I was able to achieve my solution using MS.
RS
Apr 10, 2020
MS SQL Server Integration Services (SSIS) is a part of the commercial MS SQL Server product. It is not a freeware. Probably Pentaho offers an open source/ freeware edition. Below may be useful: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13199248-e246-47aa-bab3-b2b73112d991/ssis-as-a-etl-tool-related-query?forum=sqlintegrationservices https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47aeed76-8466-4e9f-bb48-b912c07145df/ssis-tool-evaluation?forum=sqlintegrationservices Nowadays SSDT (SQL server data tools) is also getting popularity: https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/ssdt/release-notes-ssdt?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver15
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Computer Software Company
12%
Educational Organization
9%
Government
9%
Financial Services Firm
18%
Computer Software Company
13%
Government
7%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with references to an added number of features.
What needs improvement with Pentaho Business Analytics?
The product to me is not as user-friendly as other players in the market. It also still needs improvement in the reporting module. You will need to search for deployment examples or need to have a ...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive.
 

Also Known As

Pentaho, Kettle, Hitachi Pentaho Business Analytics
SQL Server Integration Services
 

Overview

 

Sample Customers

Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools. Updated: June 2024.
792,098 professionals have used our research since 2012.