Thread: FDW with DB2
Has anyone used PG with DB2(Linux) ?
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
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.
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 Steven > > Will 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! --
Yes of course I respect your time. regards.
Please do not contact me personally, as I'm too busy to provide technical support on a private basis. Thanks for your understanding!