TrustRadius
MS SharePoint / SQL Review 1 of 50
MS SharePoint / SQL Review: "Perfect Data Integration Tool"
https://www.trustradius.com/business-intelligence-biMS SharePoint / SQLUnspecified7.7621101
Sirish Vadala profile photo
January 11, 2019

MS SharePoint / SQL Review: "Perfect Data Integration Tool"

Score 7 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with MS SharePoint / SQL

Sharepoint is used across all the departments in the organization. Sharepoint enables us to monitor, collect, and analyze critical business data from desktops, smartphones, or any Internet-enabled devices, in order to achieve an accurate view of business operations.
  • 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.
  • Liferay Digital Experience Platform (DXP)
MS SharePoint integrates excellently with all the MS Office products, making it the default choice for any organization using MS Office. Comparatively, it's easier to build a portal on SharePoint than on Liferay for our requirements.
Easy to integrate and connect to variety of databases including SQL Server and Oracle Its possible to have a one way or optional two way connectivity. Provides flexibility of giving notifications on external data changes.
Once the database connection is set up, connected data is always up to date. This gives us the latest updated reports without issues.
Extremely well suited when interacting with a large audience. Also integrates seamlessly with MS office products like MS Word and MS Excel. Easy to build a portal and customize for each set of users. Not well suited when speed is of the essence. Sometimes loading the calendars and data is pretty slow for huge datasets.

MS SharePoint / SQL Feature Ratings

Pixel Perfect reports
8
Customizable dashboards
10
Report Formatting Templates
9
Drill-down analysis
9
Formatting capabilities
9
Integration with R or other statistical packages
9
Report sharing and collaboration
9
Publish to Web
7
Publish to PDF
8
Report Versioning
8
Report Delivery Scheduling
8
Delivery to Remote Servers
7
Pre-built visualization formats (heatmaps, scatter plots etc.)
9
Location Analytics / Geographic Visualization
9
Predictive Analytics
8
Multi-User Support (named login)
9
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
9
Single Sign-On (SSO)
9
Responsive Design for Web Access
9
Dedicated iOS Application
8
Dedicated Android Application
9
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
9
Javascript API
8
iFrames
8
Java API
8
Themeable User Interface (UI)
8
Customizable Platform (Open Source)
9