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
- (Updated) Microsoft Teams: Building‑level insights on the Teams Rooms Pro Management portal recommended actions page [MC1257308]
- (Updated) Microsoft Teams: Delete meeting generated content in recap [MC1289725]
- (Updated) Transitioning Teams Android Device Management from Teams admin Center to the Teams Rooms Pro Management portal [MC1227622]
- (Updated) Microsoft 365 Copilot Apps installation on devices with Microsoft 365 Apps [MC1152323]
