Solution for Data That Does Not Fit
September 17, 2018

Solution for Data That Does Not Fit

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

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.
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
Mobile 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