Solution for Data That Does Not Fit
Anonymous | TrustRadius Reviewer
September 17, 2018

Solution for Data That Does Not Fit

Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with MS SharePoint / SQL

It is being used right now to store data that does not fit in our ERP. In doing so we are using SQL to mine this data and create useful reports. We also use a battery of other Microsoft software to help leverage the gathering and use of this data. The ability to create custom lists and store information that otherwise does not fit in our ERP is very useful.
  • Versioning, the way it tracks changes and when they were made and what was changed is amazing
  • Customization of data. The easy way it relates to users to help customize the storing of data
  • Integration of user data and meta data
  • It isn't granular enough for IT experts
  • The data often times does "play well" with SQL
  • It seems outside vendors do this better then what Microsoft has in place i.e. Layer2
We picked SharePoint/SQL because of the support and knowledge knowing that Microsoft is going to continue to develop and improve it. Google has a reputation for abandoning projects and other vendors just don't have the support, so it seems, that Microsoft has. Also when your entire infrastructure is built on Microsoft it just seems easier and obvious.
If you are using Azure then it is seamless. Because of this we are slowly moving everything up to the cloud. I am really impressed with how you can integrate other data sources and information when using SQL/SharePoint and its cloud based option. I am not familiar with hosting it, but from my company's point of view it really is great
The access control is a home run in my opinion. They way you can delegate control and how easy they make it is so amazing you can tell they took their time developing it. Also the integration with Active Directory is done very well also. Security is easy to setup because of how well they did their access controls.
Well suited in cases where a company needs to collect data that isn't included in their ERP. (i.e. document control or safety inspections.) Where it doesn't work is if you need very strict data. SharePoint is not the best with validation in my opinion. So if you need very format-specific data, I would steer away from it.

MS SharePoint / SQL Feature Ratings

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