Zero-ETL integration with Amazon Redshift
Oracle Database@AWS supports Zero-ETL integration with Amazon Redshift. You can replicate data to Amazon Redshift from your Oracle databases running on Oracle Exadata or Autonomous Database on Dedicated Exadata Infrastructure without the traditional extract, transform, and load (ETL) process. This integration enables real-time analytics and AI workloads by automatically synchronizing your Oracle data with Amazon Redshift.
Zero-ETL integration provides the following benefits:
Real-time data replication – Continuous data synchronization from Oracle databases to Amazon Redshift with minimal latency
Elimination of complex ETL pipelines – No need to build and maintain custom data integration solutions
Reduced operational overhead – Automated setup and management through AWS APIs
Simplified data integration architecture – Seamless integration between Oracle Database@AWS and AWS analytics services
Enhanced security – Built-in encryption and AWS IAM access controls
Supported database versions
Zero-ETL integration supports the following Oracle database versions:
Oracle Exadata – Oracle Database 19c
Autonomous Database on Dedicated Infrastructure – Oracle Database 19c and 23ai
How Zero-ETL integration works
Zero-ETL integration allows Oracle Database@AWS to replicate data to Amazon Redshift. The integration leverages Amazon VPC Lattice to create secure network connectivity. Change data capture (CDC) technology ensures real-time data synchronization. You manage the integration through AWS Glue APIs.
The Zero-ETL integration architecture includes the following:
-
Secure connectivity – Uses SSL/TLS encryption over TLS port 2484 for data transfer
-
AWS Secrets Manager – Stores database credentials and certificates securely using AWS KMS
-
AWS Glue integration – Provides unified management interface for Zero-ETL integrations
Replication proceeds through the following steps:
-
Establishing secure connection to the Oracle database using SSL on port 2484
-
Performing an initial full dump of selected databases, schemas, and tables
-
Setting up change data capture (CDC) for ongoing real-time replication
-
Writing the replicated data to the target Amazon Redshift cluster
Important
Zero-ETL integration isn't enabled by default. You must configure it using AWS Glue APIs. You can't set up Zero-ETL integration directly using Oracle Database@AWS APIs.