MySQL vs. SAP Business Data Cloud

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

Incentivized

1. Data extraction from Non-SAP environment 2.Seamless integration with SAP Analytics Cloud for reporting purposes, avoiding the need to create complex reporting dashboards 3. Dataproducts across different modules are available for use in the SAP environment 4 . Snowflakes and Databricks offer more flexibility to address complex use cases, including even application of AI.

Incentivized

• Stable - it just runs, with minimal downtime or errors
• Fast - well-structured data is quickly written and read
• Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
• Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL

Incentivized

• Extraction of Data from various non-SAP data sources.
• Leverage Databricks for easy AI application to the identified use-cases.
• SAP analytics cloud for reporting purposes.

Incentivized

• Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
• Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

Incentivized

• Data products that combine data across process areas
• Better capabilities for transforming data in the object store
• Support for large scale customers

Incentivized

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Incentivized

In the new analytics world, BDC has been a game changer for SAP Analytics. Extending the SAP data for the usage in Databricks, snow flake, GCP has opened new doors for Analytics . Shift from traditional data warehousing to Business Data fabric adapting to the change in the analytics world is the need of the hour and Sap has managed to pulled it off with BDC

Incentivized

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

It has business friendly options, governance features and as expected, integration with SAP products. However it feels complex for somebody who is non SAP background and for building lighter reports. There is lot of scope for improvement as compared to in general options available in the market. Otherwise it is best for business cases

Incentivized

We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.

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

1. Estimate your data size. 2. Test, test, and test.

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

MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.

Incentivized

BDC is a significant development over Datasphere in the sense that it unifies not only the transaction and olap systems but also other olap systems which may have existed in the landscape. Pce migration and availability of data from and 7.5 or B4 HANA system as a data product is also an exemplary feature.

Incentivized

• As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
• The acquisition by Oracle makes you need to contract support for the enterprise version
• If you have knowledge about oracle databases, you can get more out of the enterprise version

Incentivized

• State-of-the-art and faster Data extraction, mapping, and transformation both from SAP and non-SAP data sources.
• Supports ECC to SAP S/4 HANA data transformation use cases.
• AI-enabled use cases leveraging Databricks further reduce the ETL process in Data transformation.
• Faster Go-To-Market as reporting and dashboarding don't require much custom development. Instead, SAP Analytics Cloud helps here.

Incentivized