Dblink from oracle to PostgreSQL

[satish]

Dear erman,

Any idea whether we need any licensing to create dblink from oracle 12c to PostgreSQL.

Thank you,
SG

[ErmanArslansOracleBlog]

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.

[satish]

That’s lot of information,thank you very much

[satish]

Dear erman,

We are on 12.1.0.2 database version and red hat Linux 7 os.

You said no extra licence for DG4ODBC, but do we need to install this gateway on Linux 64 bit platform?

Thanks,
SG

[ErmanArslansOracleBlog]

DG4ODBC is included in your Oracle Database Server license without extra cost.
I see that you are still confused.. Please see the following blog post and understand logic ;

https://ermanarslan.blogspot.com/2016/01/rdbms-oracle-to-sqlserver-dblink.html

This is for Oracle to SQLServer but the logic is the same. You just implement it for postgresql using the appropriate way and using the psqlODBC.