![]() ![]() For installation and configuration, please refer to PostgreSQL Quick Installation Guide.ġ. At this point, the PostgreSQL v12 database should be up and running.If you have not installed these yet, please refer to the documentation below. Installation of Oracle and PostgreSQL servers is not covered here. The same steps can be used with the latest versions of the database/drivers. Software versions are not specific to this setup, however. The following server and software versions were used in the configuration. Note: This blog uses PostgreSQL ODBC connector in the configuration, but some steps can be used for other ODBC drivers (including EDB ODBC and others). Let’s configure the above setup and try to retrieve data from PostgreSQL via psqlODBC. Finally, the Oracle Database passes the query results to the client application.Gateway retrieves the data from PostgreSQL using the translated SQL Statement and returns the data to the Oracle Database.Oracle HS Agent translates the SQL dialect to an SQL Statement that the non-Oracle database (PostgreSQL) understands and sends it via ODBC DSN.Client sends a query to the Oracle database via the Oracle Database Link created using Heterogeneous ODBC Data source.In this post, we will configure an Oracle Database Gateway for ODBC (Heterogeneous Gateway) and make a connection to PostgreSQL v12 using PostgreSQL ODBC Connector.įrom the diagram above, we can understand the Oracle gateway process flow: Oracle Database Gateway for ODBC makes it possible to integrate with other databases such as MySQL, PostgreSQL, and even non-relational targets like Excel. This generic solution addresses the need for accessing data in other database systems for which Oracle does not have a tailored solution. As part of a generic technology solution to connect to a non-Oracle system, it offers Database Gateway for ODBC. Oracle has tailored gateways to many systems, and they are specifically coded for the target non-Oracle systems. Oracle Database Gateways have the ability to transparently access non-Oracle system data from within the Oracle environment. SUMMARY: This article demonstrates how to use the PostgreSQL client interface psqlODBC driver in Oracle to access PostgreSQL data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |