Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting to Teradata via Postgresql

Connecting to Teradata via Postgresql

From
"Ow Mun Heng"
Date:
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?

Re: Connecting to Teradata via Postgresql

From
David Fetter
Date:
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

Re: Connecting to Teradata via Postgresql

From
Simon Riggs
Date:
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