Developer Tenancy is free for one year!
April 26, 2019

Developer Tenancy is free for one year!

Laura Stein | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MS SharePoint / SQL

We are using SharePoint Online and SQL in Azure. It keeps our data safe and available, and eliminates the need for backups and costly infrastructure. We are building apps with forms and workflows to replace the apps in Lotus Notes. It also provides threat management and data loss prevention. Collaboration between departments is also very easy with SharePoint Teams.

Pros

  • SharePoint: Data Management of documents, and turning spreadsheets into lists.
  • SharePoint Online: Continuous improvements, and the ability to preview the improvements before general release.
  • SQL: Excellent Database platform. Easy to connect to, and less expensive than Oracle for both implementation and management. I don't believe in using open source (i.e. MySQL) in a corporate environment.

Cons

  • SharePoint: 5,000 item view limit.
  • SharePoint: User groups should default to Contribute, not Edit. Edit is too much permission for end-users; it allows the users to change the table structure or even delete the whole list or library.
  • If using either SharePoint or SQL on-premise, backups and patches approach nightmare level.
Mostly, we are a Microsoft shop, and SharePoint and SQL integrate with our other applications. They're easy to use, and not too hard to manage.
Well-suited for most businesses. Any limitations can be overcome with proper configuration and/or add-ons. Particularly well-suited for the two opposite ends of Power Users and Newbies. Power Users can be given permission to design pages, etc. while less technical users can be limited to Contribute or Read access to whatever. Excellent permission management in both products.

MS SharePoint / SQL Feature Ratings

Pixel Perfect reports
Not Rated
Customizable dashboards
Not Rated
Report Formatting Templates
Not Rated
Drill-down analysis
Not Rated
Formatting capabilities
Not Rated
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
Not Rated
Publish to Web
Not Rated
Publish to PDF
10
Report Versioning
Not Rated
Report Delivery Scheduling
Not Rated
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
Not Rated
Location Analytics / Geographic Visualization
Not Rated
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
6
Mobile Application
7
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated
REST API
7
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
10
Customizable Platform (Open Source)
Not Rated

Comments

More Reviews of MS SharePoint / SQL