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. 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 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.
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. If you use Oracle multitenant architecture, 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 version 19c. To learn more, refer Amazon RDS and Amazon Redshift documentation.
Categories: marketing:marchitecture/databases,general:products/amazon-rds-for-oracle
Source: Amazon Web Services
Latest Posts
- Power Platform admin center – Inventory now includes connector details for apps, flows, and agents [MC1331864]
- Dynamics 365 Customer Service – Improve customer outcomes with Service Agent in Microsoft 365 Copilot [MC1331688]
- Microsoft Dataverse – Enable semantic Dataverse data understanding for agentic use [MC1331636]
- Notice – Availability of Microsoft (no Teams) Suites in the EEA [MC1330882]
