Re: Dblink from oracle to PostgreSQL

Posted by ErmanArslansOracleBlog on Apr 26, 2021; 10:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Dblink-from-oracle-to-PostgreSQL-tp9674p9675.html

You can do that by using Oracle Database gateway, using Oracle Database Gateway for ODBC..

Following is the information from Oracle Support:

The Oracle Database Gateway for ODBC (DG4ODBC) is included in your Oracle Database Server license without extra cost.
While the Database Gateway for ODBC (DG4ODBC) does not require an additional license from Oracle, a third party ODBC driver is required, which may require a purchase independent of Oracle.

---
That third party ODBC driver mentioned above is "PostgreSQL ODBC driver (psqlODBC)" in this case.
According to the what I see in postgres web site , the licensing info about the driver is as follows;

psqlODBC is the official PostgreSQL ODBC Driver. It is released under the Library General Public Licence, or LGPL.