1 Reply Latest reply on Jul 3, 2013 4:45 AM by Kgronau-Oracle

    how to create a database link to connect to Progress


      I using 10g ( and want to connect to progress 9.x using a databaselink.


      Which are the steps, examples to acomplish this?.

        • 1. Re: how to create a database link to connect to Progress

          You have to use the 11g Database Gateway for ODBC (DG4ODBC) to connect from Oracle to Postgres.There's a note on My Oracle Support how to configure the gateway - please have a look at:

          How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)


          I would recommend you to use the latest gateway release ( which can be downloaded from My Oracle Support portal as well. Just click on Patches and Updates and look for the patch set:


          Although it is a patch set this software can also be used to install the gateway from scratch.

          Check out the readme as it lists which ZIP file contains the gateway software you have to download.



          The DG4ODBC gateway is for free and its license is included in the Oracle database license. You only need to make sure you have a suitable ODBC driver which is able to connect to your Postgres database.


          Best regards,