SAP BW/4HANA vs. Toad Data Point

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
SAP BW/4HANA
Score 8.5 out of 10
N/A
SAP BW/4HANA is a next-generation data warehouse solution. It is specifically designed to use the advanced in-memory capabilities of the SAP HANA platform. For example, SAP BW/HANA can integrate many different data sources to provide a single, logical view of all the data. This could include data contained in SAP and non-SAP applications running on-premise or in the cloud, and data lakes, such as those contained in the Apache Hadoop open-source software framework. With SAP BW/4HANA,…N/A
Toad Data Point
Score 8.0 out of 10
N/A
Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and workflow automation.
$365
Pricing
SAP BW/4HANAToad Data Point
Editions & Modules
No answers on this topic
Base Edition
$365
Pro Edition
$528
Offerings
Pricing Offerings
SAP BW/4HANAToad Data Point
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Community Pulse
SAP BW/4HANAToad Data Point
Features
SAP BW/4HANAToad Data Point
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
SAP BW/4HANA
9.2
4 Ratings
3% above category average
Toad Data Point
-
Ratings
Multi-User Support (named login)9.74 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.74 Ratings00 Ratings
Single Sign-On (SSO)9.74 Ratings00 Ratings
Location-Based Data Governance8.04 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
SAP BW/4HANA
9.6
4 Ratings
4% above category average
Toad Data Point
-
Ratings
Data model creation9.64 Ratings00 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
SAP BW/4HANA
8.9
3 Ratings
18% above category average
Toad Data Point
-
Ratings
Visualization8.93 Ratings00 Ratings
Data Warehouse
Comparison of Data Warehouse features of Product A and Product B
SAP BW/4HANA
8.5
4 Ratings
1% above category average
Toad Data Point
-
Ratings
High-Volume Data Processing9.64 Ratings00 Ratings
Data Warehouse Management10.04 Ratings00 Ratings
Administrative Automation7.43 Ratings00 Ratings
Self-Optimization6.93 Ratings00 Ratings
Best Alternatives
SAP BW/4HANAToad Data Point
Small Businesses
Google BigQuery
Google BigQuery
Score 8.7 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 9.3 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 9.8 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
SAP BW/4HANAToad Data Point
Likelihood to Recommend
8.0
(9 ratings)
7.0
(10 ratings)
Usability
8.0
(2 ratings)
10.0
(2 ratings)
Support Rating
9.7
(7 ratings)
-
(0 ratings)
User Testimonials
SAP BW/4HANAToad Data Point
Likelihood to Recommend
SAP
SAP BW/4HANA is certainly an excellent choice when it comes to setting up a data warehousing platform within a landscape of existing SAP systems ecosystem for realizing quick time to value and ROI over the long term. Many non-SAP analytics tools such as Power BI , Qlik also now offer connectors to leverage SAP BW/4HANA data as additional options to deploy third party visualization tools which make it a more open ended platform of choice. But with the future roadmap of SAP and industry in general being focused towards cloud based offerings (SAC and Datasphere) infused with AI capabilities one has to make a judicious choice among these depending on the use case, capabilities of platforms and existing systems landscape and the overall long term IT strategy. SAP BW/4HANA may not be a good platform of choice if starting a native greenfield data warehousing implementation with cloud first approach which would require data integration across SAP and Non-SAP sources and one should consider other SAP cloud offerings which however still have some time to reach a level of maturity as SAP BW/4HANA has reached over the years.
Read full review
Quest Software
Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review
Pros
SAP
  • With ODP based extraction, SAP BW/4HANA does well to integrate the data from various source systems like S4HANA , S4C.
  • With composite providers having the ability to integrate HANA calculation views, we are able to make the best of use of both application layer and data base layer(HANA) for mixed modelling scenarios.
  • with data tiering optimization higher data volume are effectively handled as we have the option to control the amount of data that is being stored in HOT , Warm and cold storage. With data volume grows over the year, DTO comes in handy solution to automatically move the delta to appropriate area based on temporature.
Read full review
Quest Software
  • Export data into excel.
  • Export data into excel using a pivot table functionality.
  • Navigation between windows is intuitive and easy to understand.
  • Good for SQL novices and experts alike.
Read full review
Cons
SAP
  • Better integration with HANA layer with BW/4HANA application
  • Flexibility to provide more secure API's to interact with non-sap Data bases
  • Integration with Gsheets as well like Excel(AFO) and introduce better reporting integration with various reporting tools.
  • Evolution to provide better data lake , data brick options like in BDC
Read full review
Quest Software
  • The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now.
  • Would be nice if the 'Automate' feature was a bit easier to use.
  • Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release).
  • Would be nice if there were fewer releases.
Read full review
Usability
SAP
SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.
Read full review
Quest Software
I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review
Support Rating
SAP
SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.
Read full review
Quest Software
No answers on this topic
Alternatives Considered
SAP
SAP BW / 4HANA and SAP IQ are both used for warehouse; with quick consultations for business analysis and that allows us to obtain dashboards and KPIs efficiently. SAP IQ is columnar and SAP BW / 4HANA immemorial. SAP BW / 4HANA was selected for the response speed of the queries since it saves the information in cache.
Read full review
Quest Software
Although Toad and UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review
Return on Investment
SAP
  • SAP BW/4HANA has been immensely helpful in eliminating alternate silos of data creation by business users thereby ensuring data integrity and consistency across the organization. The focus is now more on data analysis as opposed to data preparation in spreadsheets saving users hours of laborious manual work in collating data.
  • We have been able to quickly integrate and leverage data from multiple SAP systems into SAP BW/4HANA to drive holistic decision making within the organization including streamlining the month end close process using BPC.
  • Excel friendly reporting tools such as Analysis for Office have made it much easier for user adoption and training making change management much easier and change the culture within the organization.
Read full review
Quest Software
  • It is the least common denominator - not particularly optimized for our environment or workflows.
  • Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
  • Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
  • It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.
Read full review
ScreenShots

SAP BW/4HANA Screenshots

Screenshot of Next generation data warehousing with SAP BW/4HANA.Screenshot of SAP BW/4HANA user cockpit.Screenshot of Geolocation analytics in SAP BW/4HANA.Screenshot of Data modeling in SAP BW/4HANA.Screenshot of Modern user experience in SAP BW/4HANA.Screenshot of Monitor the performance of your business in real-time with SAP BW/4HANA.