MS SharePoint / SQL vs. Rational BI

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MS SharePoint / SQL
Score 8.5 out of 10
N/A
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.N/A
Rational BI
Score 7.7 out of 10
Enterprise companies (1,001+ employees)
Rational BI provides analytics, data science and business intelligence in an analytical platform that connects to databases, data files and cloud drives including AWS and Azure data sources, enabling users to explore and visualize data. Users can build real-time notebook-style reports directly in a web browser with JavaScript and SQL with direct and live connections to data. Filter and query data with an SQL database embedded in the client, without network…
$0
single user
Pricing
MS SharePoint / SQLRational BI
Editions & Modules
No answers on this topic
Free
$0
single user
Professional
$129
single user
Enterprise
Varies
single user
Offerings
Pricing Offerings
MS SharePoint / SQLRational BI
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeOptional
Additional DetailsAdditional cost per extra user (varies by edition)
More Pricing Information
Community Pulse
MS SharePoint / SQLRational BI
Considered Both Products
MS SharePoint / SQL
Chose MS SharePoint / SQL
1. Cost affective as it comes with MS 365 Tenant 2. Natively interactive with tools such MS 365 Dynamics ERP, Power Platform etc
Chose MS SharePoint / SQL
Ease of use being the biggest benefit, speed and availability are right there behind ease of use.
Chose MS SharePoint / SQL
SharePoint is more reliable in terms of data storage, security, and accessibility by only required users compared to ClickUp. Also, SharePoint is easier to learn and use for any user, as tutorials are easily available online. Also, SharePoint is a product of Microsoft, which …
Chose MS SharePoint / SQL
Simple: MS Sharepoint/SQL is the best and robust databases motor now are incorporating some features in order to improve users and DB admins experience.
Chose MS SharePoint / SQL
The user interface and search elements are much better than our outgoing data storage method.
Chose MS SharePoint / SQL
Box is a content storing portal where you can host and share documents/files to others. But it does not have [Sharepoint's] capabilities like... versions, automation, email approvals, etc. And Microsoft Exchange is a mailing database that can be used for exchanging data using …
Chose MS SharePoint / SQL
Has better support than MySQL and more developers are familiar with it. Oracle syntax is more cumbersome and less developers are experienced these days with Oracle.
Chose MS SharePoint / SQL
I have heard that the one that comes close is a tool called Apex. Some of the leading companies are using it instead of SQL.
Chose MS SharePoint / SQL
If you are looking for a document management and collaboration tool to use as a web portal that comes with SQL data base and easy to manage and something you can learn very quick, look no further than SharePoint but if you need a pure database then this is not for you.
Chose MS SharePoint / SQL
We use MS SQL more just because of how widely it's used and how popular it is. It's easier to install, maintain, and support compared to the other ones we've tried.
Chose MS SharePoint / SQL
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian confluence and were successful. Confluence is cheaper than Sharepoint which is why we …
Chose MS SharePoint / SQL
At its core, MS SharePoint (with SQL) is for managing document-based content. It falls just short of being a best in class records manager (it does offer some features for this though), and it isn't the easiest to solution to make great looking modern and engaging web sites. …
Chose MS SharePoint / SQL
We looked at Google Drive but it didn't have the API and integration that SharePoint has with 3rd party software providers. Also, Google Drive has basic functionality compared to MS SharePoint and how you can customize and build-out.
Chose MS SharePoint / SQL
I haven't used any other products that compete with it. I started my career at Microsoft and the two subsequent locations have also been Microsoft shops.
Chose MS SharePoint / SQL
Dropbox is a user-friendly product, but Sharepoint is a native Microsoft product that can be implemented into any Microsoft products, which are used mostly in our environment. Finding solutions on the internet is much easier, as it is used commonly by other organizations as …
Chose MS SharePoint / SQL
I am not familiar with any other products similar to SharePoint, so I am unable to compare.
Chose MS SharePoint / SQL
Mostly, we are a Microsoft shop, and SharePoint and SQL integrate with our other applications. They're easy to use, and not too hard to manage.
Chose MS SharePoint / SQL
I have used both Google Drive and Zoho Docs which seem similar to MS SharePoint. The main differences I noticed as a user is that the user interfaces in both Google Drive and Zoho Docs were much more intuitive and they were much easier to navigate than MS SharePoint. There …
Chose MS SharePoint / SQL
We had staff resources able to create, configure, and mange our sharepoint environment, so it made sense for us and gave us greater flexibility than these turnkey solutions. Certainly each solution has its merits and each are completely different price points. We already had …
Chose MS SharePoint / SQL
Most of the applications used within our company have a SharePoint back end therefore I have not used anything other than SharePoint.
Chose MS SharePoint / SQL
We evaluated Atlassian Confluence and compared it to our current SharePoint implementation. We felt that the two products were quite similar in the user experience but we chose to keep our SharePoint farms up and running. This was mainly due to the cost of switching and the …
Chose MS SharePoint / SQL
Actually i didnt work with other than ms sharepoint so i cant say how it is stand for others
Rational BI
Chose Rational BI
Rational BI allows a deeper data analysis with respect to the other software I experimented with. The velocity to perform the analysis is similar to the other one. The predictive analysis could be very useful, but at the moment I do not use it in my activities. Dashboards are …
Chose Rational BI
Rational BI offers richer data visualization components when compared to other BI products. It is visualization options are much more broader and can be complimented by on JavaScript graphic libraries available on the web. It also offers high performance and faster page load …
Chose Rational BI
Today there are many companies providing BI solutions, and generally, I think Microsoft Power BI is the easiest go-to solution as it is part of the Office365 software. However all software solutions have their limitations, advantages, and disadvantages, but sometimes you don't …
Chose Rational BI
Rational BI is one of the leading business intelligence software products. Ease of use is imperative when bringing on a new software product, you want your folks to have a very low learning curve. The rationale is pretty easy right out of the box, I like the fact that …
Features
MS SharePoint / SQLRational BI
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
MS SharePoint / SQL
7.7
Ratings
6% below category average
Rational BI
8.3
Ratings
1% below category average
Pixel Perfect reports8.70 Ratings7.60 Ratings
Customizable dashboards7.00 Ratings8.70 Ratings
Report Formatting Templates7.40 Ratings8.50 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
MS SharePoint / SQL
8.2
Ratings
2% above category average
Rational BI
8.3
Ratings
4% above category average
Drill-down analysis7.90 Ratings7.70 Ratings
Formatting capabilities8.40 Ratings8.20 Ratings
Integration with R or other statistical packages8.00 Ratings8.00 Ratings
Report sharing and collaboration8.60 Ratings9.20 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
MS SharePoint / SQL
8.9
Ratings
7% above category average
Rational BI
9.0
Ratings
6% above category average
Publish to Web8.70 Ratings9.00 Ratings
Publish to PDF9.40 Ratings9.00 Ratings
Report Versioning8.20 Ratings8.60 Ratings
Report Delivery Scheduling9.00 Ratings9.20 Ratings
Delivery to Remote Servers9.00 Ratings9.30 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
MS SharePoint / SQL
8.6
Ratings
8% above category average
Rational BI
8.2
Ratings
1% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)8.70 Ratings8.20 Ratings
Location Analytics / Geographic Visualization8.00 Ratings8.30 Ratings
Predictive Analytics9.30 Ratings7.90 Ratings
Pattern Recognition and Data Mining8.40 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
MS SharePoint / SQL
8.2
Ratings
3% below category average
Rational BI
-
Ratings
Multi-User Support (named login)8.00 Ratings00 Ratings
Role-Based Security Model8.10 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.30 Ratings00 Ratings
Report-Level Access Control7.90 Ratings00 Ratings
Single Sign-On (SSO)8.70 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
MS SharePoint / SQL
9.4
Ratings
18% above category average
Rational BI
-
Ratings
Responsive Design for Web Access9.50 Ratings00 Ratings
Mobile Application9.40 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.70 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
MS SharePoint / SQL
8.8
Ratings
12% above category average
Rational BI
-
Ratings
REST API9.30 Ratings00 Ratings
Javascript API9.30 Ratings00 Ratings
iFrames9.00 Ratings00 Ratings
Java API9.00 Ratings00 Ratings
Themeable User Interface (UI)8.00 Ratings00 Ratings
Customizable Platform (Open Source)8.10 Ratings00 Ratings
Best Alternatives
MS SharePoint / SQLRational BI
Small Businesses
BrightGauge
BrightGauge
Score 9.0 out of 10
Supermetrics
Supermetrics
Score 10.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
Supermetrics
Supermetrics
Score 10.0 out of 10
Enterprises
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
Dataiku
Dataiku
Score 7.6 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MS SharePoint / SQLRational BI
Likelihood to Recommend
8.8
(0 ratings)
7.7
(0 ratings)
Likelihood to Renew
8.8
(0 ratings)
-
(0 ratings)
Usability
9.0
(0 ratings)
8.7
(0 ratings)
Support Rating
8.8
(0 ratings)
7.7
(0 ratings)
Implementation Rating
7.0
(0 ratings)
-
(0 ratings)
User Testimonials
MS SharePoint / SQLRational BI
Likelihood to Recommend
As I mentioned in my previous answers, MS SharePoint is very useful as a shared drive for the organization and is very easy to manage. It also helps us import data from SharePoint directly into PowerBI for creating reports. According to my understanding, only share link features should be improved.
Read full review
Rational BI allows managing data analysis coming from different projects in order to create useful reports and dashboards. I usually set up automatically scheduled reports. All the stakeholders can easily share a rational view with the possibility to filter between the interesting arguments. Sometimes different user profiles could be needed, optimize the view.
Read full review
Pros
  • 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.
Read full review
  • Provides high performance embedded analytics
  • Seamless integration to import and export data
  • Rich features for data visualization
Read full review
Cons
  • 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
Read full review
  • Documentation for new users could be better. Sometimes it's hard for my users that are not that skilled in IS/IT to set up data connectors are understand the dynamics of data sources.
  • I have used several other BI solutions as well, and their GUI is okay, but surely there is also room for improvement here. Not all things are made entirely logically.
  • Understanding their price structure. Generally, their website looks nice, but it's not very informative when it comes to pricing, and support options. I really miss some kind of transparency and overview.
Read full review
Likelihood to Renew
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
Read full review
No answers on this topic
Usability
I gave this rating due to MS SharePoint being a big help with our userbase. We have a lot of users that are just old enough to not have much technical skills or they have been in this industry long enough to where they haven't really needed to utilize much technology. MS SharePoint helped us move beyond that barrier without too many bumps and bruises.
Read full review
Rational BI allows managing data analysis coming from different projects. The outputs are one or more reports, that can be delivered automatically to the stakeholders or other communication media inside the organization. Nice dashboards help to describe and analyze data. Sometimes different user profiles could be needed, optimize the view.
Read full review
Support Rating
I've only had to call in to support on one occasion but they were able to work though our issue and find a solution that did fully resolve the issue in a timely manner. I can't always say the same about support from other companies so it was a refreshing change to have support that did help.
Read full review
I haven't had to use support to date for this product.
Read full review
Implementation Rating
Mo major insight regarding the implementation if very well documented for standard products.
Read full review
No answers on this topic
Alternatives Considered
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.
Read full review
Today there are many companies providing BI solutions, and generally, I think Microsoft Power BI is the easiest go-to solution as it is part of the Office365 software. However all software solutions have their limitations, advantages, and disadvantages, but sometimes you don't need the perfect solution. You just need a solution that delivers 80-90 percent of the full potential to reach your goal and in this scope, we were really happy with Rational BI.
Read full review
Return on Investment
  • ROI for ms SharePoint/SQL considering that is the best database engine with excellent features that help you to have all information in your hand.
  • Something negative could be license format.
  • These are the best relational databases in the market with powerful features that complement your system.
Read full review
  • Allows folks to work on other items as reporting is done in the background.
  • Scheduling and delivery of reports with one click.
  • Single pane of management.
  • Ease of use.
Read full review
ScreenShots

Rational BI Screenshots

Screenshot of Modern Business IntelligenceScreenshot of Drag-and-drop InsightsScreenshot of Accessible for everyone, power when you need itScreenshot of Beautiful analytics on every screen and deviceScreenshot of Scheduled reporting: Broadcast your findings to everyoneScreenshot of Connect all your data no matter where it lives