Home icon

Heterogeneous data sources: Access your data in PostgreSQL from Amazon RDS for Oracle using Oracle Database Gateway

Database Blog

This article discusses how to set up a secure connection between an Amazon RDS for Oracle database and an Amazon RDS for PostgreSQL database using an Oracle Database Gateway. It provides a step-by-step guide for installing and configuring the necessary components on an Amazon EC2 instance to enable Oracle to query PostgreSQL data.

Specifically, the article covers:

  • Prerequisites for setting up the solution, including creating RDS instances and an EC2 instance
  • Downloading and installing the Oracle Database Gateway software on the EC2 instance
  • Installing ODBC drivers, PostgreSQL client, and libraries on the EC2 instance
  • Configuring Oracle Net for the database gateway
  • Creating a database link in RDS for Oracle to connect to PostgreSQL via the gateway
  • Testing the connection and querying PostgreSQL data from Oracle
  • Troubleshooting common errors during setup
  • Cleaning up resources after testing
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Sep 11
2024
Migrate an Oracle database to Amazon RDS for Oracle using Oracle GoldenGate Microservices Architecture
Jan 27
2025
Oracle Application Express for Amazon RDS for Oracle demystified
Mar 31
2026
Announcing Amazon RDS for Oracle on AWS Outposts
Oct 28
2025
Migrate Oracle reference partitioned tables to Amazon RDS or Aurora PostgreSQL with AWS DMS

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.