What users are saying about
114 Ratings
856 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100
114 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.8 out of 100

Likelihood to Recommend

MS SharePoint / SQL

We have used it successfully as mentioned on two large programs, but again it is an enterprise tool so I am only speaking from the standpoint of my team. Hundreds of teams across our enterprise use this every day. We keep our decision tracker out there as well as important program documents required by our SDLC process like requirements, etc. We also publish test results for the team to see. We use SharePoint to share test data across the organization as we can not just email files back and forth. We can rely on the security settings of SharePoint to allow access to only those team members that need to see the test data. And even though our test data is masked, we still control access to it. I would recommend that any team can benefit from using SharePoint and it gives a good place to store program/project files. It becomes the source of the truth and you just keep putting the most current versions and save them to SharePoint.
Gene Baker | TrustRadius Reviewer

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.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

MS SharePoint / SQL
8.0
Pentaho
7.0
Pixel Perfect reports
MS SharePoint / SQL
7.9
Pentaho
6.4
Customizable dashboards
MS SharePoint / SQL
8.4
Pentaho
8.4
Report Formatting Templates
MS SharePoint / SQL
7.7
Pentaho
6.1

Ad-hoc Reporting

MS SharePoint / SQL
8.2
Pentaho
7.2
Drill-down analysis
MS SharePoint / SQL
7.8
Pentaho
7.7
Formatting capabilities
MS SharePoint / SQL
8.3
Pentaho
6.7
Integration with R or other statistical packages
MS SharePoint / SQL
8.2
Pentaho
7.0
Report sharing and collaboration
MS SharePoint / SQL
8.6
Pentaho
7.6

Report Output and Scheduling

MS SharePoint / SQL
8.6
Pentaho
6.9
Publish to Web
MS SharePoint / SQL
9.0
Pentaho
7.3
Publish to PDF
MS SharePoint / SQL
8.6
Pentaho
8.6
Report Versioning
MS SharePoint / SQL
9.1
Pentaho
7.0
Report Delivery Scheduling
MS SharePoint / SQL
8.2
Pentaho
5.8
Delivery to Remote Servers
MS SharePoint / SQL
8.2
Pentaho
5.7

Data Discovery and Visualization

MS SharePoint / SQL
7.4
Pentaho
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
MS SharePoint / SQL
7.6
Pentaho
8.9
Location Analytics / Geographic Visualization
MS SharePoint / SQL
7.7
Pentaho
7.5
Predictive Analytics
MS SharePoint / SQL
6.9
Pentaho
7.9

Access Control and Security

MS SharePoint / SQL
9.0
Pentaho
7.4
Multi-User Support (named login)
MS SharePoint / SQL
9.1
Pentaho
8.0
Role-Based Security Model
MS SharePoint / SQL
8.9
Pentaho
8.0
Multiple Access Permission Levels (Create, Read, Delete)
MS SharePoint / SQL
9.1
Pentaho
7.0
Single Sign-On (SSO)
MS SharePoint / SQL
9.1
Pentaho
6.5

Mobile Capabilities

MS SharePoint / SQL
8.3
Pentaho
7.8
Responsive Design for Web Access
MS SharePoint / SQL
8.2
Pentaho
8.4
Dedicated iOS Application
MS SharePoint / SQL
8.6
Pentaho
7.0
Dedicated Android Application
MS SharePoint / SQL
8.4
Pentaho
7.9
Dashboard / Report / Visualization Interactivity on Mobile
MS SharePoint / SQL
8.2
Pentaho
7.9

Application Program Interfaces (APIs) / Embedding

MS SharePoint / SQL
8.2
Pentaho
7.1
REST API
MS SharePoint / SQL
8.9
Pentaho
6.7
Javascript API
MS SharePoint / SQL
8.4
Pentaho
6.5
iFrames
MS SharePoint / SQL
8.3
Pentaho
6.7
Java API
MS SharePoint / SQL
8.1
Pentaho
7.8
Themeable User Interface (UI)
MS SharePoint / SQL
8.4
Pentaho
5.7
Customizable Platform (Open Source)
MS SharePoint / SQL
7.1
Pentaho
9.2

Pros

MS SharePoint / SQL

  • Flexible - able to make any changes we would like vs traditional service desk system.
  • ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
  • Easy to use for end users.
Anonymous | TrustRadius Reviewer

Pentaho

  • Being able to use the OLAP Analyzer tool saved our organization a lot of time in not needing to develop an OLAP tool on our own.
  • The ability to customize the tool and integrate all the internationalization we required was pretty straightforward.
Anonymous | TrustRadius Reviewer

Cons

MS SharePoint / SQL

  • It is hard to setup and nightmare
  • It requires a of infrastructure, thus it could be costly because of requirement and licensing required for everything to run smoothly
  • If it is not setup and organized properly from the beginning it could be maintenance nightmare
  • It is hard to have "test" environment to do patches or similar
Anonymous | TrustRadius Reviewer

Pentaho

  • At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it.
  • Some of the basic features need to be enhanced such as sharing and collaboration capabilities
  • Needs to support automatically generated analytic visualizations or models
Ilham AB | TrustRadius Reviewer

Likelihood to Renew

MS SharePoint / SQL

MS SharePoint / SQL 8.8
Based on 7 answers
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
Tim Ritter | TrustRadius Reviewer

Pentaho

Pentaho 8.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 | TrustRadius Reviewer

Usability

MS SharePoint / SQL

MS SharePoint / SQL 7.0
Based on 2 answers
Over all very similar to other microsoft products
John Dopson | TrustRadius Reviewer

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 | TrustRadius Reviewer

Support Rating

MS SharePoint / SQL

MS SharePoint / SQL 7.0
Based on 2 answers
Microsoft have good local teams
Vadim Malkin | TrustRadius Reviewer

Pentaho

Pentaho 9.9
Based on 4 answers
We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small.As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract. Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found. They really are TOP-NOTCH.
Sandro Frattura | TrustRadius Reviewer

Online Training

MS SharePoint / SQL

No score
No answers yet
No answers on this topic

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 | TrustRadius Reviewer

Implementation Rating

MS SharePoint / SQL

MS SharePoint / SQL 7.0
Based on 2 answers
Not implemented in best practice way, there are many customizations
Vadim Malkin | TrustRadius Reviewer

Pentaho

Pentaho 5.0
Based on 2 answers
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 | TrustRadius Reviewer

Alternatives Considered

MS SharePoint / SQL

I have used both Google Drive and Zoho Docs which seem similar to MS SharePoint. The main differences I noticed as a user is that the user interfaces in both Google Drive and Zoho Docs were much more intuitive and they were much easier to navigate than MS SharePoint. There are a lot more things that you can do with MS SharePoint, but for a smaller company, it may not be worth the investment.
Anonymous | TrustRadius Reviewer

Pentaho

I was not with the company when they selected Pentaho over any other tool. As per my experience, I would recommend Pentaho. One of the reasons are that it is open source. If you know JAVA, you can create your own plugins. I have found its customer support pretty good and quick. And the most important thing is the cost. If you are not using the DI server, you can just use the community edition and it should fulfil your purpose too.
Nikhil Karkare | TrustRadius Reviewer

Return on Investment

MS SharePoint / SQL

  • I've installed SharePoint in many different industries and each industry has seen greater collaboration among their teams both locally and nationally. The ability to collaborate more efficiently has reduced the need to have employees centrally located.
  • Companies which have used SharePoint in a end user training portal have had great ROI, since they can create the content once and share with all their users who subscribe to their training service. The web content management aspect of SharePoint is a very helpful feature.
Anonymous | TrustRadius Reviewer

Pentaho

  • It's cheap. The version we have is free, so it has an immediate positive impact on ROI in that regard. However, a lot of our developers don't like it, which eats away our ability to be effective and productive.
  • It gets the job done. It may not be the most elegant tool, but for our purposes it works. There are probably better tools out there, and Pentaho has limited capabilities, but at the end of the day it works well enough.
Anonymous | TrustRadius Reviewer

Pricing Details

MS SharePoint / SQL

General

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

Pentaho

General

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

Rating Summary

Likelihood to Recommend

MS SharePoint / SQL
8.3
Pentaho
7.7

Likelihood to Renew

MS SharePoint / SQL
8.8
Pentaho
8.8

Usability

MS SharePoint / SQL
7.0
Pentaho
5.0

Support Rating

MS SharePoint / SQL
7.0
Pentaho
9.9

Online Training

MS SharePoint / SQL
Pentaho
9.5

Implementation Rating

MS SharePoint / SQL
7.0
Pentaho
5.0

Add comparison