Amazon Redshift vs. SAP Business Data Cloud

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 Business Data Cloud is suited mainly for SAP data integration. We could able to easily consolidate the data from S4 and service cloud V2 system. SAP Business Data Cloud enables realtime data replications. We could able to leverage the AI core features. As my previous data warehousing skill is from SAP BW, I am missing some basic features comparing to BW. Master data manual maintenance, Time dependant masterdata, language independent text is also not straightforward.

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 Business Data Cloud help in arranging data at one single place reducing cost of maintenance for multiple platforms and governance.
• Once data is arranged , it can be modelled as needed using Datasphere and in data bricks for AI needs
• Data fabric provided in SAP Business Data Cloud helps in reducing man efforts to design models needed for PNL reporting as data fabric helps in quickly designing the solution with great accuracy.

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

• I think SAP Business Data Cloud Partner Skills have room for improvement
• I think Change Management in SAP Business Data Cloud has room for improvement
• I think Assistance moving from BW (Business Warehouse) has room for improvement in SAP Business Data Cloud

Incentivized

The platform provides strong values in terms of centralized data management, scalability, and integration with the SAP ecosystem. It supports enterprise reporting, governance and analytics effectively. While there is always room for improvement in usability and cost transparency, the long term benefits in performance, data consistency and cross functional collaboration and expanding within the organization

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 Business Data Cloud offers robust capabilities that enable me to analyze data and extract valuable business insights. It creates a single source of truth with seamless SAP integrations that enable faster, more reliable reporting. It has freed my team from complex engineering efforts by simplifying data analytics, giving us more time to focus on generating insights.

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

support team is generally responsive and knowledgeable, and most issues are addressed within acceptable timelines. Documentation and standard guidance are helpful for common scenarios.

Incentivized

One of the best training session I attended and they covered most of the topics and answered all our questions. participants joined from different regions, infact they all had a different questions and it was different thoughts from all of then and helped to learn better. Though I was on travel, I could able yo attend the session.

Incentivized

I have done implementation of models in traditional bw and Using BDC. The integration of BDC with S4 hana for creating sap data products is seamless and reduces lot of implementation effort. The intelligent app feature is BDC also eases the implementation effort. If i have to compare the previous world with new BDC, implementation effort is largely saved

Incentivized

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

The reason is pretty straight forward. Majority of our data originates from SAP source systems like SAP S4 private cloud, S4C public cloud and Bydesign. So SAP Business Data Cloud stands tall when compared to other solutions and i honestly believe this is best suited solution for the warehousing and reporting to our organization.

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

• Since SAP Business Data Cloud consolidates multiple tools into single platform - it reduces licensing, maintenance and infrastructure costs
• Its helps Business in taking decisions fast with real-time reporting capabilities
• SAP Business Data Cloud provides improved data quality and governance, which avoids reworks

Incentivized