MySQL is a popular open-source relational and embedded database, now owned by Oracle.
N/A
SAP Business Data Cloud
Score 8.4 out of 10
N/A
SAP Business Data Cloud is a fully managed SaaS solution that unifies and governs all SAP data and seamlessly connects with third-party data—giving line-of-business leaders context to make even more impactful decisions.
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.
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.
Support for AI/ML use cases with SAP Data bricks and without the need to physically transfer the data from datasphere environment.
Provide near realtime data for analytics from S4C public cloud via data products which was the primary business problem that our customers were concerned with
Provides support to use the best of both the worlds like SAP and Databricks
New releases that support for the zero-copy delta share via SAP Business Data Cloud connect to other products like snowflake, google big query and other products in roadmap
Moving towards the lakehouse architecture or similar architecture from the former warehouse architecture to meet the increasing demand for the data
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.
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.
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
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.
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.
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.
support team is generally responsive and knowledgeable, and most issues are addressed within acceptable timelines. Documentation and standard guidance are helpful for common scenarios.
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.
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
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.
With a S4 backend a lot of core functionality is made simpler - authorization, data types, currency conversion. In particular if the front end choice is SAP Analytics Cloud. The lack of a good connection from Power BI to the datasphere application (instead of the underlying HANA cloud) is a major drawback in that scenario.
