Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
$4,700
per month 5000 Synapse Commit Units (SCUs)
SAP Analytics Cloud
Score 8.2 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
Azure Synapse Analytics
SAP Analytics Cloud
Editions & Modules
Tier 1
$4,700
per month 5,000 Synapse Commit Units (SCUs)
Tier 2
$9,200
per month 10,000 Synapse Commit Units (SCUs)
Tier 3
$21,360
per month 24,000 Synapse Commit Units (SCUs)
Tier 4
$50,400
per month 60,000 Synapse Commit Units (SCUs)
Tier 5
$117,000
per month 150,000 Synapse Commit Units (SCUs)
Tier 6
$259,200
per month 360,000 Synapse Commit Units (SCUs)
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
Azure Synapse Analytics
SAP Analytics Cloud
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
A 30-day trial with SAP Analytics Cloud is available, supporting analytics enterprise-wide. A trial can be extended up to 90 days on request.
It's well suited for large, fastly growing, and frequently changing data warehouses (e.g., in startups). It's also suited for companies that want a single, relatively easy-to-use, centralized cloud service for all their data needs. Larger, more structured organizations could still benefit from this service by using Synapse Dedicated SQL Pools, knowing that costs will be much higher than other solutions. I think this product is not suited for smaller, simpler workloads (where an Azure SQL Database and a Data Factory could be enough) or very large scenarios, where it may be better to build custom infrastructure.
>> 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.
Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
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.
With Azure, it's always the same issue, too many moving parts doing similar things with no specialisation. ADF, Fabric Data Factory and Synapse pipeline serve the same purpose. Same goes for Fabric Warehouse and Synapse SQL pools.
Could do better with serverless workloads considering the competition from databricks and its own fabric warehouse
Synapse pipelines is a replica of Azure Data Factory with no tight integration with Synapse and to a surprise, with missing features from ADF. Integration of warehouse can be improved with in environment ETl tools
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.
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.
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
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.
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.
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
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
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.
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
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
In comparing Azure Synapse to the Google BigQuery - the biggest highlight that I'd like to bring forward is Azure Synapse SQL leverages a scale-out architecture in order to distribute computational processing of data across multiple nodes whereas Google BigQuery only takes into account computation and storage.
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
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.
Licensing fees is replaced with Azure subscription fee. No big saving there
More visibility into the Azure usage and cost
It can be used a hot storage and old data can be archived to data lake. Real time data integration is possible via external tables and Microsoft Power BI
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.
