Apache Hive vs. SAP Analytics Cloud

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Hive
Score 8.0 out of 10
N/A
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A
SAP Analytics Cloud
Score 8.1 out of 10
N/A
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 processes enterprise-wide to help make decisions without doubt.
$36
per month per user
Pricing
Apache HiveSAP Analytics Cloud
Editions & Modules
No answers on this topic
SAP Analytics Cloud for Business Intelligence
$36.00
per month per user
SAP Analytics Cloud for Planning
Price upon request
per month per user
Offerings
Pricing Offerings
Apache HiveSAP Analytics Cloud
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsA 30-day trial with SAP Analytics Cloud is available, supporting analytics enterprise-wide. A trial can be extended up to 90 days on request.
More Pricing Information
Community Pulse
Apache HiveSAP Analytics Cloud
Features
Apache HiveSAP Analytics Cloud
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.8
323 Ratings
5% below category average
Pixel Perfect reports00 Ratings7.5272 Ratings
Customizable dashboards00 Ratings8.2314 Ratings
Report Formatting Templates00 Ratings7.6290 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.7
328 Ratings
4% below category average
Drill-down analysis00 Ratings8.1318 Ratings
Formatting capabilities00 Ratings7.6315 Ratings
Integration with R or other statistical packages00 Ratings7.0238 Ratings
Report sharing and collaboration00 Ratings8.3305 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.7
309 Ratings
7% below category average
Publish to Web00 Ratings8.0263 Ratings
Publish to PDF00 Ratings8.1295 Ratings
Report Versioning00 Ratings7.7255 Ratings
Report Delivery Scheduling00 Ratings7.6250 Ratings
Delivery to Remote Servers00 Ratings6.941 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.5
315 Ratings
6% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.8299 Ratings
Location Analytics / Geographic Visualization00 Ratings7.7288 Ratings
Predictive Analytics00 Ratings7.5287 Ratings
Pattern Recognition and Data Mining00 Ratings7.181 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
8.1
323 Ratings
5% below category average
Multi-User Support (named login)00 Ratings8.2297 Ratings
Role-Based Security Model00 Ratings8.0305 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.0298 Ratings
Report-Level Access Control00 Ratings8.1110 Ratings
Single Sign-On (SSO)00 Ratings8.3302 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.4
273 Ratings
5% below category average
Responsive Design for Web Access00 Ratings7.4262 Ratings
Mobile Application00 Ratings6.9230 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.1255 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Apache Hive
-
Ratings
SAP Analytics Cloud
7.1
50 Ratings
9% below category average
REST API00 Ratings7.044 Ratings
Javascript API00 Ratings7.041 Ratings
iFrames00 Ratings7.132 Ratings
Java API00 Ratings7.033 Ratings
Themeable User Interface (UI)00 Ratings7.440 Ratings
Customizable Platform (Open Source)00 Ratings6.835 Ratings
Best Alternatives
Apache HiveSAP Analytics Cloud
Small Businesses
Google BigQuery
Google BigQuery
Score 8.8 out of 10
Yellowfin
Yellowfin
Score 8.7 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 9.8 out of 10
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache HiveSAP Analytics Cloud
Likelihood to Recommend
8.0
(35 ratings)
8.6
(318 ratings)
Likelihood to Renew
10.0
(1 ratings)
8.6
(14 ratings)
Usability
8.5
(7 ratings)
8.1
(250 ratings)
Support Rating
7.0
(6 ratings)
6.0
(70 ratings)
In-Person Training
-
(0 ratings)
9.0
(1 ratings)
Online Training
-
(0 ratings)
8.0
(1 ratings)
Implementation Rating
-
(0 ratings)
8.0
(7 ratings)
Contract Terms and Pricing Model
-
(0 ratings)
8.0
(1 ratings)
Professional Services
-
(0 ratings)
8.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
8.0
(1 ratings)
User Testimonials
Apache HiveSAP Analytics Cloud
Likelihood to Recommend
Apache
Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
Read full review
SAP
>> Using SAC predictive analytics capabilities for inventory management in a Production line setup has helped generate Purchase Requisitions and Purchase Orders for raw or semi-finished goods without much head-banging into Demand management rules. It does it beautifully with seamless integration with HANA core MM and PP modules, along with BI integration. It has resulted in 30% greater warehouse storage capacity, thereby saving revenue from piled-up inventory and associated manpower costs. >> SAC sometimes shows latency in working out a large data set, thus giving a poor user experience compared to its competition. Also, it may occasionally show misinterpretations when embedding data from 3rd-party systems into the HANA core dataset.
Read full review
Pros
Apache
  • Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax.
  • Relatively easy to set up and start using.
  • Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved.
Read full review
SAP
  • It makes it easier yo analyse order and related records easily.
  • We can easily maintain and track the performance of employees in organisation.
  • Can easily track various aspects for the growth of an organisation thus allowing real time analysis and tracking of organisation's growth and performance.
Read full review
Cons
Apache
  • Some queries, particularly complex joins, are still quite slow and can take hours
  • Previous jobs and queries are not stored sometimes
  • Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond).
  • Sometimes, directories and tables don't load properly which causes confusion
Read full review
SAP
  • Complexity in Data Modeling
  • SAC supports various data sources, but improvements in the ease of connecting to and integrating with certain data repositories, especially non-SAP databases, would enhance the platform's versatility and integration capabilities.
  • An offline mode for SAC could be valuable for users who need to access and analyze data without an internet connection. Additionally, optimizing performance for large datasets and complex visualizations would contribute to a smoother user experience.
Read full review
Likelihood to Renew
Apache
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Read full review
SAP
We are planning to review the licensing as we have issues with SAC dealing with huge datasets. Analytics area is good for import models but when we have live connections in place that's when we have issue with SAC dealing with huge datasets in live be it BW or be it HANA models in the backend.
Read full review
Usability
Apache
Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.
Read full review
SAP
On a scale of 1 to 10, I would rate 8 SAP Analytics Cloud's overall usability as a 7. SAC has a clean, modern user interface with drag-and-drop features. It is an integrated platform that combines reporting, planning, and predictive analytics in one tool. It has Real-time connectivity with SAP data sources like S/4HANA.


Self-service analytics capabilities allow non-technical users to build simple dashboards.
Read full review
Reliability and Availability
Apache
No answers on this topic
SAP
I would rate SAP Analytics Cloud an 8 out of 10 for scalability. It offers a flexible, cloud-based architecture that supports expansion across departments and geographies. The platform adapts well to growing data volumes and user needs, making it a strong choice for organizations looking to scale analytics capabilities efficiently.
Read full review
Performance
Apache
No answers on this topic
SAP
I would rate SAP Analytics Cloud’s performance an 8 out of 10. Pages generally load quickly, and reports run within a reasonable time frame, even with complex datasets. Integration with other systems is smooth and doesn’t noticeably affect performance. Overall, it’s a responsive and efficient tool for business analytics. But
Read full review
Support Rating
Apache
Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
Read full review
SAP
Since the implementation stage, the support team has been very helpful and assisting. Even in the later stages, the tech team had quite a rapid response. In general, SAP has provided us with great customer support, let it be for a specific product of SAP or for integration of different modules.
Read full review
In-Person Training
Apache
No answers on this topic
SAP
Good videos and reference material available in SAP Portal.
Read full review
Online Training
Apache
No answers on this topic
SAP
In hindsight, it would have been easier to have someone there in person. Questions were answered, but with 11 participants, it got a bit chaotic online
Read full review
Implementation Rating
Apache
No answers on this topic
SAP
SAC is a simple solution ad it works fine when connecting it to other SAP tools. On the other hand, connecting it to third party solutions brings difficulties when there's no previous design and the objetives are not clear. It is really important to integrate Business users from the start to provide with valuable business insights
Read full review
Alternatives Considered
Apache
Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed. Amazon Redshift is the another product, I used in my recent organisation. Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
Read full review
SAP
SAP Analytics Cloud and Power BI are both tools that help businesses understand their data, but they have some differences. SAC, made by SAP, works well if your company already uses other SAP products. It's in the cloud, easy to use, and has features for analyzing data, getting insights, and planning for the future. Power BI, made by Microsoft, can be used in the cloud or on your own computers. It fits well with Microsoft tools, is easy to use, and can do advanced data analysis. SAC has built-in planning tools, while Power BI needs extra tools for detailed planning
Read full review
Contract Terms and Pricing Model
Apache
No answers on this topic
SAP
unit pricing
Read full review
Scalability
Apache
No answers on this topic
SAP
Is good for use across multiple locations. It allows users to access data and reports from anywhere, regardless of their location. Can consolidate data from various sources, including different SAP systems and external sources, which facilitates cross-location analysis. SAC enables access to data and models from SAP Datasphere to create new stories. Detailed permissions can be defined for cross-departmental use.
Read full review
Professional Services
Apache
No answers on this topic
SAP
very simple
Read full review
Return on Investment
Apache
  • Apache hive is secured and scalable solution that helps in increasing the overall organization productivity.
  • Apache hive can handle and process large amount of data in a sufficient time manner.
  • It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs.
Read full review
SAP
  • Many manual data manipulations and exports in Excel have been replaced by the tool, providing management with improved insight into the amount of time spent at each stage of an invoice's lifetime, allowing bottlenecks to be discovered.
  • We now have more insight into the data, and people with little technical experience can easily build stories.
Read full review
ScreenShots