MS SharePoint great for Medium to Large Businesses
February 15, 2018

MS SharePoint great for Medium to Large Businesses

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

Overall Satisfaction with MS SharePoint / SQL

MS SharePoint/SQL is being used as the back end for our MS Dynamics CRM solution, Great Plains, and document repository. We use it across our entire organization. It solved the problems of having the ability to log into these services with a single logon. It also solves the problem of not having a central repository for our organization's documents. Its integration with Great Plains allows our entire organization to submit expense reports. It manages the workflow of each expense report. MS SQL is the backend for our CRM solution. Support and community forms helped us the most for making this decision.
  • Allowing each department to create their own areas to manage.
  • Allowing us to tag documents and organize them much better than folders on a NAS.
  • MS SQL allows the seamless access to data by multiple different front ends.
  • MS Sharepoint/SQL could improve on not requiring so many hardware resources.
  • MS Sharepoint/SQL could improve on the ease of setup.
  • MS Sharepoint/SQL could improve on the number of servers that are required for their document repository solutions.
We mainly chose MS SharePoint/SQL because we are Microsoft partners. Microsoft gave us licenses for it and we were already familiar with the SQL product so a move to SharePoint was natural for us. MySQL and other Database engines would have not given us the flexibility that we needed with our Windows domain and largely Windows environment.
MS Sharepoint/SQL is less appropriate for a small business with no full-time SQL staff or IT administrators. The setup may require outside help so those without technical knowledge may need help getting it up and running and to provide monthly/weekly/daily maintenance. MS Sharepoint/SQL is well suited for large businesses with full time IT staff.

MS SharePoint / SQL Feature Ratings

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