Hard to setup, but if done right you are golden.
Anonymous | TrustRadius Reviewer
December 17, 2018

Hard to setup, but if done right you are golden.

Score 6 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with MS SharePoint / SQL

SharePoint is used for our intranet; it contains two different "areas", public and private intranet. It is a place for everyone to have a central location to get information or content they are looking for, forms, documents, etc. On the other hand we have a "private" intranet where each department has its own area for department use only. This is done so when there is a new hire or department change, you don't have to provide individual access to separate services and areas. Everything is centrally located and the biggest plus is when it comes to document library versioning.
  • Perfect for intranet to inform everyone in the company what is happening
  • Easy for storing documents, procedures, documentation, etc.
  • Most of the time for end users it is "Self-Service" which means very minimal IT involvement.
  • 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
We have evaluated Google for Work, but since we are under contract with Microsoft, SharePoint integrates better with Microsoft services like email (Exchange), storage (OneDrive for business), Microsoft Project... It made more sense to proceed with SharePoint than getting completely separate system and on the other side you have to think about compliance because Microsoft have been in this game for much longer than any other company.
From our experience there is nothing you cannot connect to those systems. From SQL prospective most of languages have ability to connect to SQL, from SharePoint prospective, building webpiarts or using SharePoint APIs, possibilities are limited to your imagination as product can be "extended"
Sharing and collaboration are the biggest plus of those tools. There is very granular control, self-service tool, versioning, it is made for people that might not be in the same room or even location to be able to collaborate on project just like they were sitting next to each other.
It is good for communication within company and being able to reach a lot of users. While it is a very powerful tool it could be misused easily and become just a giant pile of digital junk. Unless you have users that are responsible for their own content it will be IT's nightmare.

MS SharePoint / SQL Feature Ratings

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