Heterogeneous database links on AWS RDS
Does AWS RDS support heterogeneous database links?
Examples:
- Oracle running on RDS with a database link to Postgres
Postgres running on RDS using the oracle_fwd extensionNot possible with RDS
Database links in RDS Oracle are possible for homogeneous scenarios only. For heterogeneous scenarios you would need access in instance level in order to install drivers and configure Oracle Heterogeneous Services to do this, which is not possible in RDS.
I have already configured HS (to mySQL) in a Oracle running in EC2, if it is really necessary. I don't recommend because it's hard to handle sessions, I would go deeper in the case and tech requirements, looking for alternatives.
To refresh the answer: since end of October 2021, AWS offers an additional deployment option, "RDS Custom for Oracle" https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-rds-custom-oracle/ , with this deployment option the user has access to the underlying host.
Regards
Relevant questions
RDS Database Instance does not show up in dropdown when creating RDS Proxy
asked 3 months agoAnnouncement: Amazon RDS for Oracle - End of Support Timeline for 12c Oracle Release 2 (12.2.0.1) and Oracle Release 1 (12.1.0.2) Major Version
asked 2 months agoDeployed One laravel app on AWS Elastic Beanstalk & EKS Same Database RDS W
Accepted Answerasked 3 years agoReplication between RDS and on premises Oracle
Accepted Answerasked 2 years agoAccessing a RDS database in another account using AWS PrivateLink
Accepted Answerasked 4 years agoError establishing a database connection with RDS and OpenLiteSpeed AIMs
asked 4 months agoHeterogeneous database links on AWS RDS
Accepted Answerasked a year agoAWS Database Migration Service
Accepted Answerasked 6 years agoRDS Oracle EE options
Accepted Answerasked 3 years agoCreate DBLINK Between Oracle on-prem and Oracle RDS
Accepted Answerasked 7 years ago