Introduction

Oracle has produced a cloud service called Oracle Autonomous Database.  The Oracle Autonomous Database is a suite of self-driving, self-securing, and self-repairing services that leverage machine learning and automation.  The purpose behind the Oracle Autonomous Database is to eliminate human labor, human error, and manual tuning, leading to a reduced cost and complexity, ensuring higher reliability, security, and operational efficiency.

The Oracle Autonomous Database comes in two same but distinct products, the Autonomous Data Warehouse and Autonomous Transaction Processing. Both of which are optimized to meet the specialized needs of each.  The Autonomous Data Warehouse delivers reliability, performance, and highly elastic data management.  Autonomous Transaction Processing allows for more straightforward application development and deployment of real-time analytics, fraud detection, and personalization.  Both offerings within the Oracle Autonomous Database service are excellent and provide flexibility as well as lowering administration time, which allows organizations to be more agile and innovative.

With the ability to spin up an Oracle Autonomous Database comes the need for populating it with data.  The Oracle Autonomous Database services provide a few methods for moving data into the services; however, there is only one method that allows for real-time processing of data into an Oracle Autonomous Database.  This whitepaper will discuss and show the required steps to move data in real-time using Oracle GoldenGate Microservices.

Software

Oracle Autonomous Database Services

The capabilities of the Oracle Database enable the Oracle Autonomous Database to be a provision in two editions that are tailored explicitly to workloads for data warehouses (Autonomous Data Warehouse) or online transactional processing (Autonomous Transaction Processing).