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)
IBM Informix
Score 9.9 out of 10
N/A
Informix is an embedded relational database offering from IBM.
N/A
SAP Datasphere
Score 8.5 out of 10
N/A
SAP Datasphere, the next generation of SAP Data Warehouse Cloud, is a comprehensive data service that enables data professionals to deliver seamless and scalable access to mission-critical business data. It provides a unified experience for data integration, data cataloging, semantic modeling, data warehousing, data federation, and data virtualization. SAP Datasphere enables users to distribute mission-critical business data — with business context and logic preserved — across the data…
N/A
Pricing
Azure Synapse Analytics
IBM Informix
SAP Datasphere
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)
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure Synapse Analytics
IBM Informix
SAP Datasphere
Free Trial
No
No
Yes
Free/Freemium Version
No
No
No
Premium Consulting/Integration Services
No
No
No
Entry-level Setup Fee
No setup fee
No setup fee
No setup fee
Additional Details
—
—
SAP Datasphere is available as a subscription or consumption-based model. The SAP Datasphere capacity unit (CU) offers an adaptable approach to pricing that enables any workload on any hyperscaler. The number of CUs required is determined by the unique workload, with the ability to tailor the combination of required services within SAP Datasphere utilizing a flexible tenant configuration. The services that contribute to CU consumption are the core application (compute and storage), data lake, BW bridge, data integration, and data catalog (crawling and storage).
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.
IBM Informix creates an effective and secure channel for easy and quick data management and transfer across other major Cloud platforms and other data storage systems. The analytical ability is also the best and most effective visual functionalities and the encryption and the data archiving functionalities are great and easy on reporting.
SAP Datasphere is well suited for scalable cloud based data integration scenarios which also opens up the doors for AI driven insights which are much harder to achieve with on-prem data warehouses. Considering the licensing model of SAP Datasphere being based on consumption driven capacity units cost can be a big consideration for organizations with large volumes of data that can be a pre-requisite for data mining and AI use cases. So this can be a bottleneck or not so well adopted scenario for SAP Datasphere.
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.
Excellent Data Warehouse performance from the basic engine. Outstanding Data Warehouse performance from the Informix Warehouse Accelerator module.
Best embedability among major RDBMS systems.
Scalable from the smallest Raspberry PI up to the largest monolithic systems and out to dozens of distributed nodes.
Hybrid data capabilities to merge relational data with time seriesv, geospacial data, JSON data and other non-traditional data types with performance comparable or better than systems dedicated to those data types.
SAP Data Warehouse Cloud offers free trial for 90 days with free 128 GB of storage and 64 GB memory.
Availability of self-service data modeling and analytics on SAP Data Warehouse Cloud enables users to access and analyze data without getting support from the IT team.
Without zero coding while collecting, connecting, analyzing and modeling data, it saves us time and operational costs of partnering with external IT support experts.
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
It is very difficult to find a missing functionality in Informix, technically is great. I will again criticize the business side and how it has been managed over the past, I hope this could be improved with HCL's help. I know they are working hard, but we need to start letting the world know and revert their concept about its existence and that it is one of the best competitors within the data treatment, in the market. We need to start telling the world about success cases and stories showing this and backing up its strong technology.
We are moving into using SAP datasphere heavily and replacing all of the SAP HANA native calc view logic to the sap datasphere graphical view which will reduce the legacy SAP BW data warehouse. Also need some more features such as debugging, sql preview and prompts enhancements so that we can generate the reports.
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.
It is one of the best tools and a boon to Logistics teams across the globe. One tends to actually process warehousing data so smoothly and the way demonstration is made while in programs it makes it user friendly. The Inventory touch points that one identify is simply awesome and is best part.
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.
I would greatly acknowledge the services of Sap Data [warehouse Cloud] because we were struggling before its arrival where we used to get manual data connections and this used to consume a lot of time but after its use, we now are able to connect data easily saving a lot of time and finances.
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.
IBM Informix creates effective solutions for big data extraction and data transportation functionalities across the entire Cloud services and the Automation ability is the best. The security that IBM Informix provides for all our business data and other project information and contacts is effective and the reports are very clean and easy to understand.
Each of these listed software has its own unique strength and capacity that scales well. SAP Datasphere on its end up against them with more suitability for large establishments with complex data ecosystems with scalability support. Also, it avails a pay-as-you-go pricing for users, and it is widely up for data quality, data governance, and data discovery.
Despite the pricing model being expensive for small businesses, it provides decent features and capabilities for organizations of different sizes and it's an appropriate investment in today's business environment where there is constant pressure to build a scalable and flexible analytics service
Ever since we implemented SAP Data Warehouse Cloud, we have been able to reduce the additional costs of hiring third-party service providers by incorporating professional services offered by the vendor.
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
Although I do not own nor have visibility on my company's figures:
Informix generates consistent savings on DBA staffing, no need for many DBAs as other DBMS require.
The replication architecture allowed consistent savings in the infrastructure as well as developments and maintenance, the job is already done, no need to develop complex and costly solutions, it's just a matter of configuring it.
The advantages of hybrid development (i.e mixing SQL and NoSQL in the same database) is not just a marketing hype: it allowed us to solve with a brilliant solution, in one afternoon of coding, a functional problem we have been having for more than 10 years!
The biggest drawback is that IBM pricing may be constraining, it has too important gaps between the mid range and highrange in terms of pricing
Preserving data quality has enhanced governance on data by having a single source that is accessible to every business user via self-service capabilities.
Operational cost is lowered by connecting data in one integrated solution hence making it easy to access information without having to keeping logging to other applications. Additionally, no external IT support is needed since SAP Data Warehouse Cloud has no-coding modeling tools.
SAP Data Warehouse Cloud has enabled every business user to understand different data by transforming data to real insights.
