DBlink, postgres to DB2

[Postgres India]

Hi,
I am trying to connect DB2 from postgres using dblink, is there any
configuration required at DB2 and postgres server.

If any command string please provide it.



Thanks
Manmohan. K

[Rémi Cura]

Hey
http://www.postgresql.org/docs/9.3/static/contrib-dblink-connect.html
Seems dblink is for postgres to postgres connections.
Cheers,
Rémi-C

Post by Postgres India
Hi,
I am trying to connect DB2 from postgres using dblink, is there any
configuration required at DB2 and postgres server.
If any command string please provide it.
Thanks
Manmohan. K

[Rémi Cura]

You may want to use foreign data wrapper (fdw)

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

Cheers,
Rémi-C

Post by Rémi Cura
Hey
http://www.postgresql.org/docs/9.3/static/contrib-dblink-connect.html
Seems dblink is for postgres to postgres connections.
Cheers,
Rémi-C

Post by Postgres India
Hi,
I am trying to connect DB2 from postgres using dblink, is there any
configuration required at DB2 and postgres server.
If any command string please provide it.
Thanks
Manmohan. K

[Pavel Stehule]

Hi

try to use a Perl implementation https://github.com/davidfetter/DBI-Link

There is a DBD driver for DB2 http://search.cpan.org/dist/DBD-DB2/DB2.pod

Or you can use a mentioned fdw wrapper - there is ODBC wrapper
https://wiki.postgresql.org/wiki/Foreign_data_wrappers#odbc_fdw and you can
access DB2 via generic ODBC DB2 driver

Regards

Pavel

Post by Postgres India
Hi,
I am trying to connect DB2 from postgres using dblink, is there any
configuration required at DB2 and postgres server.
If any command string please provide it.
Thanks
Manmohan. K

[Merlin Moncure]

Post by Pavel Stehule
Hi
try to use a Perl implementation https://github.com/davidfetter/DBI-Link
There is a DBD driver for DB2 http://search.cpan.org/dist/DBD-DB2/DB2.pod
Or you can use a mentioned fdw wrapper - there is ODBC wrapper
https://wiki.postgresql.org/wiki/Foreign_data_wrappers#odbc_fdw and you can
access DB2 via generic ODBC DB2 driver

jdbc-fdw should work too.

https://github.com/atris/JDBC_FDW

merlin