Amazon Redshift vs. SAP Datasphere

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)

Incentivized

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.

Incentivized

• Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
• Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
• Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
• Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.

Incentivized

• 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.

Incentivized

• It could benefit from adding data integrity and programming tools common to other database management systems.
• Amazon Redshift is based on PostgreSQL 8.0.2. That version of PostgreSQL was released in December 2006. While PostgreSQL was much improved since then, the new features were not implemented in Redshift. Many basic features are missing from it.
• Primary keys can be declared but not enforced. Referential integrity (foreign keys) can be declared but not enforced. UNIQUE and CHECK constraints are not supported and cannot be declared.
• IDENTITY can be declared on a column, and Redshift will put unique values into it. However: IDENTITY values in the newly inserted rows won’t be incremental or sequential. To implement a sequential number, you need to write your own custom code.
• There are no stored procedures in Redshift. We are writing SQL script files, and then parsing and running them one statement at a time from a Python program. This also enabled us to implement execution-time error logging.
• In SQL scripts, to check for the row count of affected rows, a complicated join query against some system tables or views has to be executed.
• Data Control Language (DCL) does not exist. No statements like IF, WHILE, DO, RAISERROR, etc.
• On performance of views… Views do not “pass-through” a query parameter which is a potential problem for performance.
• When selecting against a view with the WHERE clause outside of the view, the inner query of the view will be executed first without consideration for the WHERE clause, and only then the WHERE clause will be applied.
• Certain clauses of SQL work many times faster than other clauses. So be careful and test your statements for performance earlier rather than later, especially if working with a large data set.
• There was a situation when DELETE FROM JOIN was unacceptably slow. Replacing JOIN with the USING clause made DELETE instantaneous.

Incentivized

• SAP Data Warehouse Cloud is quite complex, therefore, some extra orientation or training might be essential, more so on cloud.
• Secondly, SAP Data installation fee, and the monthly subscription amounts is slightly demanding, and the developer should refocus on changing them.
• Nonetheless, SAP Data rectified other challenges like flexibility and customization, making us happy clients.

Incentivized

Datasphere can come with its own challenges which can feel like a mountain to get over. However, once one has an understanding of how the product works it becomes easier to use. Once the time is spent to get it setup and working correctly very little is needed to keep it running smoothly. Its a great tool it just takes time to learn.

Incentivized

Overall it serves all our aspects of data management like data cleaning, data manipulation, and data reporting on the cloud platform. We can create stored procedures and triggers in it very easily as all the options are self suggested in it. We can easily attach the results of ARS to the other tools as well for drawing the statistical results.

Incentivized

SAP has suggested that BW 7.5 will be sunset soon. Usability is good in SAP BW Modernization. Instead of going with other non-SAP tools, staying with SAP will be suitable for existing users. Across the board, many of them are moving to DataSphere.

Incentivized

The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support

Incentivized

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.

We evaluated [Amazon] Redshift vs BigQuery vs Amazon EMR, back in 2014. Back then BigQuery cost was slightly higher than that of [Amazon] Redshift price structure. Amazon EMR, needs lots more management (Admin tasks) and EMR is designed to be ephemeral and not designed to be a data store. [Amazon] Redshift was ideal with the price structure, performance and ROI[.]

Incentivized

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.

Incentivized

• It allows for an almost seamless integration of our data which can then be used by other departments for analytical purposes.
• No in house resources are needed for keeping the data alive and performing backup/migration tasks of the data in its end state.

Incentivized

• Enhanced our report generation process due to presence of holistic data.
• Centralized data from all our platforms. This has helped us visualize and analyze all data much more efficiently.
• It is more on the expensive side from both cost and training perspective.

Incentivized