Amazon Relational Database Service (RDS) vs. SAP Datasphere vs. Microsoft SQL Server

If your application needs a relational data store and uses other AWS services, AWS RDS is a no-brainer. It offers all the traditional database features, makes it a snap to set up, creates cross-region replication, has advanced security, built-in monitoring, and much more at a very good price. You can also set up streaming to a data lake using various other AWS services on your RDS.

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

Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.

Incentivized

• Automated Database Management: We use it for streamlining routine tasks like software patching and database backups.
• Scalability on Demand: we use it to handle traffic spikes, scaling both vertically and horizontally.
• Database Engine Compatibility: It works amazingly with multiple database engines used by different departments within our organization including MySQL, PostgreSQL, SQL Server, and Oracle.
• Monitoring: It covers our extensive monitoring and logging, and also has great compatibility with Amazon CloudWatch

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

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Incentivized

• It is a little difficult to configure and connect to an RDS instance. The integration with ECS can be made more seamless.
• Exploring features within RDS is not very easy and intuitive. Either a human friendly documentation should be added or the User Interface be made intuitive so that people can explore and find features on their own.
• There should be tools to analyze cost and minimize it according to the usage.

Incentivized

• Need to have a good understanding of the SAP ecosystem to implement and use it.
• From a cost perspective it can be little bit on the expensive side for enterprises.
• The platform is still new and hence more subjected to bugs. But support for it is always good from the SAP team.

Incentivized

• Microsoft SQL Server Enterprise edition has a high cost but is the only edition which supports SQL Always On Availability Groups. It would be nice to include this feature in the Standard version.
• Licensing of Microsoft SQL Server is a quite complex matter, it would be good to simplify licensing in the future. For example, per core vs per user CAL licensing, as well as complex licensing scenarios in the Cloud and on Edge locations.
• It would be good to include native tools for converting Oracle, DB2, Postgresql and MySQL/MariaDB databases (schema and data) for import into Microsoft SQL Server.

Incentivized

We do renew our use of Amazon Relational Database Service. We don't have any problems faced with RDS in place. RDS has taken away lot of overhead of hosting database, managing the database and keeping a team just to manage database. Even the backup, security and recovery another overhead that has been taken away by RDS. So, we will keep on using RDS.

Incentivized

We are moving into using SAP datasphere heavily and replacing all of the SAP HANA native calc view logic to the sap datasphere graphical view which will reduce the legacy SAP BW data warehouse. Also need some more features such as debugging, sql preview and prompts enhancements so that we can generate the reports.

Incentivized

We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.

Incentivized

I've been using AWS Relational Database Services in several projects in different environments and from the AWS products, maybe this one together to EC2 are my favourite. They deliver what they promise. Reliable, fast, easy and with a fair price (in comparison to commercial products which have obscure license agreements).

Incentivized

It is one of the best tools and a boon to Logistics teams across the globe. One tends to actually process warehousing data so smoothly and the way demonstration is made while in programs it makes it user friendly. The Inventory touch points that one identify is simply awesome and is best part.

Incentivized

SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.

Incentivized

Its does not have outages.

Incentivized

SSAS data cubes may some time slow down your Excel reports.

Incentivized

I have only had good experiences in working with AWS support. I will admit that my experience comes from the benefit of having a premium tier of support but even working with free-tier accounts I have not had problems getting help with AWS products when needed. And most often, the docs do a pretty good job of explaining how to operate a service so a quick spin through the docs has been useful in solving problems.

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 managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.

Incentivized

It was good

Incentivized

the online training & digital content available on the web from AWS was having sufficient information to deploy and run the service

Incentivized

very hands on and detailed training

Incentivized

Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.

Incentivized

Amazon Relational Database Service (RDS) stands out among similar products due to its seamless integration with other AWS services, automated backups, and multi-AZ deployments for high availability. Its support for various database engines, such as MySQL, PostgreSQL, and Oracle, provides flexibility. Additionally, RDS offers managed security features, including encryption and IAM integration, enhancing data protection. The pay-as-you-go pricing model makes it cost-effective. Overall, Amazon RDS excels in ease of use, scalability, and a comprehensive feature set, making it a top choice for organizations seeking a reliable and scalable managed relational database service in the cloud.

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

[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.

Incentivized

Despite the pricing model being expensive for small businesses, it provides decent features and capabilities for organizations of different sizes and it's an appropriate investment in today's business environment where there is constant pressure to build a scalable and flexible analytics service

Incentivized

SQL server does handle growing demands of a mid sized company.

Incentivized

Ever since we implemented SAP Data Warehouse Cloud, we have been able to reduce the additional costs of hiring third-party service providers by incorporating professional services offered by the vendor.

Incentivized

• The overall cost increases, but we spect this and we can mitigate other risks.
• Is easy to work from the cloud. Is reliable, but we keep our local solution as well where RDS works quite good.
• RDS allow us to focurs on owr objetives instead of the other matters regarding databases.

Incentivized

• Preserving data quality has enhanced governance on data by having a single source that is accessible to every business user via self-service capabilities.
• Operational cost is lowered by connecting data in one integrated solution hence making it easy to access information without having to keeping logging to other applications. Additionally, no external IT support is needed since SAP Data Warehouse Cloud has no-coding modeling tools.
• SAP Data Warehouse Cloud has enabled every business user to understand different data by transforming data to real insights.

Incentivized

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Incentivized