• Home
  • Pentaho Business Analytics vs. SSIS

Pentaho Business Analytics vs SSIS comparison

Cancel
You must select at least 2 products to compare!
Hitachi Vantara Logo

Pentaho Business Analytics

Read 42 Pentaho Business Analytics reviews
1,175 views|854 comparisons
89% willing to recommend
Microsoft Logo

SSIS

Read 69 SSIS reviews
19,568 views|15,878 comparisons
79% willing to recommend
Comparison Buyer's Guide
Download the complete report
Buyer's Guide
BI (Business Intelligence) Tools
April 2024
Executive Summary

We performed a comparison between Pentaho Business Analytics and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools.
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: April 2024).
Download the complete report
768,886 professionals have used our research since 2012.
Q&A Highlights
Question: What is the biggest difference between SSIS and Pentaho?
Answer: 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.
Read more →
Featured Review
Azhagarasan Annadorai
Great automation, easy migration, and a rather simple setup
It automated several data preparation tasks, enabled cleaner/standardized data for Tableau reports, and was used for integrating data from the... Read more →
BobAmy
Robust and does a good job of handling overload conditions
I like that SSIS lets us build programs top-down. Starting with the control section, then drilling into the details of the steps make more sense... Read more →
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable feature of Pentaho is the Tableau report.""The initial setup is pretty straightforward.""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.""We were able to install it without any assistance from tech support.""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.""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."

More Pentaho Business Analytics Pros →

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code.""We like that this solution includes a developer edition, free of charge, to allow for training.""It's already very user-friendly and has a good dashboard.""SSIS' most valuable feature is its reporting services.""It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.""The most valuable features of this solution are the fast insert and fuzzy logic matching.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""The simplicity of the solution is great. The solution also offers excellent integration."

More SSIS Pros →

Cons
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.""The repository should be improved.""Version control would be a good addition.""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.""Logging capability is needed.""Another concern is that Pentaho is not customizable or interactive.""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."

More Pentaho Business Analytics Cons →

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases.""The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time.""I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors.""The high prices attached to the product can be an area of concern where improvements are required.""There were some issues when we tried to connect it to data storage. It was a connection issue.""SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc.""It's difficult to refactor SSIS. It gets cumbersome to reuse the solution.""I would like to see better integration with Power BI."

More SSIS Cons →

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."

    • More Pentaho Business Analytics Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "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."
  • "All of my clients have this product included as part of their Microsoft license."

    • More SSIS Pricing and Cost Advice →

    report
    See Which Vendors Are Best For You
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    See Recommendations
    768,886 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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 companies are caught up in an imbrogilo as to which tool to use, what are the technology/and end business user wise differences/ do i actually need to purchase commercial edition, is there any work around etc. Differences :- In the below mentioned points, I have tried to cover functionality wise the differences a. Reports :- Jaspersoft is known for its picture pixel perfect reporting. Jasper uses ireport for designing the reports. Hence, for having reports, Jaspersoft is the most ideal candidate. Pentaho uses Pentaho Report Designer. b. Dashboards :- Pentaho provides much more capabililties, interactivity in terms of dashboards. Dashboards designed in Pentaho are far more superior in functionality, aesthetically as compared to Jaspersoft. Pentaho CE uses CDE/CDF, Pentaho EE uses PDD . Dashboard functionality is present only in the Enterprise edition of Jaspersoft. c. Pentaho is having an intermediate layer known as Xactions & hence providing much more flexibility in terms of plugin designing, integration with applications, having out of box experience etc. Xactions supports scripting and scheduling of scripts execution. Jaspersoft dosent provide that much of flexibility in terms of… Read more →
    Answers from the Community
    Philipp Scharfe
    Question: What is the biggest difference between SSIS and Pentaho?
    RajneeshShukla - PeerSpot reviewerRajneeshShukla
    Real User

    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:

    social.msdn.microsoft.com

    social.msdn.microsoft.com

    Nowadays SSDT (SQL server data tools) is also getting popularity:

    docs.microsoft.com

    docs.microsoft.com

    docs.microsoft.com

    See all 2 answers »
    Questions from the Community
    Seeking lightweight open source BI software
    Top Answer: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… more »
    Read all 8 answers   →
    What is your experience regarding pricing and costs for Pentaho Business ...
    Top Answer: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.
    Read all 4 answers   →
    What needs improvement with Pentaho Business Analytics?
    Top Answer: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… more »
    Read all 5 answers   →
    Which is better - SSIS or Informatica PowerCenter?
    Top Answer: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… more »
    Read all 2 answers   →
    What do you like most about SSIS?
    Top Answer:The product's deployment phase is easy.
    Read all 47 answers   →
    What is your experience regarding pricing and costs for SSIS?
    Top Answer: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.
    Read all 35 answers   →
    Ranking
    21st
    out of 108 in BI (Business Intelligence) Tools
    Views
    1,175
    Comparisons
    854
    Reviews
    4
    Average Words per Review
    526
    Rating
    7.0
    2nd
    out of 100 in Data Integration
    Views
    19,568
    Comparisons
    15,878
    Reviews
    35
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Also Known As
    Pentaho, Kettle, Hitachi Pentaho Business Analytics
    SQL Server Integration Services
    Learn More
    Hitachi Vantara
    Microsoft
    Overview

    Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

    Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

    The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    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
    Top Industries
    REVIEWERS
    Computer Software Company19%
    University13%
    Financial Services Firm13%
    Educational Organization6%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Government12%
    Computer Software Company11%
    Educational Organization9%
    REVIEWERS
    Financial Services Firm23%
    Government8%
    Retailer8%
    Healthcare Company8%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business50%
    Midsize Enterprise17%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise60%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    BI (Business Intelligence) Tools
    April 2024
    Download Free Report
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools. Updated: April 2024.
    DOWNLOAD NOW
    768,886 professionals have used our research since 2012.

    Pentaho Business Analytics is ranked 21st in BI (Business Intelligence) Tools with 42 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Pentaho Business Analytics is rated 8.0, while SSIS is rated 7.6. The top reviewer of Pentaho Business Analytics writes "Flexible, easy to understand, and simple to set up". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Pentaho Business Analytics is most compared with Microsoft Power BI, Databricks, Microsoft SQL Server Reporting Services, SAP Crystal Reports and Tableau, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.

    We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.