MS SharePoint / SQL Showplace!
February 09, 2018

MS SharePoint / SQL Showplace!

Alfred Brock | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with MS SharePoint / SQL

MS SharePoint / SQL at this time is being used in various departments across the company. Its most useful role is occurring in shipping and receiving. It has also helped in normalizing data across various databases in a rational manner. It has proven to be more stable and flexible than tools used in the past. The reporting services really stand out for the work being done.

Pros

  • Content storage is excellent with a full range of data types being supported and able to organize such as individual documents like files in document libraries as well as lists and web parts
  • I believe these are strengths because the functionality is already built in and we can concentrate on the more complex needs we have rather than building from the ground up
  • I am happy that we can deploy PowerPivot for SharePoint and Reporting Services in the same SharePoint farm

Cons

  • Until I have my total automation packages in place it is difficult to handle things when a service or services stops.
  • Intermittent connectivity has occurred but that has been mainly due to differing versions of software but it still seems more difficult than it should to identify the source than it should be with our automated tools
  • Retrieving documents reliably was a difficulty for a while until it was determined, again, that differing versions contributed to the problem
MS SharePoint / SQL was selected because of a long, trusted relationship with the vendor. Compatibility is also an issue. With a large installation already in place it made more sense to upgrade the system rather than start working in products in a patchwork. There is no way that a impact to business can be tolerated.
It is well suited for large amounts of data in a single format. Accuracy and execution speed are unparalleled. The querying tools are robust and trustworthy for a wide variety of operations. Difficulty was experienced when offices that had not been upgraded to the correct version were encountered. It was not suitable in an environment where installations had not been properly updated and maintained.

MS SharePoint / SQL Feature Ratings

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

Comments

More Reviews of MS SharePoint / SQL