SharePoint at a Glance.
In our organization, MS SharePoint is used for online data storage and retrieval. SharePoint provides a very simple online platform for …
Overview
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…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Multi-User Support (named login) (59)10.0100%
- Responsive Design for Web Access (54)9.797%
- Multiple Access Permission Levels (Create, Read, Delete) (66)9.595%
- Role-Based Security Model (62)9.090%
Reviewer Pros & Cons
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 also want pricing
Alternatives Pricing
What is Spotfire?
Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…
What is SAP Analytics Cloud?
The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is MS SharePoint / SQL?
MS SharePoint / SQL Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
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.
Reviewers rate Location Analytics / Geographic Visualization and Predictive Analytics and Multi-User Support (named login) highest, with a score of 10.
The most common users of MS SharePoint / SQL are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(1146)Attribute Ratings
Reviews
(1-25 of 31)Companies can't remove reviews or game the system. Here's why
DBS that supports the SharePoint server in my case 2016 is either created automatically, which is good for DB admins, with the SharePoint wizard configs, or manually by DBS admin when they configure the SharePoint server a problem could be that Microsoft does not support directly querying or modifying the databases.
- 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.
May 19, 2021
SharePoint for your organization
Score 10 out of 10
Vetted Review
Verified User
SharePoint is basically a collaboration platform for teams to connect, collaborate and work by sharing data pertaining to their work/project. In my case, it is being used across the organization. In most cases, it is used by a group of people for team collaboration. Some of them are using it for storing data, some are using this platform to create applications for business applications. Like, for example, the HR team can use a SharePoint site to store details about the upcoming programs, recruitment, etc; a business team can use it for storing business proposals, meeting contents, souvenirs, etc. So it has multiple uses for hosting content and the supporting tools to make it a solution.
- Collaboration
- Security
- Automation
- User-friendly
- Quick enablement platfrom
- Search
- Customization
- Number of items limit
- No direct integration to other systems
May 14, 2021
Power MS SQL user for the past 12 years
MS SQL is being used as our primary database throughout our entire IT department. We have almost completely moved off Oracle into MS SQL. It is the backend storage for all our applications which supports all app development.
- 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
SharePoint was used for internal knowledge sharing for employees, education and storing employees data and mainly for keeping agents up to date with internal company news. SharePoint is easy to manage and maintain, accessible like any internal portal and secured. Having a SQL data base comes in very handy when storing data internally.
- 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.
September 15, 2019
Organize your documents
SharePoint is a service that provides storing files within the company for us. Another advantage is being easy to use for users. They can easily access the images we deploy for our company website from SharePoint and also they can download those pictures to their computers as well.
- 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.
April 26, 2019
Developer Tenancy is free for one year!
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.
- 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.
March 29, 2019
I'm not sure how we lived without it!
We use SharePoint to share install walkthroughs, configuration files, PMR's, PDR'S, and lots of other department specific files. We use SharePoint to ensure that our team always has the relevant information that they need to do their job, no matter where they are. We use SQL specifically as a reporting tool on the back of our Datacap tool. The error handling, monitoring, and data extracted all gets output to the data tables.
- 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.
March 04, 2019
SharePoint Service Desk solution
We are using SharePoint as a service desk solution, including ticketing, asset inventory, purchase requisition, and project tracking. We also support several departments using SharePoint as a intranet solution. We went with SharePoint as a solution for the flexibility it provided us, while there are some drawbacks for the most part we can mold it into whatever we would like. This does require staff able to spend the time to configure and manage SharePoint though.
- 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.
February 21, 2019
MS SharePoint - CMS done right
At our marketing firm, we have been heavy consumers of Microsoft products. As our company started to expand globally and due to the presence of many remote employees, we felt the need of using a proper content management system to improve interdepartmental collaboration. MS SharePoint was the natural choice for us mainly due to our existing alliance with Microsoft.
- 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.
February 15, 2019
Ms SharePoint: tried it and I'm satisfied
It is used within our bank to store all the documents for all the departments (HR, IT, the Cards Team, etc.) It is used to share any new documents or updated when a document is modified.
- Easy to configure
- Easy way to share your documents
- Makes transparency easy
- None, as I didn't work with any thing other than MS SharePoint
December 28, 2018
Great Collaboration Tool
SharePoint is used in our organization to facilitate collaboration on the production of technical reports that will be made available to the public. It is a very effective tool for our technical report preparation and allows various teams to seamlessly contribute by marking up the documents from any platform. Office Online Server is used in conjunction with SharePoint naming the overall package a winner.
- The collaboration of Technical Reports.
- Has a good search feature.
- Ease of posting content.
- Updates can be tricky to apply.
- Implementation is difficult.
- It is hard to find good SharePoint consultants at reasonable rates.
December 17, 2018
Hard to setup, but if done right you are golden.
SharePoint is used for our intranet; it contains two different "areas", public and private intranet. It is a place for everyone to have a central location to get information or content they are looking for, forms, documents, etc. On the other hand we have a "private" intranet where each department has its own area for department use only. This is done so when there is a new hire or department change, you don't have to provide individual access to separate services and areas. Everything is centrally located and the biggest plus is when it comes to document library versioning.
- Perfect for intranet to inform everyone in the company what is happening
- Easy for storing documents, procedures, documentation, etc.
- Most of the time for end users it is "Self-Service" which means very minimal IT involvement.
- It is hard to setup and nightmare
- It requires a of infrastructure, thus it could be costly because of requirement and licensing required for everything to run smoothly
- If it is not setup and organized properly from the beginning it could be maintenance nightmare
- It is hard to have "test" environment to do patches or similar
November 29, 2018
MS Sharepoint/SQL review
Microsoft SharePoint/SQL is currently being used by our organization by almost all the departments as it proves to be a very standard platform. It helps in maintaining data on the portal with security and ease of use.It is a very handy and a powerful tool that can be used by almost anyone in the organization even though they dont know how to operate it. It helps maintain data and documents easily without us hiring someone to create portals and use advanced programming to achieve the same.
- Ease of use - It is very easy to use and can be used by almost anyone with any hierarchy. This helps us save money and not hire programmers.
- It can be integrated with other applications to create more robust and difficult reports.
- It can be role based and secure. This helps restrict all users from making changes.
- It has mobile support. It has a responsive design that can be automatically incorporated with mobile devices.
- Integration with other tools is not very easy. We were trying to extract reports from QC and post them on SP and found it difficult to accomplish.
- The design is not very sleek - the design can be potentially improved so that it is intuitive.
- Sometimes sharing and editing files by multiple users can create issues and not save all changes.
November 20, 2018
MS SharePoint / SQL ... Too much of a good thing?
MS SharePoint was the cornerstone of the business' collaboration. It was used and browsed daily by hundreds of employees, searching anything from new employees, to employee of the month, from days-off calendar to weekly-meetings. This thing was used and used well. Our business had such a demand that we had a dedicated SharePoint Engineer to develop workflows for processing documents and spreadsheets, etc...
- Workflows
- As a team collaboration tool
- As a documentation datastore
- A repository of knowledge, like a wiki page
- It can get extremely complex, outside the knowledge of a system admin
- Will eventually take a dedicated backend engineer
- Can sometimes need too much work
November 12, 2018
MS SharePoint / SQL product review
We use MS SharePoint / SQL in our IT department. It’s a good collaborative and project management tool. It also allows us collect, share and generate meaningful reports in our company. MS SharePoint / SQL being cloud hosted it allows access from anywhere, internally and externally. It's also easily customizable and easy to use. If you are talking about third-party integration it still scores some good points.
- File version. This helps users stay informed of file version they are using and what changes have been done.
- SharePoint is a great document management solution. Allows you publish and share information within an organization.
- Collaborative capabilities. This maximizes the organization’s productivity.
- The price is high. It could be a good thing if they ever consider bringing its cost slightly down.
- Integration. Sometime integrating other applications and customization can be difficult especially after every update
November 01, 2018
MS SharePoint is the way to go for Documentation Management!
Within our organization, we initially started using Microsoft SharePoint to store our documentation but quite quickly, you will discover that it’s a very powerful collaboration tool that makes sharing (and tracking) documents a breeze, and it's also a very useful tool to manage projects. This product also easily integrates with third-party applications. Very simple user interface with lots of other capabilities.
- Documentation Storage
- Collaboration tool
- Simple user interface
- Simple tool to allow end users the ability to create dashboards for reporting purposes
We use SharePoint mainly for company announcement and file storage. Every department uses it. Files are easy to access and each department is clearly laid out.
- File sharing, clear and easy to manage.
- Easy to set up each department site
- Collaboration of work, people can access and work simultaneously
- Not very agile comparing to dedicated agile space like Trello
- Difficult to customize every aspect. High cost of development.
April 27, 2018
Straightforward Microsoft
It is being used by multiple application groups and on infrastructure level. We use SQL as our main windows database engine, and Share Point for collaboration moving to o365 and Sharepoint cloud.
- SharePoint collaboration and dashboards, visual reporting and easy repository
- SQL database and maintenance and easy Reporting services.
- SQL backup wizard for backup and restore could be improved to be more like more modern backup tools, better file management.
- Easier maintenance planning and job management.
- Easier UI for being able to create new Sharepoint sites for sharing.
I have used SharePoint/SQL for years. In my previous role I was a consultant and implemented this for customers. Currently, our company uses SharePoint/SQL across the enterprise to help simplify and automate multiple business problems. We use it to provide HR resources to employees, as a full blown PMO solution for our PM group, and for enterprise wide collaboration and reporting.
- Great platform for document management, versioning and sharing data/reports. The ability to keep history of edits and all previous versions of the file is very valuable.
- The solution easily allows you to solve unique business problems. The ability to create custom reports, dashboards, lists or workflows without writing code (most of the time) adds a lot of value.
- Provisioning and permissions are simple and flexible. They can be as global or as granular as you needed. It is very easy to give and remove permissions and there are lots of solutions for automating them.
- This is a great product but sometimes I find that there are 10 ways to do the same exact function or action. SharePoint has lots of ways to do the same ting, from a different screen or menu. This can be challenging when it comes to end user training.
- Staying on track with the current version can be a challenge. Microsoft is also notorious for constant patches, updates and hotfixes. A new major version is released every few years and it can be a pain to migrate to the new version if you have customized heavily.
- Creating intuitive global navigation and menus can sometimes be difficult and require a specific skillset of web designer or similar. SharePoint does great for individual sites/solutions, but it can be confusing sometimes to provide global navigation that makes sense for an end user.
March 01, 2018
Maturing solutions for team work
We use MS Sharepoint as a a team collaboration tool, one of the main tools for document sharing within the teams by proposal preparation in international teams, by sharing information and project deliverables with the customers. Also the scheduling and planning functions are very helpful. MS Sharepoint is not the only collaboration and not the best, nevertheless we use it quite frequently, and it is geeting better over time.
- Very good content management tool
- Support for team collaboration
- It is easy to search for information on the whole sharepoint space
- Good responsiveness
- Workflow support seems complicated to configure
- Sometimes the system does not allow to edit files in the local MS Office application for no obvious reason
- Minor issues: Calender displays limited information, by longer entries, it is necessary to click event by event to find the details. A switch for short / full view would be helpful.
- Handling the files requires sometimes to go one by one, group functions are not available (moving, deleting, compressing and downloading the whole directory or selected files)
February 15, 2018
MS SharePoint great for Medium to Large Businesses
MS SharePoint/SQL is being used as the back end for our MS Dynamics CRM solution, Great Plains, and document repository. We use it across our entire organization. It solved the problems of having the ability to log into these services with a single logon. It also solves the problem of not having a central repository for our organization's documents. Its integration with Great Plains allows our entire organization to submit expense reports. It manages the workflow of each expense report. MS SQL is the backend for our CRM solution. Support and community forms helped us the most for making this decision.
- 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.
- 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.
February 09, 2018
MS SharePoint / SQL Showplace!
MS SharePoint / SQL at this time is being used in various departments across the company. Its most useful role is occurring in shipping and receiving. It has also helped in normalizing data across various databases in a rational manner. It has proven to be more stable and flexible than tools used in the past. The reporting services really stand out for the work being done.
- Content storage is excellent with a full range of data types being supported and able to organize such as individual documents like files in document libraries as well as lists and web parts
- I believe these are strengths because the functionality is already built in and we can concentrate on the more complex needs we have rather than building from the ground up
- I am happy that we can deploy PowerPivot for SharePoint and Reporting Services in the same SharePoint farm
- Until I have my total automation packages in place it is difficult to handle things when a service or services stops.
- Intermittent connectivity has occurred but that has been mainly due to differing versions of software but it still seems more difficult than it should to identify the source than it should be with our automated tools
- Retrieving documents reliably was a difficulty for a while until it was determined, again, that differing versions contributed to the problem
February 01, 2018
SharePoint through an end-user's perspective - easy as 1-2-3!
We use SharePoint as an information store in the IT Service Desk. It allows us to manage various documents into sections and categories and manage our day to day work with various information that we need to be aware of on a daily basis along with any upcoming work. It also allows us to make the documents searchable and be able to update the documents with versioning. Checking items in and out when required.
- Provides a good platform for document versioning. The check-in and check-out functions work particularly well.
- Allows a clear view of documents uploaded on the system. Good clear layout achievable with little effort.
- Allows you to manage people in groups. Easy to manage permissions especially in large organizations.
- The search functionality can be better.
- Limited themes available.
- The back end can be quite complicated to manage.
SharePoint is used across the organization as well as with external entities. SharePoint specifically addresses core business needs/problems such as: collaboration, rich search features, online display and edit of office documents, analysis, project tracking, external sharing of data, permission-based access of data/content, shared department/sub-department calendars, reporting, workflow orchestration, organization communication, video/rich media content distribution, version tracking on documents, two-stage recycling bin vs accidental delete within a file share, simultaneous file/ content editing and online presence display within team sites.
- Continuing along the lines of answer 1: collaboration, rich search features, online display and edit of office documents, analysis, project tracking, external sharing of data, permission-based access of data/content, shared department/sub-department calendars, reporting, workflow orchestration, organization communication, video/rich media content distribution, version tracking on documents, two-stage recycling bin vs accidental delete within a file share, simultaneous file/ content editing and online presence display within team sites.
- Specifically, SharePoint’s core advantage to an organization is the immediate speed a user can start using without training and structured process. This intuitive ease of use makes the adoption of the platform much more effective at the basic use level of SharePoint. SharePoint obviously integrates extremely well with Office products which are pervasive within any size of company.
- Webparts from solutions, sandbox solutions and/or apps definitely add to the ability of the platform to extend out core list/library elements to custom code development.
- One key area which SharePoint lacks would be within the areas of: ease of modification for interface / UI modifications for branding, site specific /library specific usage data reporting and inline content commenting and real-time collaboration (the Yammer promise).
September 27, 2017
SharePoint Review
SharePoint has helped consolidate and organize data across the company. By bringing data to a management system it made searching for critical data more efficient and freed up hardware hosting multiple file shares. Also, using it as a single point of coordinating meetings, events, and booking rooms has been extremely useful and reduced frustration among staff.
- Data Organizing
- Searchable Features
- Scheduling Appts / Rooms / Events
- Work flow processes for reporting
- Easier use of page building
- Better interface to development work flows
- Able to allow anonymous access to outside forms for data collecting (surveys)