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…
Do you need powerful database Sharepoint/SQL must be your best option.
Makes life easier
Works well for us as a news feed
SharePoint for your organization
Power MS SQL user for the past 12 years
Wanna host your internal website in a couple of hours? Use Sharepoint!
Look no further for document and knowledge sharing portal
MS SharePoint / SQL is easy to set up, with a robust feature set
MS Sharepoint is the one collaboration tool you need.
MS SharePoint / SQL - an on-premise option for SMBs
SharePoint\SQL is a great for any organization to utilize
Very convenient document management system.
SharePoint just works
Organize your documents
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.696%
- Role-Based Security Model (62)9.090%
Reviewer Pros & Cons
Pricing
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 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…
What is Tableau Server?
Tableau Server allows Tableau Desktop users to publish dashboards to a central server to be shared across their organizations. The product is designed to facilitate collaboration across the organization. It can be deployed on a server in the data center, or it can be deployed on a public cloud.
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 8.9Pixel Perfect reports(36) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 8.7Customizable dashboards(53) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 9.1Report Formatting Templates(45) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 8.9Drill-down analysis(42) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 9.6Formatting capabilities(52) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 8Integration with R or other statistical packages(30) Ratings
Integration with the open-source R predictive modeling environment.
- 9.8Report sharing and collaboration(50) Ratings
Report sharing and collaboration is the ability to easily share reports with others.
Report Output and Scheduling
Ability to schedule and manager report output.
- 8.8Publish to Web(52) Ratings
- 8Publish to PDF(48) Ratings
- 8.8Report Versioning(45) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 9.7Report Delivery Scheduling(40) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
- 10Delivery to Remote Servers(32) Ratings
Ability to deliver reports to remote servers
Data Discovery and Visualization
Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.
- 8.9Pre-built visualization formats (heatmaps, scatter plots etc.)(33) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
- 10Location Analytics / Geographic Visualization(32) Ratings
Location analytics is the visualization of geographical or spatial data.
- 10Predictive Analytics(29) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.
- 8Pattern Recognition and Data Mining(1) Ratings
Pattern recognition and data mining mean the ability to recognize hidden patterns in large quantities of data.
Access Control and Security
Access control means being able to determine who has access to which data.
- 10Multi-User Support (named login)(59) Ratings
Named model access means that users have access based on name and password.
- 9Role-Based Security Model(62) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 9.6Multiple Access Permission Levels (Create, Read, Delete)(66) Ratings
Multiple access permission levels means that different levels of users have different rights.
- 9Report-Level Access Control(1) Ratings
Report-level access control means that the type of report determines who has access to it.
- 9Single Sign-On (SSO)(53) Ratings
Allows users to use one set of login credentials to access multiple applications
Mobile Capabilities
Support for mobile devices like smartphones and tablets.
- 9.7Responsive Design for Web Access(54) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 9.1Mobile Application(33) Ratings
A dedicated app for iOS and/or Android.
- 8Dashboard / Report / Visualization Interactivity on Mobile(38) Ratings
In-app dashboard reports and data visualization.
Application Program Interfaces (APIs) / Embedding
APIs are a set of routines, protocols, and tools for used for embedding one application in another
- 9REST API(28) Ratings
REST is an architecture style for designing networked applications
- 9.9Javascript API(26) Ratings
A Javascript API is a type of API
- 9iFrames(27) Ratings
An iFrame is an HTML document embedded inside another HTML document on a website
- 9Java API(25) Ratings
A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)
- 9Themeable User Interface (UI)(32) Ratings
A themeable user interface means that a specific visual them can be applied to it
- 9.9Customizable Platform (Open Source)(23) Ratings
A customizable, open source API Gateway is a fast and scalable type of API
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
Comparisons
Compare with
Reviews and Ratings
(1141)Attribute Ratings
Reviews
(51-73 of 73)Set-up was difficult. Syncing was an issue. It might be better now.
- Cloud access from anywhere.
- Syncs across devices.
- Collaborate on a document.
- Set up was confusing.
- Didn't sync properly.
- Support wasn't easy to find.
SharePoint for Sharing!
- Security - easy to set up based on role and department in the company
- Simple - Easy to pick up and use for most users
- Expansive - While simple to use there are tons of features available to the end user as needed
- Workflow can be hard out of the box but tools are available to make it easier
SharePoint Review
- 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)
SharePoint probably does more than you remember
- Integration with most Office 365 apps.
- Sharing and group collaboration is MUCH improved from prior iterations.
- Good experiments with new apps. I like getting to play with things in beta.
- Better alignment between new apps like Planner and Teams.
- More variation on question and result types in Forms.
- Easier sharing with non-SP users or outside enterprise collaboration. Such as vendor access to a specific folder for deliverables, but not the rest of the project.
Data Centric
- Ease of use
- Ease of Installation
- Scalable
- Compatibility
- Version Changes
MS Sharepoint / SQL is a powerful tool for information sharing and collaboration but needs work to customize.
- Intranet. SharePoint makes a great intranet to share information from a central place.
- It's easy to easily start up new lists or wiki pages. End users can create new lists or wiki pages and add their information on the fly without having to engage the IT department.
- Search indexing. SharePoint makes a great platform for searching all documents or files in either SharePoint or your directory structure.
- Custom development with SharePoint is difficult. Development with visual studio for web parts is time-consuming and a black box to try to build with.
- Error reporting and diagnostics are hard to find and hard to decipher. It is difficult to know what went wrong when an error happens.
- Image handling is poor. The wiki could be an incredible documentation tool but because images are so difficult to upload and use, we only use it for text.
- Access Control. SharePoint allows administrators to provide a great amount of control over who can see information, and what they can do with it.
- SharePoint integrates easily with other Microsoft products, making collaboration very easy. It has out of the box integrations with Skype, and Office, of course.
- Support is readily available with a very large user base. Open source alternatives can be frustrating when support is needed.
- For larger installs, the architecture can get complicated.
- Pricing could be better. As a Microsoft product, it tends to be expensive.
- For larger organizations, the layout can be complicated, and it is easy to lose your place. A share point environment can be expansive, so a way to navigate without getting lost is crucial.
- Content Management
- Search ability
- Team work space
- Data sharing/collaboration
- Employee go to for any information
- Office 365 has limitations, however, easy access and secure access is a key
- Could be tricky and complex to set up the security permissions, specially on Office 365
- Setting up workflow could be challenging
Great program
- Searching is very easy with SharePoint.
- Very user-friendly.
- Easy to navigate.
- Customer service times can be bothersome.
- Since it is internet based it can't be 100% reliable, but you will have that problem with any cloud based storage.
SharePoint Review
- SharePoint is great for document storage.
- SharePoint has good security features to secure your documents.
- SharePoint offers version control of your documents.
- SharePoint allows you to create multiple intranet websites that can be used for various purposes such as dept. collaboration.
- Sharing documents with people/companies that are external to the organization can sometimes be a challenge.
Consistency is key with MS Sharepoint
- The file sharing is definitely a plus - to be able to share amongst the entire organization saves time and money.
- Ease of use is another plus - even a beginner can easily learn how to use the tool.
- File management is another great benefit for using MS SharePoint.
- Limitations with integration of some Microsoft products is an area of improvement.
- Response time can also be an area of improvement.
- Portability is a limitiation as well and has room of improvement.
- Document Coloboration
- Speed
- Clean User Interface
- More security
MS SharePoint / SQL Review
- It's good resource to store documentation for specific projects.
- It's a good tool to allow teams to stay organized.
- It can serve as a file server in some ways.
- We used to utilize it as a knowledge base, but we've moved away to other tools that execute this functionality better.
- We also used to use SharePoint as a technology wiki, which would allow our employees to quickly find documentation and edit/update obsolete documentation, but we've found that the ServiceNow platform works better since its tightly integrated with out ticketing system.
- We store all of our SharePoint servers on site. A hosted platform may save us some money.
SharePoint Review
- Coordinates with OneDive and Apps for all electronic devices.
- SharePoint intranet improves employee collaboration and business practices.
- SharePoint workflows streamline and automate a variety of business processes.
- The process of uploading different types of documents into SharePoint needs to be improved.
- Integration to additional Apps.
Sharepoint Review
- Portal
- Shared drive
- Forms
- Templates for knowledgebase
SharePoint on SQL Server
- Document versioning - provides an easy way to view the history of a document and allow for collaboration
- Customization - easy to build custom pages to accomplish what you need
- Integration - works well with the rest of MS Office
- Search is not up to modern standards
- Database storage of all documents as BLOBs makes the databases overly large
- Settings required make a dedicated SQL instance required
SharePoint review
- Simple to implement in vanilla approach
- Big community
- The main pros: it's big platform which can be customized in very simple way to relevant business need. And this is a big con too
- Good UX
- Based on implementation - not so big maintenance cost.
- Can be fully implemented as self-service approach - users can create sites/libraries/pages by themselves.
- Performance, when implementing in global environment
- Limited actions in OOTB Workflows
- No OOTB option to create Read-only columns in Lists
- No OOTB option to create dependencies between columns in the List
- Too many helper tools, need to know where to use and how to start
- Lock-in with Microsoft
Beyond the hype
- Authentication and authorization is built-in and can be administered by non-IT folks.
- User interface is built-in and can be administered by non-IT folks.
- Internationalization is built-in
- Querying large lists
- Sharepoint is not a relational database management system(DBMS), but it should be. Querying SharePoint data should be not different than querying SQL server.
- Business connectivity services (BCS) is not intuitive and difficult to implement.
SQL Server is an asset
- The transact-sql implementation used by SQL Server is far superior than any other database engine that I have used.
- SQL Server has the best object-relational mapping support available (ex: Entity Framework)
- Debugging complicated scripts is extremely easy and intuitive when using the tools supplied with SQL Server
- SQL Server has been around for many years and is debatably the father to many other databases engines. Microsoft pays good attention to SQL Server, and continues to improve as the product grows older.
- SQL Server is a windows-based product; it can't be used in as many applications as I would like due to OS limitations. This will never change, but is sometimes an issue.
- SQL Server is not exactly a "light" database. It is a heavy install. SQL Server offers a "compact" edition, but it isn't straight-forward to use.
- The learning curve for a SQL Server installation can be extreme.
SharePoint/SQL 2010 for a Large Enterprise with Multiple Needs
- Document publishing, sharing, and versioning
- List management
- Stable performance of the platform
- Typical UX is perceived by many users as difficult or clunky
- Help is often obscure or too general for typical users
- WYSIWYG editing of content for pages/posts is feature-rich, but still lacks some more advanced capability for layout control.
MS SQL Server provides you an optimal database management environment
- Very robust framework for database querying
- Good processing speeds when dealing with large data
- Seemless integration with other MS products like Visual Studio and Sharepoint
- MS SQl Server Management Studio runs slower with ODBC connections and when ported over server proxies
Share a Point with SharePoint
- Relays information
- Stores important MS documents
- Enterprise organization for department executives
- Editing pages could be more user friendly.
- Attach departments to documents, like file sharing.
- Connect with LinkedIn and Twitter
SharePoint 2013
- Probably the best feature of SharePoint is the ability to search / crawl through various content sources and provide reliable information to our users. The search capability in SharePoint 2013 provides the capability to index content stored in SharePoint, such as webpages, list items, and document content. In addition, SharePoint Server search can index content held in other repositories, such as file shares, other websites, Exchange Server, and external databases. In this way, SharePoint Search can provide users with an easy way to find specific content from large data stores, provide metadata-based refinement capabilities, and provide search administrators with the ability to promote certain content where appropriate.
- SharePoint web content management (WCM) is a very useful feature which allows you to customize your users experience based on the way they access the site. WCM extends some of the ECM functionality into web content capabilities, such as version control, content approval and publishing, content deployment, cross-site publishing, managed navigation, and device-specific targeting.
- Business Intelligence in SharePoint 2013 provides organizations with the ability to analyze business data in many different ways. BI features include the ability to display updated chart information, key performance indicators (KPIs), dashboards, and data-driven Visio diagrams directly on a page. Tools such as PowerPivot can give users the ability to process data from billions of rows, and SQL reporting services integration provides the ability to create libraries of reports to match management requirements.
- SharePoint provides a lot of key functionality and they are becoming better integrated with their other products. Tighter integration will make this a better product with each additional version.