Converting Wire Protocol from Oracle to Postgres and Vice-Versa
0
votes
0
answers
117
views
Naive Question
Assume we have an Application which was originally written for ORACLE as DBMS. If I want write an intermediary layer that gives this application independence to be able to work with PostgreSQL DBMS - I presume that I would be required to perform the following :
SQL : Application--> ODBC API (Oracle Wire Protocol) --> My Layer ---> ODBC API (PostgreSQL Wire Protocol)
Response : Application-->ODBC API (Oracle Wire Protocol) ODBC API (PostgreSQL Wire Protocol) ----> PostgreSQL DBMS
Response : Application-->ODBC API (PostgreSQL Wire Protocol) <---- PostgreSQL DBMS
Asked by ultimate cause
(101 rep)
Nov 6, 2022, 12:39 PM