Apache Hadoop vs. MS SharePoint / SQL

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Hadoop
Score 7.2 out of 10
N/A
Hadoop is an open source software from Apache, supporting distributed processing and data storage. Hadoop is popular for its scalability, reliability, and functionality available across commoditized hardware.N/A
MS SharePoint / SQL
Score 8.2 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
Pricing
Apache HadoopMS SharePoint / SQL
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
HadoopMS SharePoint / SQL
Free Trial
NoNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Apache HadoopMS SharePoint / SQL
Considered Both Products
Hadoop

No answer on this topic

MS SharePoint / SQL
Chose MS SharePoint / SQL
We evaluated PgAdmin, MySQL. MS SQL server provides more flexibility with integration and has demonstrated efficient run times for data processing.
Top Pros
Top Cons
Features
Apache HadoopMS SharePoint / SQL
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
7.2
62 Ratings
12% below category average
Pixel Perfect reports00 Ratings7.943 Ratings
Customizable dashboards00 Ratings6.759 Ratings
Report Formatting Templates00 Ratings7.252 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
7.2
57 Ratings
11% below category average
Drill-down analysis00 Ratings6.546 Ratings
Formatting capabilities00 Ratings8.157 Ratings
Integration with R or other statistical packages00 Ratings5.334 Ratings
Report sharing and collaboration00 Ratings8.854 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
7.7
62 Ratings
7% below category average
Publish to Web00 Ratings7.655 Ratings
Publish to PDF00 Ratings8.452 Ratings
Report Versioning00 Ratings7.452 Ratings
Report Delivery Scheduling00 Ratings7.542 Ratings
Delivery to Remote Servers00 Ratings7.535 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
6.6
40 Ratings
18% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings5.738 Ratings
Location Analytics / Geographic Visualization00 Ratings6.035 Ratings
Predictive Analytics00 Ratings7.633 Ratings
Pattern Recognition and Data Mining00 Ratings7.06 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
8.4
74 Ratings
1% below category average
Multi-User Support (named login)00 Ratings8.664 Ratings
Role-Based Security Model00 Ratings8.468 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.673 Ratings
Report-Level Access Control00 Ratings8.28 Ratings
Single Sign-On (SSO)00 Ratings8.259 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
8.2
64 Ratings
4% above category average
Responsive Design for Web Access00 Ratings7.762 Ratings
Mobile Application00 Ratings7.341 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.742 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Apache Hadoop
-
Ratings
MS SharePoint / SQL
7.1
42 Ratings
9% below category average
REST API00 Ratings7.733 Ratings
Javascript API00 Ratings7.932 Ratings
iFrames00 Ratings6.331 Ratings
Java API00 Ratings6.728 Ratings
Themeable User Interface (UI)00 Ratings6.037 Ratings
Customizable Platform (Open Source)00 Ratings7.927 Ratings
Best Alternatives
Apache HadoopMS SharePoint / SQL
Small Businesses

No answers on this topic

BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.9 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 7.7 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache HadoopMS SharePoint / SQL
Likelihood to Recommend
8.0
(37 ratings)
8.1
(83 ratings)
Likelihood to Renew
9.6
(8 ratings)
8.8
(7 ratings)
Usability
8.0
(6 ratings)
8.2
(18 ratings)
Performance
8.0
(1 ratings)
-
(0 ratings)
Support Rating
7.5
(3 ratings)
8.8
(7 ratings)
Online Training
6.1
(2 ratings)
-
(0 ratings)
Implementation Rating
-
(0 ratings)
7.0
(2 ratings)
User Testimonials
Apache HadoopMS SharePoint / SQL
Likelihood to Recommend
Apache
Altogether, I want to say that Apache Hadoop is well-suited to a larger and unstructured data flow like an aggregation of web traffic or even advertising. I think Apache Hadoop is great when you literally have petabytes of data that need to be stored and processed on an ongoing basis. Also, I would recommend that the software should be supplemented with a faster and interactive database for a better querying service. Lastly, it's very cost-effective so it is good to give it a shot before coming to any conclusion.
Read full review
Microsoft
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
Pros
Apache
  • Handles large amounts of unstructured data well, for business level purposes
  • Is a good catchall because of this design, i.e. what does not fit into our vertical tables fits here.
  • Decent for large ETL pipelines and logging free-for-alls because of this, also.
Read full review
Microsoft
  • 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
Cons
Apache
  • Less organizational support system. Bugs need to be fixed and outside help take a long time to push updates
  • Not for small data sets
  • Data security needs to be ramped up
  • Failure in NameNode has no replication which takes a lot of time to recover
Read full review
Microsoft
  • 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
Likelihood to Renew
Apache
Hadoop is organization-independent and can be used for various purposes ranging from archiving to reporting and can make use of economic, commodity hardware. There is also a lot of saving in terms of licensing costs - since most of the Hadoop ecosystem is available as open-source and is free
Read full review
Microsoft
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
Usability
Apache
As Hadoop enterprise licensed version is quite fine tuned and easy to use makes it good choice for Hadoop administrators. It’s scalability and integration with Kerberos is good option for authentication and authorisation. installation can be improved. logging can be improved so that it become easier for debugging purposes. parallel processing of data is achieved easily.
Read full review
Microsoft
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
Support Rating
Apache
It's a great value for what you pay, and most Data Base Administrators (DBAs) can walk in and use it without substantial training. I tend to dabble on the analyst side, so querying the data I need feels like it can take forever, especially on higher traffic days like Monday.
Read full review
Microsoft
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
Online Training
Apache
Hadoop is a complex topic and best suited for classrom training. Online training are a waste of time and money.
Read full review
Microsoft
No answers on this topic
Implementation Rating
Apache
No answers on this topic
Microsoft
Not implemented in best practice way, there are many customizations
Read full review
Alternatives Considered
Apache
Not used any other product than Hadoop and I don't think our company will switch to any other product, as Hadoop is providing excellent results. Our company is growing rapidly, Hadoop helps to keep up our performance and meet customer expectations. We also use HDFS which provides very high bandwidth to support MapReduce workloads.
Read full review
Microsoft
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
Return on Investment
Apache
  • There are many advantages of Hadoop as first it has made the management and processing of extremely colossal data very easy and has simplified the lives of so many people including me.
  • Hadoop is quite interesting due to its new and improved features plus innovative functions.
Read full review
Microsoft
  • 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
ScreenShots