SharePoint on SQL Server
March 23, 2017

SharePoint on SQL Server

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with MS SharePoint / SQL

MS Sharepoint, utilizing SQL as the back end, is used by our organization as a single point for document storage and versioning. It also is used to host workflows and forms. We also use it extensively for hosting internal IT documentation.
  • Document versioning - provides an easy way to view the history of a document and allow for collaboration
  • Customization - easy to build custom pages to accomplish what you need
  • Integration - works well with the rest of MS Office
  • Search is not up to modern standards
  • Database storage of all documents as BLOBs makes the databases overly large
  • Settings required make a dedicated SQL instance required
SharePoint works well in a full Microsoft environment that needs a central repository for primarily documents. It allows for much better document management than a file share. However, it has a relatively high cost, and is probably not needed in smaller environments.

MS SharePoint / SQL Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
9
Report Formatting Templates
Not Rated
Drill-down analysis
Not Rated
Formatting capabilities
Not Rated
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
Not Rated
Publish to Web
Not Rated
Publish to PDF
Not Rated
Report Versioning
Not Rated
Report Delivery Scheduling
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
Not Rated
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Responsive Design for Web Access
1
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
1