By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Heterogeneous database links on AWS RDS

0

Does AWS RDS support heterogeneous database links?

Examples:

  1. Oracle running on RDS with a database link to Postgres
  2. Postgres running on RDS using the oracle_fwd extension Not possible with RDS
Topics
DatabaseMigration & ModernizationAnalytics
Tags
PostgreSQLAmazon Relational Database ServiceOracle
Language
English
AWS-User-5372629
asked 3 years ago897 views
2 Answers
1
Accepted Answer

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.

AWS-User-2735259
answered 3 years ago
0

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

AWS
AWS-ADolganov
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content