Thread: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
To whom it will concern,
We are trying to access Oracle/MSSQL database from PostgreSQL, PostgreSQL ODBC Driver comes across.
Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL?
If the answer is yes, how? Could you share documents on how to access?
Thanks,
Ruiwen Wan
Principal Member of Tech Staff
Network Cloud & Infrastructure
AT&T Services, Inc
200 S LAUREL AVE BLDG A, E3-3D22, MIDDLETOWN, NJ 07748
o 732.420.0469 | m 732.299.6618 | ruiwen.xu@att.com
WAN, RUIWEN wrote: > Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL? The psqlODBC driver allows ODBC clients to access Postgres servers. To allow a Postgres server to access other servers, you need a Foreign Data Wrapper: <https://wiki.postgresql.org/wiki/Foreign_data_wrappers> Regards, Clemens
Database ODBC drivers is used the other way around. PostgreSQL ODBC driver is for accessing a PostgreSQL database from other applications.
I think foreign data wrappers is what you want. I have planned to do the same as you, but have not implemented or tested anything yet.
https://wiki.postgresql.org/wiki/Foreign_data_wrappers
Best regards,
Rolf Østvik
From: WAN, RUIWEN <rx152u@att.com>
Sent: mandag 31. august 2020 23:50
To: pgsql-odbc@postgresql.org
Subject: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
To whom it will concern,
We are trying to access Oracle/MSSQL database from PostgreSQL, PostgreSQL ODBC Driver comes across.
Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL?
If the answer is yes, how? Could you share documents on how to access?
Thanks,
Ruiwen Wan
Principal Member of Tech Staff
Network Cloud & Infrastructure
AT&T Services, Inc
200 S LAUREL AVE BLDG A, E3-3D22, MIDDLETOWN, NJ 07748
o 732.420.0469 | m 732.299.6618 | ruiwen.xu@att.com