![]() This folder inside ORACLE_HOME stores information related to the Oracle heterogeneous service, which you can use to operate Oracle with heterogeneous engines. On the RDS Custom for Oracle database, go to the $ORACLE_HOME/hs/admin folder.Create and configure the database linkįirst, we configure the Oracle Database service handler, which provides the information of how to connect to the ODBC driver to our database link. Make sure your file has the correct path to the PostgreSQL installation.The following template is an example of the /etc/odbcinst.inifile:Īfter the connection is set up, it’s time to set up our database link. Modify the parameter values according to where the PostgreSQL drivers were installed.Modify the name between the brackets if you wish and make note of it.This name is used on the configuration of the next file to reference it.On the RDS Custom for Oracle instance, edit the /etc/odbcinst.ini file./etc/odbc.ini – Contains the information that will be used by our database link./etc/odbcinst.ini – Holds information about the ODBC installation and should be configured according to where ODBC and the PostgreSQL ODBC driver were installed on your instance.Next, we configure the files necessary for the ODBC Gateway configuration: Make sure to install the correct version based on your database and operating system. Sudo yum install postgresql12-odbc.x86_64įor this post, we installed ODBC for PostgreSQL version 12 and its drivers. Download and install the PostgreSQL repositories with the following command:.Install ODBCįor the ODBC configuration, you need to install the following in the RDS Custom for Oracle host: Make sure that there is network connectivity between the two instances. For this post, we use an Amazon RDS for PostgreSQL version 12 instance. The pause ensures that the modifications don’t interfere with RDS Custom automation.įor more information, refer to Setting up your environment for Amazon RDS Custom for Oracle.Ī PostgreSQL instance is also necessary. Set up a database link inside the Oracle database on Amazon RDS Custom for Oracle to connect to the PostgreSQL database with the configured ODBC settings.Īs a prerequisite for this solution, you need to have an RDS Custom for Oracle instance running and then pause its automation, so you can install the required tools and configurations.Test the connection between the instances using isql (which comes preinstalled on the RDS Custom for Oracle instance).Configure an ODBC Gateway according to the PostgreSQL instance you want to connect.Install ODBC on the RDS Custom for Oracle instance. ![]() The high-level steps for implementing this solution are as follows: PostgreSQL has the ability to connect to Oracle via a foreign data wrapper (FDW) however, connecting from Oracle to PostgreSQL requires the use of an ODBC Gateway, which doesn’t require any specific license. In this post, we discuss how create a connection between an RDS Custom for Oracle instance and PostgreSQL. While working with customers, we have observed use cases that require a connection to be kept with a different database engine. Amazon Relational Database Service (Amazon RDS) Custom for Oracle allows you to run Oracle databases on AWS, giving you some of the benefits of Amazon RDS automation and the freedom of changing configurations to match different use cases.
0 Comments
Leave a Reply. |