AWS Further Eases Database Migration Away From Oracle

Executive Summary

  • How AWS’s new heterogeneous migration targets Oracle.
  • Understanding how AWS’s Managed Services reduces a company’s reliance on Oracle support.

Introduction

Oracle has based its database business around lock-in. As I have covered in previous articles, there is an immense opportunity to reduce costs by migrating away from Oracle databases to databases like PostgreSQL or MariaDB or others. However, something that is required is a managed DB. There is no point in migrating away from Oracle DBAs if something else cannot take its place.

Well, something did.

AWS’s Managed Services

AWS came up with the managed DB through its managed services, which manages overall infrastructure, databases being one component of this. This AWS has had for a while. However, migration has been performed by consulting firms with expertise in AWS. But recently AWS has “greased the skids” for companies with the desire to migrate databases to AWS, and also to migrate away from the database to different databases. Let us see the following quotation from the AWS website.

“The service supports homogenous migrations such as Oracle to Oracle, and also heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. You can also use AWS DMS to stream data to Amazon Redshift, Amazon DynamoDB, and Amazon S3 from any of the supported sources, including Aurora, PostgreSQL, MySQL, MariaDB, Oracle, SAP ASE, SQL Server, and MongoDB. In addition, you can use AWS DMS for continuous data replication with high availability.” – AWS Website

“Options” But a Target on Oracle’s Back

AWS presents this as a bunch of “options” but there is one database vendor that is burning a hole in company’s pockets with its expense and overhead and this database is Oracle.

In this quotation, it explains the details of how this is accomplished.

“With this launch, AWS DMS enables customers to use the same mechanic that the database uses for commit sequencing, which is the log sequence number (LSN). The launch also opens more integration use cases. For example, now you can use Oracle Data Pump or SQL Server BCP to do the initial data load into a target database and then use the DMS log sequence numbers to start change data capture (CDC). With the checkpoint feature.. you can replicate changes once a day from the last checkpoint.” – AWS Website

This conversion setup can be seen in the following screenshot from AWS.

Notice the options under the migration type. 

Conclusion

Companies can avail themselves of this new capability to migrate away from Oracle. Of course, many companies have customizations in Oracle, stored procedure, etc, that reduce the ability to migrate. However, for those databases that can, (other databases can be migrated by moving the stored procedures out of the database and into the application layer) it enables one to migrate to an open source database, which in the vast majority of cases can handle the workload just fine, and with AWS’s Managed Services, it means that Oracle support can be dropped. This can be a boon to companies. It takes what amounts to what is widely considered to be close to no value, and puts back in the company’s pocket to spend on things that do add value.

Brightwork Disclosure

Financial Bias Disclosure

This article and no other article on the Brightwork website is paid for by a software vendor, including Oracle and SAP. Brightwork does offer competitive intelligence work to vendors as part of its business, but no published research or articles are written with any financial consideration. As part of Brightwork’s commitment to publishing independent, unbiased research, the company’s business model is driven by consulting services; no paid media placements are accepted.

AWS / GCS Question Box

  • Have Questions About Using AWS for SAP & Oracle?

    Our unbiased experts can provide you with honest answers and advice about how you can use Amazon Web Services with SAP and Oracle.

    This article is free, we do not answer questions for free. Filling out this form is for those that have a budget. If that describes you, just fill out the form below and we'll be in touch asap.

References

https://aws.amazon.com/blogs/database/aws-dms-now-supports-native-cdc-support/https://aws.amazon.com/managed-services/faqs/

The Risk Estimation Book

 

Software RiskRethinking Enterprise Software Risk: Controlling the Main Risk Factors on IT Projects

Better Managing Software Risk

The software implementation is risky business and success is not a certainty. But you can reduce risk with the strategies in this book. Undertaking software selection and implementation without approximating the project’s risk is a poor way to make decisions about either projects or software. But that’s the way many companies do business, even though 50 percent of IT implementations are deemed failures.

Finding What Works and What Doesn’t

In this book, you will review the strategies commonly used by most companies for mitigating software project risk–and learn why these plans don’t work–and then acquire practical and realistic strategies that will help you to maximize success on your software implementation.

Chapters

Chapter 1: Introduction
Chapter 2: Enterprise Software Risk Management
Chapter 3: The Basics of Enterprise Software Risk Management
Chapter 4: Understanding the Enterprise Software Market
Chapter 5: Software Sell-ability versus Implementability
Chapter 6: Selecting the Right IT Consultant
Chapter 7: How to Use the Reports of Analysts Like Gartner
Chapter 8: How to Interpret Vendor-Provided Information to Reduce Project Risk
Chapter 9: Evaluating Implementation Preparedness
Chapter 10: Using TCO for Decision Making
Chapter 11: The Software Decisions’ Risk Component Model

How Accurate Was ASUG About Migrating to HANA?

Executive Summary

  • ASUG wrote a number of inaccurate statements about HANA and has provided really broken logic regarding SAP being a customer’s long-term partner, stating that other customers should move away from other vendors.
  • One thing that ASUG will not address is the TCO of HANA.

Introduction

As we have proposed for some time, there is no longer any difference between SAP and the marketing outlet that goes by the name of ASUG which poses as a user group for SAP.

In the article About Those Oracle Runtime Licenses That You Own, Geoff Scott proposes that it is time to migrate to HANA from Oracle.

“If you run your SAP software on Oracle databases, and you purchased your Oracle licenses through SAP (referred to as “runtime” licenses), your cost is now 7 percent higher than it was just two years ago.”

Creating that Burning Platform

So this is one part of the “burning platform” that ASUG attempts to create. And then comes the second part.

“Another important thing to note is that the SAP-Oracle database licensing agreement is again up for renewal in 2017.

What happens next can be anything from additional price increases to an end to the agreement, to something in between. In other words, uncertainty—which is a hard thing to plan for.”

So ASUG proposes here that the SAP-Oracle licensing agreement could be terminated? Did ASUG think this was within the realm of possibility when they wrote this or was this just FUD? If that did happen, what a massive change of the rules that would have been.

This article was written in 2016. However, when the agreement was reviewed, it was extended, which we covered in the article. How SAP Has Quietly Changed Strategy on HANA and Oracle.

He then finishes with:

“It’s hard not to conclude that if SAP is your long-term enterprise software partner, you need to make a move to SAP HANA, Suite on HANA or SAP S/4HANA. All of the other options are intermediate stop-gaps, which require time and money. Better to do this once and right than have to do it multiple times.”

Thus, the answer is to remove all other databases and replace them all with HANA!

Are Vendors Also Partners?

Did it occur to ASUG that these other vendors are also “partners” with these customers in the same way that SAP is a “partner”? In fact, the term partner is just misleading. SAP as with Oracle expects to get paid by their customers. Therefore, these are customers and SAP, and Oracle is vendors. This reframing of customer/vendor relationships as partnering is a highly inaccurate way to describe entities that pay and that are paid. Partners frequently team up to service another customer together. Partners often don’t transfer funds for goods and services.

The words in the English language have already been created to explain these relationships. Furthermore, many customers have had SAP as a vendor and have also had Oracle, IBM or Microsoft as vendors. Why is this logic to move more business over to one vendor versus the other?

What is the TCO of HANA?

Something that ASUG may be interested in knowing is that they think a 7% increase over two years is high, they should read the Brightwork HANA TCO Study which estimates that HANA is more than 2x the TCO of “AnyDB.”

Conclusion

Once again, is ASUG the user group that it claims and just looking out for their member’s interests, or are they a marketing channel for SAP. Was this advice offered by them looking out for the interests of their members, or only what SAP wanted their customers to do? We know that this article lays out precisely what SAP would like customers to do. There is just no way that following this advice would result in anything but higher costs and a worse value for the customers that followed this path.

ASUG receives a 1 out of 10 for accuracy on this article.

*This article was written without any consideration from any vendor of any kind. Unlike ASUG, we are independent of any entity that we provide information.

Brightwork Disclosure

Financial Bias Disclosure

This article and no other article on the Brightwork website is paid for by a software vendor, including Oracle and SAP. Brightwork does offer competitive intelligence work to vendors as part of its business, but no published research or articles are written with any financial consideration. As part of Brightwork’s commitment to publishing independent, unbiased research, the company’s business model is driven by consulting services; no paid media placements are accepted.

HANA & S/4HANA Question Box

  • Have Questions About S/4HANA & HANA?

    It is difficult for most companies to make improvements in S/4HANA and HANA without outside advice. And it is close to impossible to get honest S/4HANA and HANA advice from large consulting companies. We offer remote unbiased multi-dimension S/4HANA and HANA support.

    This article is free, we do not answer questions for free. Filling out this form is for those that have a budget. If that describes you, just fill out the form below and we'll be in touch asap.

References

https://www.asug.com/news/about-those-oracle-runtime-licenses-that-you-own