FDW with DB2
On 04/06/2018 01:01 PM, Ravi Krishna wrote:
Has anyone used PG with DB2(Linux) ?
Looks like the way you go about it is with the ODBC FDW.
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
On Fri, Apr 6, 2018 at 4:09 PM, Joshua D. Drake <jd@commandprompt.com>
wrote:
On 04/06/2018 01:01 PM, Ravi Krishna wrote:
Has anyone used PG with DB2(Linux) ?
Looks like the way you go about it is with the ODBC FDW.
https://wiki.postgresql.org/wiki/Foreign_data_wrappers
There are two ODBC drivers. One does not compile and the other one piggy
backs
on a community effort for Cartodb. Looks like Db2 is used by very few and
even less want a divorce from DB2 -> no motivation to write native FDW like
that for Oracle :-)
On Fri, 6 Apr 2018, Ravi Krishna wrote:
There are two ODBC drivers. One does not compile and the other one piggy backs
on a community effort for Cartodb. Looks like Db2 is used by very few and even less want a divorce from DB2
-> no motivation to write native FDW like that for Oracle :-)
the CartoDB ODBC driver works quite well. I've used it to move a large
amount of data from DB2 and Netezza databases.
--
the CartoDB ODBC driver works quite well. I've used it to move a large
amount of data from DB2 and Netezza databases.
Hello Steven
Will it be OK if I or my team reach out to you for any guidance/help.
On Fri, 6 Apr 2018, Ravi Krishna wrote:
the CartoDB ODBC driver works quite well. I've used it to move a large amount of data from DB2
and Netezza databases.
Hello StevenWill it be OK if I or my team reach out to you for any guidance/help.
To the extent that questions on this are considered appropriate for
psql-general, you can post them here. Problems with CartoDB's code should
be raised as an issue on their GitHub project.
Please do not contact me personally, as I'm too busy to provide technical
support on a private basis. Thanks for your understanding!
--