Обсуждение: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

Поиск
Список
Период
Сортировка

PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

От
"WAN, RUIWEN"
Дата:

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

 

Re: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

От
Clemens Ladisch
Дата:
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

RE: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

От
Rolf Østvik
Дата:

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