MS SharePoint / SQL ... Too much of a good thing?
November 20, 2018

MS SharePoint / SQL ... Too much of a good thing?

Michael Haberkern | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with MS SharePoint / SQL

MS SharePoint was the cornerstone of the business' collaboration. It was used and browsed daily by hundreds of employees, searching anything from new employees, to employee of the month, from days-off calendar to weekly-meetings. This thing was used and used well. Our business had such a demand that we had a dedicated SharePoint Engineer to develop workflows for processing documents and spreadsheets, etc...
  • Workflows
  • As a team collaboration tool
  • As a documentation datastore
  • A repository of knowledge, like a wiki page
  • It can get extremely complex, outside the knowledge of a system admin
  • Will eventually take a dedicated backend engineer
  • Can sometimes need too much work
MS SharePoint / SQL stack is better suited for enterprise solutions when there is money for licensing costs. The costs can get expensive, especially when dealing with clustering, but since they offer support, that can pay for itself if something catastrophic happens. Whereas with open source, you're kind of at the mercy of googling skills.
The interfacing works well and is fairly easy to set up. We had a dedicated engineer to work on the interfacing and he didn't complain too much, so that told me that he was getting things moving without much strain
It is almost too big a devil to deal with. With all of the capabilities, you will need a dedicated person for the SharePoint role. You can do almost anything with the application. This means that a department head who went to this meeting and saw this one thing they liked and must have for their department to be successful translates to an extra 10 hours a week of building... sigh.
MS SharePoint works well when a business wants to get rid of their antiquated intranet and upgrade to a robust experience like SharePoint. With so many workflows and options, it can get extremely complex, so be weary that once all the departments know of this product, they are going to want to have it for their department collaboration and workflow service

MS SharePoint / SQL Feature Ratings

Pixel Perfect reports
8
Customizable dashboards
9
Report Formatting Templates
9
Drill-down analysis
8
Formatting capabilities
8
Integration with R or other statistical packages
8
Report sharing and collaboration
9
Publish to Web
9
Publish to PDF
9
Report Versioning
9
Report Delivery Scheduling
9
Delivery to Remote Servers
9
Pre-built visualization formats (heatmaps, scatter plots etc.)
8
Location Analytics / Geographic Visualization
8
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Single Sign-On (SSO)
9
Responsive Design for Web Access
8
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated