What users are saying about

MS SharePoint / SQL

540 Ratings
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

MS SharePoint / SQL

Well suited scenarios:- use anywhere where there are users with limited IT knowledge, the way for sharing and editing documents is easy to explain- use anywhere when a realitme access required and the users use heterogeneous devices / formats (PC, MAC, iOS and Android connected via Sharepoint server)Less appropriate use cases:- MS SHP / SQL is tricky to configure access rights in a complex organizational environment- not good for time critical tasks, as an internet based tool its usability depends on connection quality

Feature Rating Comparison

BI Standard Reporting

MS SharePoint / SQL
7.5
Pixel Perfect reports
MS SharePoint / SQL
7.0
Customizable dashboards
MS SharePoint / SQL
7.9
Report Formatting Templates
MS SharePoint / SQL
7.7

Ad-hoc Reporting

MS SharePoint / SQL
7.4
Drill-down analysis
MS SharePoint / SQL
7.7
Formatting capabilities
MS SharePoint / SQL
7.5
Integration with R or other statistical packages
MS SharePoint / SQL
6.9
Report sharing and collaboration
MS SharePoint / SQL
7.7

Report Output and Scheduling

MS SharePoint / SQL
8.1
Publish to Web
MS SharePoint / SQL
8.2
Publish to PDF
MS SharePoint / SQL
7.8
Report Versioning
MS SharePoint / SQL
8.7
Report Delivery Scheduling
MS SharePoint / SQL
8.3
Delivery to Remote Servers
MS SharePoint / SQL
7.4

Data Discovery and Visualization

MS SharePoint / SQL
7.7
Pre-built visualization formats (heatmaps, scatter plots etc.)
MS SharePoint / SQL
7.6
Location Analytics / Geographic Visualization
MS SharePoint / SQL
8.0
Predictive Analytics
MS SharePoint / SQL
7.6

Access Control and Security

MS SharePoint / SQL
8.7
Multi-User Support (named login)
MS SharePoint / SQL
8.7
Role-Based Security Model
MS SharePoint / SQL
8.6
Multiple Access Permission Levels (Create, Read, Delete)
MS SharePoint / SQL
8.6
Single Sign-On (SSO)
MS SharePoint / SQL
8.7

Mobile Capabilities

MS SharePoint / SQL
7.9
Responsive Design for Web Access
MS SharePoint / SQL
7.9
Dedicated iOS Application
MS SharePoint / SQL
7.9
Dedicated Android Application
MS SharePoint / SQL
8.3
Dashboard / Report / Visualization Interactivity on Mobile
MS SharePoint / SQL
7.5

Application Program Interfaces (APIs) / Embedding

MS SharePoint / SQL
6.7
REST API
MS SharePoint / SQL
6.9
Javascript API
MS SharePoint / SQL
7.2
iFrames
MS SharePoint / SQL
6.4
Java API
MS SharePoint / SQL
7.0
Themeable User Interface (UI)
MS SharePoint / SQL
5.8
Customizable Platform (Open Source)
MS SharePoint / SQL
7.0

Pros

  • Allowing each department to create their own areas to manage.
  • Allowing us to tag documents and organize them much better than folders on a NAS.
  • MS SQL allows the seamless access to data by multiple different front ends.

Cons

  • MS Sharepoint/SQL could improve on not requiring so many hardware resources.
  • MS Sharepoint/SQL could improve on the ease of setup.
  • MS Sharepoint/SQL could improve on the number of servers that are required for their document repository solutions.

Likelihood to Renew

MS SharePoint / SQL8.8
Based on 7 answers
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.

Usability

MS SharePoint / SQL7.0
Based on 2 answers
Over all very similar to other microsoft products

Support

MS SharePoint / SQL7.0
Based on 2 answers
Microsoft have good local teams

Implementation

MS SharePoint / SQL7.0
Based on 2 answers
Not implemented in best practice way, there are many customizations

Breadth of Deployment

It is used across the organization

Alternatives Considered

The internal document repository features are very robust and strong, so there are few solid competitors without going into far more complex territory for specialized solutions using Documentum or other packages. Being a strong generalist is really the greatest strength here for SharePoint/SQL, along with having a common MS architecture which makes finding developers who can code custom solutions an easier proposition than with many other enterprise architectures. For the intranet development, we moved away from original plans to use a Websphere platform that is used for our external site content management, due to the complexity and cost of development not being needed for internal communications. We also considered some other strong content platforms, like WordPress. While these are great on the ease of building a custom UX and for users to easily do content self-service, and they did have some levels of publishing and permissions based access, they lacked the more robust enterprise features for document sharing and management, list and data services, and other features that we already had implemented across the enterprise in our regular SharePoint space. Keeping both of these internal spaces on the same platform allows us to plan for further and deeper integration in the long view, and allows for more consistent governance of content to be developed and grow over time.

Collaboration and Sharing

MS SharePoint / SQL8.5
Based on 37 answers
Even with some extremely tight access-control policies demanded by being in a financial services leading institution, and general policies for larger corporate enterprise architecture, the use of data and document sharing is fairly direct and simple to implement in SharePoint. Limiting access could be much more complex, with heavily customized and intricate workflows. For achieving closer to real-time publishing models with user self-service on content on the intranet side of our house, we were able to find a balance that was simple to use and understand for our larger base, while still providing a strong sense of governance over the content and structure of the whole site. Report sharing is easy, although generating information on some of the internal data structure questions can be a bit complex with the larger SQL structure that SharePoint uses, especially as we have several distinct environments created for the intranet which have a need to stay in sync with one another. Security has not been difficult thus far, however to extend some of the access outside of our enterprise firewalls to additional users in the company, or for easy home-access of info (e.g. sharing HR info with a spouse at home without having a VPN setup), will require some additional infrastructure complexity for it to remain as tightly secured as we need it to be.

Data Integration

MS SharePoint / SQL7.8
Based on 36 answers
We have worked with a wide range of data sources, and integration has usually been fairly easy. In most cases where it became complicated, it was due to limiting factors or poor data control of the source. Some third-party vendors offered feeds or API access, but had poorly developed these features (which seemed to be great marketing tools with little actual implementation to back up their claims) or had severely restricted access to their data model. Even in these cases, our developers were usually able to glean what was needed and build a solution within SharePoint that satisfied our customer's needs.

Return on Investment

  • I've installed SharePoint in many different industries and each industry has seen greater collaboration among their teams both locally and nationally. The ability to collaborate more efficiently has reduced the need to have employees centrally located.
  • Companies which have used SharePoint in a end user training portal have had great ROI, since they can create the content once and share with all their users who subscribe to their training service. The web content management aspect of SharePoint is a very helpful feature.

Pricing Details

MS SharePoint / SQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details