Amazon RDS for Oracle zero-ETL integration with Amazon Redshift enables near real-time analytics and machine learning (ML) to analyze petabytes of transactional data in Amazon Redshift without complex data pipelines for extract-transform-load (ETL) operations. Within seconds of data being written to Amazon RDS for Oracle, the data is replicated to Amazon Redshift. With Zero-ETL integrations, analyzing data from Amazon RDS for Oracle is simple, helping you derive holistic insights across many applications.
With this launch, you can use the AWS management console, API, CLI, and AWS CloudFormation to create and manage zero-ETL integrations between RDS for Oracle and Amazon Redshift. You can choose specific pluggable databases (PDBs) to selectively replicate them. In addition, you can choose specific tables and tailor replication to your needs.
RDS for Oracle zero-ETL integration with Redshift is available with Oracle Database versions 19c in supported AWS Regions. To learn more, referAmazon RDS and Amazon Redshift documentation.
Categories:
Source: Amazon Web Services