Обсуждение: Connecting to Teradata via Postgresql
Hi All, Anyone here has a teradata box ? Are you able to connect to it from withing postgresql? I would like to pull 1or 2 tables from the box (sync) and was wondering if there's anyway to do that w/o using dbi-link. I actually am trying dbi-link but it seem as though it doesn't support DBD::Teradata. Based on the error descriptions, and some googling, seems like Teradata.pm does not support the "column_info" DBI method of getting the column descriptions and such. is there any other methods available?
On Sun, Aug 30, 2009 at 11:21:55PM +0800, Ow Mun Heng wrote: > Hi All, > > Anyone here has a teradata box? Are you able to connect to it from > withing postgresql? If you can get me a test environment including Teradata, I'd be delighted to add support to DBI-Link, most likely in the form of examples. Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
On Sun, 2009-08-30 at 23:21 +0800, Ow Mun Heng wrote: > Anyone here has a teradata box ? Are you able to connect to it from withing > postgresql? > > I would like to pull 1or 2 tables from the box (sync) and was wondering if > there's anyway to do that w/o using dbi-link. > > I actually am trying dbi-link but it seem as though it doesn't support > DBD::Teradata. > > Based on the error descriptions, and some googling, seems like Teradata.pm > does not support the "column_info" DBI method of getting the column > descriptions and such. > > is there any other methods available? The open source version of DBD::Teradata is a cut down version and I doubt this would be the only problem with it. Have you tried the licenced version? If that doesn't work then probably best to report it to the authors. Otherwise, I'd do a bteq export in CSV format and reload using COPY. It's likely to be faster too. -- Simon Riggs www.2ndQuadrant.com