Amazon RDS for Oracle zero-ETL integration with Amazon Redshift is now available in 8 additional AWS regions

Amazon RDS for Oracle zero-ETL integration with Amazon Redshift

Amazon RDS for Oracle zero-ETL integration with Amazon Redshift is now available in the Asia Pacific (Hyderabad), Asia Pacific (Jakarta), Asia Pacific (Melbourne), Canada West (Calgary), Europe (Spain), Europe (Zurich), Israel (Tel Aviv), and Middle East (UAE) Regions. This integration enables near real-time analytics and machine learning 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 an Amazon RDS for Oracle database instance, the data is replicated to Amazon Redshift. Zero-ETL integrations simplify the process of analyzing data from Amazon RDS for Oracle database instances, enabling you to derive holistic insights across multiple applications with ease.

What to do

• Use the AWS management console, API, CLI, and AWS CloudFormation to create and manage zero-ETL integrations between RDS for Oracle and Amazon Redshift.
• Choose specific pluggable databases (PDBs) to selectively replicate them if using Oracle multitenant architecture.
• Tailor replication to your needs by choosing specific tables.

RDS for Oracle zero-ETL integration with Redshift is available with Oracle Database version 19c. To learn more, refer to the Amazon RDS and Amazon Redshift documentation.

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.