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
Latest Posts
- AWS Lambda MicroVMs is now available in 5 additional AWS regions
- AWS IAM now supports 20 managed policies per role by default
- Web Search in Amazon Bedrock AgentCore adds domain and published date filtering, expands to Europe and Asia Pacific
- MC1323266: Microsoft 365 Copilot Gets Power BI Data Grounding for Answering User Questions
