MS SharePoint / SQL

MS SharePoint / SQL

About TrustRadius Scoring
Score 8.4 out of 100
MS SharePoint / SQL

Overview

Recent Reviews

SharePoint just works

8 out of 10
September 18, 2019
It was being used at Starbucks and is being used at LendingTree to share information between individuals, teams, and organizations. We use …
Continue reading

Organize your documents

8 out of 10
September 15, 2019
SharePoint is a service that provides storing files within the company for us. Another advantage is being easy to use for users. They can …
Continue reading

Popular Features

View all 28 features

Multi-User Support (named login) (58)

9.5
95%

Role-Based Security Model (61)

9.1
91%

Multiple Access Permission Levels (Create, Read, Delete) (65)

8.5
85%

Customizable dashboards (53)

7.3
73%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of MS SharePoint / SQL, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

What is MS SharePoint / SQL?

MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

1 person want pricing too

Alternatives Pricing

What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

Sorry, this product's description is unavailable

Features Scorecard

BI Standard Reporting

7.8
78%

Ad-hoc Reporting

8.5
85%

Report Output and Scheduling

8.8
88%

Data Discovery and Visualization

8.9
89%

Access Control and Security

9.0
90%

Mobile Capabilities

9.2
92%

Application Program Interfaces (APIs) / Embedding

9.4
94%

Product Details

What is MS SharePoint / SQL?

MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.

MS SharePoint / SQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is MS SharePoint / SQL?

MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.

What is MS SharePoint / SQL's best feature?

Reviewers rate Mobile Application highest, with a score of 10.

Who uses MS SharePoint / SQL?

The most common users of MS SharePoint / SQL are from Enterprises (1,001+ employees) and the Information Technology & Services industry.

Reviews

(1-25 of 74)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • You can use some BI solutions with SharePoint Server 2016.
  • A great feature is AlwaysOn Availability Groups and Failover Cluster Instances solutions.
  • Setup reporting services with SharePoint Server 2016 you create a report server. that's cool.
  • You can't install office online server to use excel online.
  • Service applications DBS in partitioned mode cannot be created from central administration.
  • Something good is that You can configure alerts to notify you when the production server fails.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Very fast data storage and retrieval
  • Great support for ORMs which provide a layer of abstraction over MS SQL
  • Great community of support and users
  • SSMS is a nice GUI for interfacing with MS SQL
  • Licensing costs over free to use DB systems
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Integrates so well with all of Microsoft's other products like Skype and Outlook.
  • Easy to learn and manage by admins.
  • Less coding required.
  • Better access to the date base, more direct access would be nice as using API requires more technical skills.
  • The search functionality.
  • You still need a separate data base for example for data warehouse. SharePoint sits on top of SQL Server, which is a relational database management system.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Organise large repositories of files in an easy to use and navigate structure.
  • User-friendly presentation of content.
  • Ability to handle large amount of data.
  • SharePoint's back-end can be a bit better (more admin-friendly).
  • SQL has its number of bugs and issues and you have to keep on top of it all the time.
  • Mapping a SharePoint site to a user's computer can be a chore.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Easy to install
  • Great front end to look at and manipulate data
  • More widely used than other databases so more support available when needed
  • Licensing can be confusing
  • Like Windows, you have to upgrade/migrate to newer versions over time as older ones become unsupported
Gene Baker | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Collaboration and sharing of information.
  • Security, allowing access to only those individuals with a need to know.
  • It can be a little hard to master so you need to take time to read the various primers available to know how to configure and deploy SharePoint. Do you use Foundation, 365 or Server?
Matt Varney | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • If you are an existing and extensive Microsoft customer, the platform will fit in your application ecosystem nicely.
  • For SMBs or departments within larger organizations, the solution can be created with "foundation" versions of the products, which can provide plenty of power at a reasonable (often already included) price.
  • If you are a LAMP stack developer or shop, there is a learning curve.
  • From a general usability standpoint, it can be a less than pleasant experience. The interface is blocky and the concepts are not straightforward. It feels dated.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Internal intranet for our company to enable users a central location for file storage, company wide notification and collaboration tools
  • Enables a central file depository for teams and departments
  • Great search functions
  • Customizable user permissions
  • Integration with 3rd party providers since Sharepoint has been around for years
  • On-boarding can take some time with new hires on how to use SharePoint
  • One issue we noticed is SharePoint One Drive sync issues creep occasionally
  • Cache issues with certain browsers that cause issues and required the browser Cache to be cleared out
  • It can become complex quickly with customization and difficult to fix when problems do arise.
Dinesh Selvachandra | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Good integration with the Microsoft ecosystem. Active directory security is an advantage.
  • Remotely accessible and the files are up to date. We can link to local storage.
  • Version control.
  • The search function is confusing.
  • Navigation can be annoying.
September 18, 2019

SharePoint just works

Score 8 out of 10
Vetted Review
Verified User
Review Source
  • We're using it here at LendingTree as a centralized document storage location broken up by teams and content so it's easy to find what you're looking for in a centralized location.
  • At Starbucks, we used it to pass along information to the tens of thousands of baristas located all over the world.
  • Some of the SQL it generates is, or at least was, pretty horrible. It could do a better job of taking advantage of the performance possibilities within SQL Server.
  • It is pretty easy for one user to change settings for an entire team, in an unintended manner. But perhaps that's just because we aren't provisioning users as well as we could be.
September 15, 2019

Organize your documents

Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Solid service for company intranet.
  • It organizes the company documents in one place.
  • Easy to access documents.
  • The user interface could be more simplified.
  • Accessing outside of the company network should be easier.
  • The implementation can be more smooth as it is a little challenging process.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • 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.
  • 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.
Ben Williams | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Allow users to access documents no matter where they are.
  • It's secure.
  • It is end-user friendly. Our team members can use it quickly and efficiently.
  • It is efficient in managing large amounts of data.
  • Allows us to monitor and track data from our OCR tool.
  • It can be a little difficult to get it set up. There are very few walkthroughs in it on how to set up.
  • The search functionality needs improvement. It's currently nonexistent.
  • It's difficult to lock down files to ensure that users who can access them don't delete them.
Score 6 out of 10
Vetted Review
Verified User
Review Source
  • Microsoft SharePoint provides controlled access to information.
  • Microsoft SharePoint allows users to access information remotely.
  • Microsoft SharePoint allows collaborative work.
  • The user interface for SharePoint is not exactly intuitive.
  • To get the software set up correctly and to your liking, you have to have a lot of knowledge and time to customize the software.
  • Basic functions and navigation seem difficult.
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Flexible - able to make any changes we would like vs traditional service desk system.
  • ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
  • Easy to use for end users.
  • Staff time - flexibility is great but in order to benefit you do need to have staff able to configure and manage SharePoint.
  • Reporting - reporting leaves something to be desired both directly within sharepoint and with SQL reporting services.
Jeet Sohpal | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • OneDrive is the front end for our users. The back end of OneDrive is SharePoint which allows storing of files and folders and it also allows our users to share those files and folders with other users globally, internally and externally.
  • As SharePoint is also the back of end of MS Teams it allows for much better many to many collaboration. It also allows for conversations in teams to be had globally between different teams within the same organization.
  • Yammer is also another app which has a SharePoint backend that is now being utilized more within our company. You can join and create groups within Yammer where you can discuss work-related projects or non-work related subjects such as sharing photos and information about your pet(s).
  • Within SharePoint itself, you can create document Libraries which can double up as repositories which can be used in applications such as Repstor which is a 3rd party tool that plugs into Outlook and in doing so brings SharePoint into Outlook. By doing this, you can create folders within Repstor which then sync back to the SharePoint document library. You can then file emails into these folders and make this information shareable with other users by allowing them access to the repository.
  • SharePoint also allows you to set up email content types which extract the metadata from emails filed into SharePoint so that they are filed with the correct field names and those fields are populated. Doing this allows for much more efficient storage and searching.
  • The technical/configuration side of it is not as intuitive as I would like it to be.
  • Can be clunky and temperamental at times in that you could be working on setting up a SharePoint site and it could all just seize up. This could, however, be down to the infrastructure in our company.
  • Easier and better differentiation for users so that they can easily understand the differences between SharePoint and OneDrive (my.sharepoint).
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Easy to share information with colleagues or partners within or outside of the organization.
  • Easy to learn quickly, people are used to the interface.
  • Everyone likes talking about themselves, SharePoint gives users a place to do that if they so wish.
  • Setting up an external facing SharePoint site securely can be a challenge.
  • Permissions can be difficult for users to set up and maintain.
  • Setup can be intimidating as it can require many servers if you split all the roles out.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Access and sharing through users is role-based and very familiar to the regular Microsoft Office suite.
  • Document versioning and backups is a breeze.
  • Microsoft SharePoint is one of the best tools for sharing and collaborating on internal documentation.
  • Exposing websites outside the intranet can be really challenging.
  • Customizations to provide the same look and feel to make it compliant with other company resources can be daunting as well.
Sirish Vadala | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Extremely convenient to collaborate effectively by setting up websites for sharing information related to projects.
  • Enables users to manage documents with interactive dashboards and graphs to analyze organizational needs.
  • Easy to customize, providing options to edit components and create your own custom applications to suit your organization.
  • Excessive features can sometimes be overwhelming and difficult to locate. Also, configuring security is slightly complicated unless you are a SharePoint developer.
  • Sometimes the application freezes and locks up. However, this could be due to the network configuration from my organization's end.
  • Loading the calendars is sometimes slow and freezes.