We performed a comparison between MySQL and SAP Adaptive Server Enterprise based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The replication feature is the most valuable. We are replicating our servers."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"A lot of the software components have been trialed and tested for often more than 10 years."
"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"It's user-friendly, especially in the logistics field."
"They provide easy integration with other systems."
"The actual interface is good."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"SAP Adaptive Server Enterprise is a good transactional database."
"Provides very good integration."
"This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"From a user perspective, the initial setup could be simplified a bit."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"MySQL could introduce more indexing strategies."
"I would like to have features that allow us to jump between the cloud and our on-premises system."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"The GUI could improve in MySQL."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"User interface could be more user friendly."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"Cost-wise, SAP is still expensive compared to other available products."
"There could be some improvements in barcode scanning and RFID access."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 10 reviews. MySQL is rated 8.2, while SAP Adaptive Server Enterprise is rated 8.6. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of SAP Adaptive Server Enterprise writes " Loaded with a lot of features but the price is a drawback ". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SQL Server, whereas SAP Adaptive Server Enterprise is most compared with SAP HANA, SQL Server, SAP SQL Anywhere, Oracle Database and IBM Db2 Database. See our MySQL vs. SAP Adaptive Server Enterprise report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.