Skip links

Moving Data From Oracle To ADW

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).

Autonomous Data Warehouse

The Autonomous Data Warehouse (ADW) provides a platform for running Data Warehouses, Data Marts, Machine Learning, or Data Lake deployments at scale.  Data Warehouses are the foundational structures…

Submit Your Info to Continue Reading

Table of Contents

Introduction

Software

Oracle Autonomous Database Services

Autonomous Data Warehouse

Autonomous Transaction Processing

Oracle GoldenGate 19c Microservices

Nginx

Oracle GoldenGate Deployment Model

Build

On-Premises Database

Oracle Autonomous Data Warehouse

Oracle GoldenGate 19c Microservices Hub

Clean Up

Summary