HS_FDS_CONNECT_INFO – This should reference the data source name configured in the odbc.ini file. ora file and set the following parameters: Note that you need to use sudo su to switch to the user that owns the Oracle Home (the default Oracle Home owner on Amazon RDS Custom for Oracle is rdsdb).Įdit the init. ora and use the name of the data source that you configured in the odbc.ini file.įor this example, we name the file initpgdb.ora. For more information, refer to Database Heterogeneous Connectivity User’s Guide.Ĭreate a file named init. 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. Install ODBCįor the ODBC configuration, you need to install the following in the RDS Custom for Oracle host:ĭownload and install the PostgreSQL repositories with the following command: 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). Install ODBC on the RDS Custom for Oracle instance.Ĭonfigure an ODBC Gateway according to the PostgreSQL instance you want to connect. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |