TrustRadius: an HG Insights company

MS SharePoint / SQL

Score8.5 out of 10

1,150 Reviews and Ratings

Get a Demo

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.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features MS SharePoint / SQL has to offer, as determined by TrustRadius' reviewers.
Based on 1,150 ratings of MS SharePoint / SQL's features
View all features

Top Performing Features

  • Responsive Design for Web Access

    Web design aimed at producing easy-to-read sites across a range of different devices.

    Category average: 7.9

  • Publish to PDF

    Category average: 8.5

  • Mobile Application

    A dedicated app for iOS and/or Android.

    Category average: 7.4

Areas for Improvement

  • Themeable User Interface (UI)

    A themeable user interface means that a specific visual them can be applied to it

    Category average: 7.8

  • Report Formatting Templates

    Category average: 8.1

  • Customizable dashboards

    Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.

    Category average: 8.5

Reviews

What users are saying about MS SharePoint / SQL.
View all reviews

Better ease of doing business

Incentivized
Verified User
C-Level Executive in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

We use for document management and we had files more than 2 million that needs to be stored and given access to employees. MS SharePoint is best software product that addresses your problem and gives customer delight. We use SQL for effective indexing, archiving and helps addresses the problem. I highly recommend MS SharePoint / SQL.

Pros

  • Documents management
  • File movements
  • Indexing
  • Ease of data access
  • Ease of doing business

Cons

  • Some features like document folders can be given access in main page
  • File movements can be improved from folder to folder
  • Faster page loading

Return on Investment

  • Better ease of business for faster access to file movements
  • It helped saved company times by more than 5 hours and results in better decision points

Usability

Alternatives Considered

Apache Kafka and Canon Business Services Managed IT Services

Other Software Used

Adobe Analytics, Google Analytics, Cargo365cloud

MS SharePoint / SQ

Incentivized
Verified User
Professional in Information Technology (51-200 employees employees)

Use Cases and Deployment Scope

We use MS SharePoint to share documents and handle workflow options. We use SQL in our test and production environments. We use it for Acumatica (our ERP) and our client facing websites/billing.

Pros

  • SQL has come a long way in reliability and dependability. It allows large datasets and does really well with JSON.
  • MS SharePoint works well with sharing files and workflow

Cons

  • I honestly can't think of any. Maybe change control?

Usability

Other Software Used

Microsoft Visual Studio

SharePoint SQL Powerful for Collaboration and Data Management but with a learning curve

Incentivized
Verified User
Professional in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

SharePoint is our central hub for collaboration and document management. It brings a new way of working eliminating the need of sending documents back and forth and easy way to access version history.

Pros

  • Enables secure document sharing with version control, automated approval workflows, and team-specific collaboration sites
  • Handles large-scale data storage and querying, supports real-time reporting through Power BI, and ensures centralized access to business-critical information

Cons

  • Navigation and search in sharepoint can be unintuitive, and customizing sites often requires more technical expertise
  • SQL can be really complex when it comes to performance tuning and advanced configuration

Return on Investment

  • SharePoint has boosted productivity by streamlining collaboration and reducing time spent on document management
  • SQL has improved decision-making with faster, more accurate reporting

Usability

Excellent to implement solutions quickly

Incentivized
Naseem AhmadView profile
Sr Technical Architect in Information Technology at CBRE Inc (10,001+ employees employees)

Use Cases and Deployment Scope

How we use: In different line of businesses with CBRE, we use MS SharePoint / SQL as a central repository to hold datafiles, or structured data in the form of MS SharePoint / SQL Lists. Business problem: Datafiles collaboration among users, Low code No Code Automation usecases developement. Scope of use cases: Most of the time they are financial processes.

Pros

  • Scalable: I like MS SharePoint / SQL as it comes with builtin scalability when concurrent users are reading or writing even a single file
  • Quick app development: Using MS SharePoint / SQL lists we can quickly spin up a web applications for general purpose specifically the ones that require users to collaborate
  • Integration: We have well documented API that provide us a way to quickly integrate them with any applications

Cons

  • Missing functionality: We dont any native options to deal with big data
  • Limited scope for customisation: We have very limited scope to customise the MS SharePoint / SQL as a whole, and that too requires you to be a full fledged developer
  • User exprience: There is a lot of room for ui/ux, such as there is no full list search option

Return on Investment

  • For use cases with limited audience we are able to spin up the solution in MS SharePoint / SQL in 1/8 time if we compare the solution in any other solution such as Power Apps etc
  • We were able to spin up approx 80 use cases mainly in finance that saved us around 45FTE
  • It really shines in the use cases that required collaboration

Usability

Alternatives Considered

Power Apps, Smartsheet and Box

Other Software Used

Google Workspace, Smartsheet, Power Apps

It works and affordable but I would consider other options

Incentivized
Brandon Schmidt
Infrastructure Engineer in Information Technology at Crown College (51-200 employees employees)

Use Cases and Deployment Scope

We use SharePoint Online. We use it primarily as a file storage system. We migrated our network shares located on-prem to SharePoint Online, so therefore, that is why we use SharePoint Online primarily as a file storage system. Also, we use OneDrive, which relies on SharePoint in the backend.

SharePoint Online gave us more storage space and was cheaper than expanding on-prem storage.

Pros

  • Easy to share with people internally
  • Easy to share with people externally
  • Integrates with Microsoft Teams
  • Allows end users to determine permissions to files instead of being centralized in IT

Cons

  • Hard to understand security controls sometimes
  • Hard to onboard and train end users
  • Not as easy to use files with existing applications as compared to having on-prem file shares

Return on Investment

  • Reduced burden on IT by enabling end users to share files across departments
  • Reduced storage requirement for on-prem hardware

Usability

Other Software Used

Microsoft 365, Microsoft Excel, Microsoft Teams